When your sources shift beneath you, the fastest teams adapt at the metadata layer. WhereScape 3D 9.0.6.1 focuses on precisely that: making your modeling, conversion rules and catalog imports more aware of where data comes from and how it should be treated in-flight. Fewer manual edits. Smarter defaults. Cleaner lineage.
We are calling this the ‘Source Aware’ Release – read on for what it unlocks.
Source-Aware Type Mappings
What changed: new %source_table_name and %source_column_name variables are now available inside data type mapping transform codes.
Why it matters: time and date conversions, locale quirks, or source-specific exceptions often force manual edits. Injecting the source table and column into your transformation logic lets you drive consistent behavior by rule rather than by hand.
Practical impact:
- Apply time-zone or locale rules by source without branching templates.
- Standardize tricky data types when upstream teams rename columns.
- Reduce one-off fixes when promoting across environments.
Purview Imports That Speak Column Names
What changed: CSV and TXT imports from Microsoft Purview now bring in column names rather than position numbers.
Why it matters: catalogs are for humans and machines. Naming-level fidelity improves lineage, matching, and model generation.
Practical impact:
- Stronger alignment between governance and design.
- Fewer mapping edits before conversion rules can run.
- Smoother handoffs to automation and downstream documentation.
Conversion Sets: Seven Upgrades For Everyday Velocity
We updated the default conversion sets shipped with 3D to reduce manual work and sharpen Data Vault ergonomics.
Highlights include:
- Consistent Link hash ordering: updated Hash Key Generation ensures predictable link key construction.
- PIT from Views – target-aware: PIT generation now includes target platform specific transformations.
- Multi-active satellite IDs: automatic sequence generation when no multi-active natural key exists.
- Create Loads – smarter reuse: supports one source column feeding multiple DV targets cleanly.
- Business Vault generation: improved naming fidelity during BV creation.
- Artificial keys cleanup: removes superseded business key relationships when surrogate keys replace them.
- RED export preparation: broader invalid character removal for cleaner round-trips.
Small Fixes That Remove Big Friction
Quality improvements that smooth daily work:
- View and copy WhereScape-provided workflow sets in Workflow Manager.
- PostgreSQL discovery correctly identifies a table’s database.
- Word documentation diagrams generate reliably.
- XML import handles encoding reliably.
- Case sensitivity filter behaves as expected.
- Data type mapping names now have stronger validation to prevent broken configs.
- Entity and Attribute Ratings are now copied to new categories, during the advanced copy operation; especially useful for sensitive data.
Platform-Aware Mappings Out of the Box
We added missing transformations across common routes so you do not have to:
- SQL Server to Snowflake
- SQL Server to Teradata
- SQL Server to Generic
A Day-Zero Scenario: From Catalog To Conversion
- Import sources from Purview – 3D now reads column names directly.
- Profile and discover – PostgreSQL and other sources resolve accurately.
- Apply your standards – conversion sets handle hashing, PIT, multi-active satellites, and BV generation with fewer edits.
- Export to automation – RED export preparation cleans naming and characters for deployment.
Result: a shorter path from governed metadata, to executable design.
Why It Matters
- Less manual intervention: source-aware mappings cut repetitive transforms.
- Governed by default: Purview column-name imports tighten catalog alignment.
- Faster Data Vault delivery: upgraded conversion sets accelerate raw vault, business vault, and PIT patterns.
- Fewer surprises in CI: validation and naming fixes prevent run-time breakage.
Recap: Release Highlights
- New %source_table_name and %source_column_name variables in data type mappings.
- Purview CSV and TXT imports now use column names.
- Seven conversion set upgrades for hashing, PIT, multi-active satellites, and BV generation.
- Workflow set visibility and copy in Workflow Manager.
- Discovery, documentation, encoding, and validation fixes.
- Added transformations for SQL Server to Snowflake, Teradata, and Generic.
Ready to try 3D 9.0.6.1 ‘Source Aware’ features in your environment? Reach out to us for a demo to get started or contact us for a walkthrough of the new patterns in action.
