Here you can download the D♯ Engine 4.2.2 and earlier executables. For installation instructions please refer to Installation Guide.
Downloads available for Partner Administrators only. To view the download links you must log in or contact your Partner Adminstrator.
Version 5.2.3 Studio - Data Catalog
Release date: 2025-11-21
Major update to Data Catalog
- Full Data Catalog Model supported – load any supported data from external sources
- DSharp Studio now updates Data Catalog even for partially generated model
- During deployment
- By request (dedicated command)
- Add external comments to any element
Version 5.2.2.1 Studio
Release date: 2025-08-20
Summary
This is a hotfix release to address bugs with Fabric platform DW scripts and case sensitivity. Also notification for post-conversion analysis was fixed.
Bug fixes
- Fabric platform scripts had hard-coded schema references left. Now it follows settings.
- Target platform case sensitivity for names is checked in post-conversion analysis.
- Error messages for post-conversion analysis are now displayed correctly.
Installation Notes
Fabric platform DW Core should be reinstalled.
Version 5.2.2 Studio
Release date: 2025-08-12
Summary
This upgrade introduces a major update to Data Catalog as well as the requested Find command to quickly navigate to where you want to go in the model. Also included are some general improvements and of course bug fixes.
New Features
- Data Catalog – Substantial upgrade.
- Supported contents now include company infrastructure, integration processes and reporting solutions.
- While DSharp Studio still provides model and generated content to the DC database, any supported content can be collected by the organisation using any appropriate means and then loaded into the DC through the external schema interface.
- Element descriptions for DC purposes can be maintained outside DSharp Studio for any element. This is true for Conceptual model content as well as generated content.
- Dedicated command for updating the Data Catalog content. Update only the model content when in Design Mode!
- Note: generated solution metadata will only be exported to the Data Catalog after a complete build.
- Find – Search for a text in model elements and mappings
- Searches for the search string in element names and descriptions and some selected properties, as well as from mapping files.
- Hint: search for schema, table, column, class or property name using the separator ”;” to target mapping files. Example: “;My class;” finds all mappings to class named My class.
- Hint: omitting the separator essentially works as a wild card, case “;My class” or “My class;”.
- From Stereotypes pane, quickly find all elements assigned to selected Stereotype.
- Modeling
- Added attribute datatypes validstartdate/validenddate, validstarttime/validendtime to be used with attributes denoting record validity.
Improvements to existing features
- Database
- EndTask procedure updated in template files to support CI/CD and concurrent logging.
- Added log views to Fabric implementation.
- Fabric deployment now supports adding and altering table columns.
- UI
- Note editing has been made simpler.
- In Tagged Values view, double-click on a Tagged Value to open the Stereotypes view and show its definition.
- Streamlined internal UI handling in general.
- “Up” navigation command in Model editor to open the parent model in the Model editor.
- Analysis
- Post-conversion analysis analyses the generated database structure to find non-uniquely named database objects, in order to identify possible problems in the conversion process.
- Added analysis to find class names that are different but that would result in the same database object name.
- Added analysis for Stereotypes and Tagged Values.
- For analysis that finds unmapped classes, added corrective action to copy the unmapped class to the clipboard for a quick paste into the mapping file.
- For analysis CL-KEY-11, added corrective action to set all key components’ Rate of Change to Never.
- Other
- Added Stereotypes and Tagged Values to HTML documentation.
Bug fixes
- UI
- Sorting elements in Property Grid showing a Business Key with partially obscured name no longer crashes the application.
- Default model for AI is now saved correctly.
- Mappings
- Column numbering now works correctly when using same source column for several target properties in mappings.
- Fixed analysis CL-MAP-09, which incorrectly identified some classes as not being mapped.
- Deployment and SQL generation
- Failure to create SQL for a class view no longer crashes the application.
- Fabric and Synapse class views and procedures now always use the correct schema for hash calculation.
- Fixed error where long object names would be shortened inconsistently.
- Other minor fixes
Version 5.2.1.2 Studio
Release date: 2025-05-22
Summary
This is a hot fix release.
Mapping Related Errors
-
Fixed mapping analysis that found false criticals
Version 5.2.1 Studio
Release date: 2025-05-13
Summary
This is a bug fix release.
Features
- Mappings can now be opened in Run Mode as read-only.
Mapping Analysis Improvements
- Several new analyses for catching missing aliases in different scenarios.
- Classes that are not to be converted are no longer analyzed when transitioning to Run Mode, their analysis errors no longer interrupting the process.
- New analysis that produces a Critical error when two columns from the same table are mapped to the same attribute.
- A class-to-class mapping with an Undefined mapping type is now caught during analysis, no longer crashing the app.
- Analysis now finds more cases where the primary keys and foreign keys may have been declared the wrong way.
- Some analyses handled mapping rows that have been marked for skipping, this is now fixed.
- Unmapped columns that when mapped would end up as hashed values in link tables and when missing may cause a failed installation are now caught as non-critical errors during analysis.
- Non-implemented source classes for a derived class are now handled correctly during analysis.
Bug Fixes
Mapping Related Errors
- Fixed error where distinct keyword did not work correctly with aliased classes, leading to the inclusion of non-mapped columns in the work table, essentially breaking the distinct functionality.
- Fixed error where unmapped non-key columns in aliased mapping groups were copied to the work table.
- Fixed error where pk columns repeated several times in work table for some classes selected for conversion.
- Fixed case where a mapping to a class that has no properties caused a crash.
Derived Classes
- Derived class that has only non-implemented source classes now gets a valid select clause in its implementation.
- Materialized derived class now correctly gets a hash column that does not accept null values.
UI
- Fixed error where order of attributes changed when class was dragged to mapping worksheet.
- Stereotypes can now be assigned in Modeler Edition.
- Users can again edit class descriptions in Glossary.
- Fixed a bug where the selected row in Glossary did not update the rest of the UI accordingly.
- Fixed a number of cases that caused the app to crash when closing windows or transitioning back to Design Mode.
- Fixed a bug that caused some classes to get their Implement value set to true without user interaction (including all new classes). This could also cause the project to appear changed and in need of saving almost immediately after opening it.
- App no longer freezes when setting Open last project as startup behavior.
- Fixed an error related to how the initially saved Project Root directory was handled, causing the app to freeze.
- Fixed Stereotype / Tagged Value Definition behavior where the UI was not perfectly synced with the internal data model.
- Fixed bug that caused some projects imported from VP to crash when saving to native format.
Version 5.2.0.2 Studio
Release date: 2025-04-07
Summary
Hot Fix.
Bug fixes
- Fixed two potential crashes related to models imported from Visual paradigm
Version 5.2.0 Studio
Release date: 2025-03-27
Summary
This release introduces more ways to create models and related content. Some notable features:
- Use sandbox models for safe prototyping and ad hoc demoing without touching the implementation model
- Create Business Case descriptions to describe business use cases, processes and other relevant information, and generate a base model from it using AI
- Extend existing elements with important additional information using standard UML extension mechanisms
- Extending the Design Mode functionality towards data browsing, use the class as the interface to the actual data in the DW by just clicking it and seeing its content in the Data Grid
New Features
- Sandbox models: isolated models for ad hoc modeling.
- Use in demos, workshops and other interactive or backoffice situations where you want to quickly sketch model structures, try out alternative ideas or demonstrate application functionality without risking breaking the implementation model.
- Business Cases: capture the stories of the Business.
- Simple hierarchical structure to organize descriptive information about specific business use cases or the business in general, with the purpose of refining the information to model form, or just keeping it as additional background information.
- Stereotypes and Tagged Values: UML extension mechanism
- Extend the built-in element properties by creating custom sets of properties to be assigned to model elements.
- Use Stereotypes to classify elements (for example, “GDPR” Stereotype assigned to a class or attribute means that GDPR directives should be considered in its implementation).
- Build Stereotypes with appropriate Tagged value sets to keep track of administrative details regarding the model elements (for example, track class state, planned deployment date, owner, business area and other specific details of interest).
- AI support for content creation
- Supported AI service providers with chat completion: OpenAI, Azure AI
- Let AI create a complete Sandbox model with classes that it has identified from the Business Case material. Best used as a quick way to get things going: from available textual material, generate a something to build on for the first workshop.
- Light Git integration (Viewer Edition only)
- Check git status, pull and refresh project
- Design Mode Class-based data browsing
- Define your DW connection as the Default connection and then see your DW content in the Data Grid by just clicking a class anywhere in the UI.
- Open Project Folder: From the File menu, quickly open the folder where the project is stored.
- Denormalize class command
- Quickly derive a new easier-to-use class from an existing one. The denormalized class contains all of the properties of the original source class, and also each property of any class it references.
Improvements to existing features
- New Derive menu for commands that create new content from existing
- Save As command now asks for project name and creates a new project folder that the project is saved in. Previous functionality could wipe out any directory content if the user made the wrong folder choice.
- Added Trust Server Certificate checkbox to Connection properties
- Streamlined and simplified the implementation of Derived classes
- You can now have derived classes without any sources. These will be installed as views that look and work as expected, but they only return the ghost row. Hence you can prototype an entire class structure and start building your star schema on top of them while waiting for the actual data to arrive.
- Derived classes are no longer partially based on generated Business Vault tables. These tables have previously been created, but no automation has ever existed to load them, hence they have remained unused. As they are no longer generated, but previously installed tables may still provide the ghost row to the class view, some Derived classes may now return no ghost row at all, if their other mapping properties are set to omit it. Should your implementation in these cases depend on the existence of a ghost row, you should check the generated SQL code for any Derived class that you have installed previously and are now re-installing with this version. Running the Upgrade to 5.2.0 command lists all Derived classes that should be checked.
- Quick Input can now handle references to classes that are defined below the class that references them, so the user does not need to think about the reference order any more when writing QI scripts
- Added customizable Default project root path to Application Settings
- New analysis that catches the case where the same column has been mapped to the same property more than once within the same mapping group, previously causing a crash when generating the solution
- Synchronized the use of the keyboard Del key and the UI Delete command in several UI components
- Approving a key change now retriggers the class analysis
- Streamlined the registration process when running the application for the first time
Bug fixes
- Hint text for class in the Model Editor now correctly displays the current state of the class
- Change in Key definition can no longer be approved if there are no key components selected
- Fixed a bug that caused the focus occasionally shifting from the active pane to another, interrupting the workflow
- Fixed a bug where the Connection would stop working in the Connections tree
- Undo Last Load command fixed for PostgreSQL – now uses timestamp datatype for identifying rows to be deleted
- Now all classes referenced in class-to-class mappings’ Property assignments are considered for automatic materialization according to their Materialization settings
- Fixed a bug in the DW conversion that was reported as a mapping error (although mappings were fine), but the situation was addressed in a later stage during the conversion process. This would appear to occur randomly, and it depended on the order in which the classes were selected for conversion. In the end, the selection order did not matter, so displaying the error message was the actual bug.
- Fixed a bug where a specific one-to-many column mapping would create columns in tables where they don’t belong
- Mappings that map one and the same column to more than one attribute within the same mapping group are now handled differently. In all likelihood all previous installations have worked correctly, and so even this new release will produce the same result, but the user is advised to check this situation when re-installing classes that have a mapping like described. Running the Upgrade to 5.2.0 command lists all mappings where this error could occur.
Note When Upgrading
For each project you are upgrading, run the Help → Upgrade → Upgrade to 5.2.0 command (and earlier, depending on from which version you are upgrading). This command will list each derived class as well as mapping situations that should be checked before reinstalling previously installed classes.
Version 5.1.1 Studio
Release date: 2024-12-20
New Features
- Diagrams
- Export active diagram to file.
- Diagrams are now zoomable.
- Analysis
- Analysis for finding unmapped association that should go to link table.
- Analysis for finding primary key and reference key information from aliased mappings (there should not be any).
- Added analysis that catches element names that will not be unique anymore when translated to database object names, hence crashing the installation.
- Association pointing to a non-implemented class no more leads to a critical error if mapping is missing for that association.
- Analysis that catches case where items that are needed to complete the mapping are missing from the mapping row (ie column name, property name).
- Run Mode
- For a class, use context menu to quickly locate any table or procedure generated for that class in the Models tree.
- For generated tables and columns in the Models view, use context menu to quickly locate the class or property that the table or column has been generated from.
Improvements to Existing Features
- Associations are now initially alphabetically ordered in the Models view.
- Streamlined the Model Analysis pane behavior when transitioning between Design and Run modes.
- Disabled CL-KEY-11 analysis (check for whether key definition contains properties with Rate of Change other than Never) for “no key” Key definitions, as this is irrelevant in that case.
Bug Fixes
- UI
- When activating elements in the Models tree using a UI command (for example, the Show in Models command in the Model Editor), the tree view now correctly always shows the activated element and you don’t need to scroll to it manually.
- Class Diagram now reacts correctly to changes in displayed associations’ properties.
- Cell being edited in Mapping Editor is now committed when user saves project or mapping file without explicitly committing the edit.
- Fixed misleading “Save in Progress” message when user tries to close the application while returning to Design Mode.
- Quick Input now generates a 0..1 instead of a 1 cardinality in the “upper” end of a self-reference.
- Changes in key definition’s key component structure were not saved unless changes were explicitly approved. Now they are correctly saved as unapproved.
- Models tree selection sometimes behaved erratically when creating new classes using Quick Input, resulting in unwanted associations.
- Fixed self-reference drawing case where self-reference would result in a “triangle” with both association ends attaching to the same connection point.
- Re-instated the Settings window for Modeler Edition.
- Fixed a bug that caused the Data Grid not to show the content of the selected class in Run Mode.
- Fixed a crash in the Data Flow diagram that happened if a data flow was selected when expanding classes to show more flows (usually when pressing ctrl-A + expand)
- Fixed Help…Open Tutorial HTML commands so that they open the current version of the course material.
- Fixed rare case where application would crash when exiting Run Mode.
- Analysis
- Fixed bug where the syntactically correct key group definition “* = !s” triggered a critical error message.
- Code generation
- Fixed case for “No key” key definitions where partition by and order by statements did not work correctly on case sensitive platforms.
- On platforms where generated object names need to be shortened, constraint names could sometimes end up being non-unique, and installation would fail. This has been fixed.
- Fixed error where brackets in table names caused installation of state update procedure to fail.
- Fixed error in view generation code that would result in a non-matching join on case sensitive platforms.
Version 5.1 Studio
Release date: 2024-11-04
New Features
- Viewer Edition for viewing and browsing a model
- Data Flow diagrams can now be used to view and browse Class-to-class mappings (for derived classes and standard classes alike)
- Model Editor
- To override Intelligent Cardinalities, press alt while dropping a new association end to create a 0..* → 1 multiplicity
- Possibility to create new connection points for associations
- Ctrl-click the class border to add a connection point
- Ctrl-click a connection point to remove it
- Keeping ctrl pressed when releasing the association end on top of a class creates a new connection point where the association line enters the class
- Use Glossary sorted by Class as a lightning-fast search mechanism: scroll to the class and double-click it and the class will be shown in the Models tree
Improvements
- UI
- Loading and saving a project is now much faster
- Opening a project saved with a newer version of the software will produce a compatibility warning
- Overall performance improved: larger model now don’t slow down the application
- General streamlining of the Model Editor
- Tutorial scripts and functionality improved for the Expert course
- Analysis
- Reference to non-BK class using derived association no longer considered a critical error
- Improved error messages for missing properties in mappings
- Added analysis for missing role name in self-reference
- You can now create a Deployment package from the class’ context menu
- For example, if you are working with a scattered set of classes, save these in a Class Diagram. To operate on them, select some or all (ctrl-A) of them to install them easily in one go
- Email verification now happens without restarting application
- Command Help.Error Log now opens error log directory instead the latest error log file
- DW Generation
- Performance enhancement
- Error table handling is faster during hashing
- State tracking handling is now faster
- During hashing, a row that gets a null hash value is automatically moved to the error table
- Performance enhancement
Bug fixes
- Mappings
- Alias no longer “leaks” to next unaliased mapping set
- Fixed situation where a Critical error while converting model left application in ReadOnly mode
- For multi-source classes, Batch Load now correctly selects sources to load and automatically applies the version column as the sort column
- Fixed PostgreSQL string concatenation bug
- Context menu content problems in certain scenarios fixed
- Fixed crash when generating HTML documentation
- Other crash fixed
Technical
- Upgraded .NET Framework 4.8 to .NET 8.0 LTS
Version 5.0.3.2 Studio
Release date: 2024-09-13
Improvements
- Enhanced performance of class/model analysis
- SQL output mode setting is now saved to preferences
- Added build number to about dialog
- Added possibility to select naming convention for certain database schemas
- DSharp naming convention
- Data Vault naming convention
- Medallion naming convention
Bug fixes
- Fixed bug where while hashing classes with more than one reference to another class, identical join aliases were created
- Empty json file does not stop the loading of the project anymore
- Fixed crash during loading or saving mappings when the mapping file was locked by another program such as Excel or Open Office
- Fixed problem where some commands performed the task twice (for instance, generated the same SQL commands twice, or created two new attributes instead of one)
- Fixed bug when creating a derived class from a “normal” class lost the key information of the original class
- Fixed Postgres argument count for concat function
- Other minor fixes
Version 5.0.2.1 Studio
Release date: 2024-08-07
Bug Fixes
- Fixed Fabric SQL syntax error when reverse-engineering database structure in Connections
Version 5.0.2 Studio
Release date: 2024-06-28
User Interface
- Sort attributes in Models tree using a number of sorting algorithms
- Context menus now work on multiple selections
- More informative confirmation messages when deleting elements
- Better error messages for duplicate mapping rows in mapping files
- Parent schema now visible in diagram’s table shapes
Model Analysis
- Mapping to a non-existent class is now a critical error
Database Connections
- Imported associations now get the correct Rate of Change = Low
- Column sizes now correctly imported to mapping files when dragging from Connections
- Submodels automatically created for databases and schemas when importing using the Import command (not when dragging & dropping)
- Added application option for configuring how imported foreign keys should be handled
Modeling Enhancements
- Self-reference multiplicities now default to 0..* – 0..1
- A NoKey class can now also be implemented as a non-transaction
Bug Fixes
- Fixed Fabric SQL errors caused by case sensitivity
- Fixed so that all mapping columns remain accessible when other wide columns force them outside the view
- Orchestration procedures now visible in the generated DW Model hierarchy
- where-clause and distinct keyword now correctly added to all hash procedures
- Fixed hash call format for PostgreSQL
- Mapping Files menu items now correctly displays all mapping files associated with the project
- Other minor fixes
Version 5.0.1.4 Studio
Release date: 2024-06-12
User Interface Enhancements
- Scroll Model Editor using mouse and arrow keys
Misc Fixes
- Removed unused fields from JSON files
- Streamlined switching to Run Mode
Bug Fixes
- Added missing Fabric templates to installation package
- Fixed typecast error that prevented reading some project files
Version 5.0.1 Studio
Release date: 2024-05-30
New Features
Model documentation
Better support for creating documentation for conceptual and ER models.
- Modeler version can export HTML documentation of Conceptual Model
- Conceptual Model can be exported without using Run command in Studio
- Documentation is opened in browser after export
- Better export performance
User Interface Enhancements
General
- UI is more responsive during long tasks
- Improved error logging and message format
Model Analysis
- Corrective actions display target elements in the property grid
- Key groups are matched against sources
- Source priority sources must exist
Database Connections
- Changed name Database filter to Database
- Only one database can be listed per connection
Modeling Enhancements
- Delete element dialog displays information about selected elements
- Add semantic data type: Phone number
- Association end class can be changed in the property grid
Bug Fixes
-
Fixed several Model Editor related crashes
- Fixed Mapping files to point to old destination after Save As
- Data grid did not react to selection changes
Version 5.0 Studio
Release date: 2024-05-07
All-in-one Modeling and no-code DW Automation tool.
Design Mode
- Design your model any way you want, including importing it straight from the source
- Map the model to the source data
- Realtime Class Analysis identifies unfinished tasks, and even provides one-click commands to complete them
- Choose any classes to implement in Run Mode – just convert what you’re working on
- Version control and collaboration through 3rd party solutions, eg Git
Run Mode
- View the generated table structures and SQL code
- Deploy the solution
- Run generated SQL queries, including starting load processes and querying data with automatic joins
- After deployment, just click on Conceptual Model classes to view their data
- In essence, the same functionality as the previous 4.2.2 version
Fabric support
- Added Fabric as new target platform
Design Mode Highlights
- Create and maintain UML-inspired Conceptual Models
- Encourages organizing the model into readable and manageable submodels
- Functionality for keeping the model tidy using the automatic organizing commands
- Focus on modeling business concepts
- Also for generic modeling purposes
- Model editors only show what’s relevant in the context of the submodel being edited
- When opened, Model editors are automatically purged from classes that don’t belong there
- Be in the flow
- When you are modeling, DSharp Studio lets you focus on just that, not bothering you with details and minor mistakes
- Once you’re ready to go into details, open Class Analysis, which provides you with suggestions and unfinished tasks in real time. It also conveniently gives you a list of corrective actions as clickable commands that solve the problem or finish the task without you needing to specifically find it in the UI and fix it.
- Full Model Analysis when pressing Play to enter Run Mode catches the critical errors that need your attention before generating the solution
- Inspect the model at your desired level of detail: Zoom in and out using Model editor & carefully designed submodel hierarchy
- At the lowest level, only view classes at that detail level
- At any higher level, see a larger model view containing all lower levels
- At the highest level, view the entire model
- Database access
- Create database connections to access data and table structures
- Reverse-engineer a model from an existing database
- Browse data in the Data Grid
- Efficient Power User features and one-click batch commands
- Create correct type of class with one click
- Create association and new associated class with one click
- Create several new associations between multiple classes with one click
- Create entire models using the simple text-to-model Quick Input syntax
- Add same set of attributes to multiple classes with Quick Input and one click
- Define the business keys for several classes with one click
- Copy classes to paste them as csv or Quick Input format
- Diagrams (as opposed to Model editors)
- Diagrams are for presenting, not modeling
- Add any classes to diagrams and design your own layout for varying purposes
- Use Ad Hoc diagrams for quickly querying the relationships between classes or show specific parts of the model
- All detailed object properties are editable in the Property Grid
- Document any model element in the Documentation pane or Glossary
- 3:rd party modeling tool compatibility same as version DSharp Engine 4.2.2
- Import and save to native 5.0 project format
- Visual Paradigm export files
- Ellie export files
- Import and save to native 5.0 project format
- Select just the classes you want to convert before pressing Play to go into Run Mode
- Entire model needs to be converted only when you need to install orchestration procedures
- When transitioning to Run Mode, the analysis mechanism reports mapping related errors
Run Mode highlights
- For quick reference, only converted classes are shown in Class Implementation pane
- View generated Staging, Processing, Storage and Model Layer objects (tables, views, procedures) that implement the class
- Models view
- Conceptual Model available as the main go-to structure for all operations
- Run any data operation directly on the class, no need to find the actual database objects involved
- View the generated DW Model directly in the Models pane alongside the Conceptual Model
- Deployment and maintenance tasks
- Just select the desired classes and deploy them
- Find database objects to drop, clear or reinitialize
- Process the data
- Run the ETL process, or any parts of it
- Identify referential integrity or data quality issues
- ER-Diagrams
- Use ER-Diagrams to actively browse the generated database table or view structure
- Expand to closest neighbor, or recursively as far as it goes in selected direction (incoming or outgoing references)
- Data Flow Diagrams
- Use Data Flow Diagrams to actively trace the data flow between tge generated database objects
- Expand to closest neighbor, or recursively as far as it goes in selected direction or both (incoming or outgoing data flows)
- Data Grid
- Run SQL queries by clicking the classes in the Models pane (or any table or view object anywhere)
- SQL code
- View the SQL code of any generated object
Known issues
- UI
- Context menu may display different items depending on how it was opened (tree view, activate treeview item explicitly before right-clicking, or directly right-clicking)
- Copy/Pasting classes only copies the classes’ attributes (keys, associations etc omitted)
- Some command buttons in tree views and diagrams appear to be enabled when the tree view / dialog is not active, but become disabled once clicked. Use main menu/main toolbar commands instead.
- Ctrl-z in diagrams may behave erratically
- Progress bar not displayed during all lengthy operations
- DW Conversion
- Aliases “bleed” to the next aliasless mapping. Workaround: put mapping groups with aliases last in the mapping file
- Classes with no key may not always get the hash index included in the hash calculation
Version 5.0 Modeler
Release date: 2024-04-09
Standalone Conceptual Modeling Tool
- Create and maintain UML-inspired Conceptual Models
- Encourages organizing the model into readable and manageable submodels
- Functionality for keeping the model tidy
- Focus on modeling business concepts
- Use model created with Modeler Edition to generate a DW solution with the upcoming full version of DSharp Studio
- Also for generic modeling purposes
- Model editors only show what’s relevant in the context of the submodel being edited
- When opened, Model editors are automatically purged from classes that don’t belong there
- Inspect the model at your desired level of detail: Zoom in and out using Model editor & carefully designed submodel hierarchy
- At the lowest level, only view classes at that detail level
- At any higher level, see a larger model view containing all lower levels
- At the highest level, view the entire model
- Revamped UI look-and-feel
- Create database connections to access data and table structures
- Reverse-engineer a model from an existing database
- Browse data in the Data Grid
- Efficient Power User features and one-click batch commands
- Create correct type of class with one click
- Create association and new associated class with one click
- Create several new associations between multiple classes with one click
- Create entire models using the simple text-to-model Quick Input syntax
- Add same set of attributes to multiple classes with Quick Input and one click
- Define the business keys for several classes with one click
- Diagrams (as opposed to Model editors)
- Diagrams are for presenting, not modeling
- Add any classes to diagrams and design your own layout for varying purposes
- Use Ad Hoc diagrams for quickly querying the relationships between classes or show specific parts of the model
- All detailed object properties are editable in the Property Grid
- Version control and collaboration through 3rd party solutions, eg Git
- Document any model element in the Documentation pane or Glossary
- 3:rd party modeling tool compatibility same as version DSharp Engine 4.2.2
- Import and save to native 5.0 project format
- Visual Paradigm export files
- Ellie export files
Known issues
- Context menu may display different items depending on how it was opened (tree view, activate treeview item explicitly before right-clicking, or directly right-clicking)
- Copy/Pasting classes only copies the classes’ attributes (keys, associations etc omitted)
- Some command buttons in tree views and diagrams appear to be enabled when the tree view / dialog is not active, but become disabled once clicked. Use main menu/main toolbar commands instead.
- Ctrl-z in diagrams may behave erratically
- Progress bar not displayed during all lengthy operations
Version 4.2.2
Release date: 2023-11-14
Fixes
- Mapping handling
- Now finds more mapping errors
- Fixed an issue when source table for hashing procedure could not be correctly identified, causing a crash
- Overall better handling of “dummy” columns
- Hashing
- Fixed issue when _orig column was incorrectly handled when the incoming value had an ad hoc transformation
- Synapse
- Now correctly extracts table metadata from Synapse source/target database
- Deployment package
- Fixed issue where work table was not recreated in a multi-database solution
Version 4.2.1
Release date: 2023-09-22
Fixes
- Fixed a bug where the D♯ Engine client would sometimes create a different UID not previously registered on the License Server, leading to a failed license retrieval
- HTML documentation
- In Class documentation, the Natural key components are bolded and italicised in the Properties table
- Textual documentation is now formatted as paragraphs instead of continuous text
- Fixed crash that happened if D♯ Engine was started but no license was selected in several minutes
- Deployment package
- When deploying classes, the number of non-implemented classes to be deployed is reported to the user
- If no implemented classes are deployed, the Deployment package will not be created at all
Version 4.2.0
Release date: 2023-06-30
Features
- License service
- Licenses now stored on and queried from DSharp’s License Server
- Moving licenses between developers now easier
- Same D♯ Engine installation can be used with multiple licenses/targets
- With no internet connection available, the license information from the previous succeeded connection remains valid for a limited time
- Support for full offline license file
- New software installer
- Preserves existing settings if upgrading on top of existing installation
- Supports having parallel different versions for use with different customers
Version 4.1.0
Release date: 2023-03-31
Features
- Modeling
- Support for prioritising sources when selecting attribute values in the class view
- Omit ghost row option has been added to Class-to-class mappings. Setting this to true filters out the ghost row from the incoming data set defined by the mapping.
- Source data mapping & hashing
- More mapping errors found from the source mappings
- Source mapping error messages have also been improved
- Support for automatically loading only the newest version from a data set containing multiple versions of the same thing
- Faster load process: minimised number of left-joins during hashing
- Procedure code now documents the reason for including or excluding a join. This information can also be used for debugging mappings during development if a join should happen but it doesn’t, or vice versa.
- Check your mapping files! The better you indicate primary and foreign keys, the smarter choices D♯ Engine will be able to make.
- More mapping errors found from the source mappings
- Commands
- New: Load versioned source data in batches as a one-off task
- New: Delete the last load batch from the DW (“Risen Delete”)
- New: “Re-materialize” views; runs the procedure that populates the table
- The SQL code for dropping the object has been added to the De-Installation candidates command
- UI changes and additions
- Technology preview: AI-based Natural Language input in the Data Grid
- Ask D♯ Engine to implement queries, fact or dimension tables based on the selected classes
- Try it out and go wild!
- New Languages pane which shows all the available target platforms’ datatypes as well as all custom transformations available for that platform
- Class mappings: new window that shows the source mappings for both Raw Model and Business Model classes
- The SQL content of the selected items in a Deployment package are now shown in the SQL view
- Class and property names in the UI now directly indicate whether there are issues with that class/property (for example, unmapped properties)
- UI commands have been rearranged. As usual, Help -> Command reference displays all available commands as well as their position in the main menu.
- Telerik UI component upgrade
- Technology preview: AI-based Natural Language input in the Data Grid
- Deployment
- The Deployment package may now include recommendations on how to finalise the deployment manually, if needed
- When deploying objects, the user is given the possibility to also include objects that the original objects depend on
- For example, when deploying a BO class, you may also want to deploy its source classes, because their Materialisation state may have changed
- Course material
- Advanced course tutorial models and scripts have been added to the installation for self-studying
- Material available here
- The course demo data database (also included in the installation) has been redesigned and expanded
- Visual Paradigm models now available for all individual tutorial steps in both the Intro course and the Advanced course
- Advanced course tutorial models and scripts have been added to the installation for self-studying
Fixes
- Soft delete fixed in cases where a hubless class was marked for Soft delete. In such a case the view would always behave like Soft delete was turned on, automatically leading to what in most cases was the desired functionality even without explicitly having to set Soft delete on.
- Removed an unnecessary join from the Class views
- The deployment of the LogErrors procedure was removed from the Deployment package
- Automatic state table updates leading to rows falsely being marked as deleted now removed from the Reload last failed rows command
- Generated join aliases in the hashing procedures renamed in such a way that they don’t end up as reserved words by mistake
- Parameter name “Don’t mark as deleted” changed to “Ignore when setting deleted state”
- Update your ETLParameters table accordingly (see the Upgrade to 4.1.0 command from Help -> Upgrades.)
- Other minor fixes
There are changes in Visual Paradigm Stereotypes (SEStereotypes.xml), so you will need to re-import the file.
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at.
Version 4.0.1
Release date: 2023-01-10
Maintenance release.
- Updated all tutorial folders to now include a full Visual Paradigm model (plus model export) for that tutorial step with support for the latest features
- Fixed error that caused HTML documentation generation to fail
- Fixed error that prevented a FK-referenced unmapped ID column from being copied to the work table, if it was part of an aliased mapping group
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at. Also make sure that you import the latest SEStereotypes.xml file into Visual Paradigm, if needed.
Version 4.0.0
Release date: 2022-12-30
Features
- Synapse support, complete with automatic table distribution logic and indexing model
- Extended source data mapping functionality radically reduces the need for making manual OUT_ views
- Map the same source table to multiple classes
- Good for normalizing denormalized source data and splitting data that clearly contains different sets of information
- Stronger supports the model-oriented approach in that it is easier to not by default follow the source data’s possibly suboptimal structure and to actually design the Data Vault
- Map several source tables within the same schema to the same class
- Replaces the need for OUT_ views performing union operations to merge several source tables into one class
- Map the same source column to multiple properties in same class
- “Copy” or create derived data from the same source column to another attribute
- Create “dummy” columns for special cases
- Create additional metadata to be loaded
- Handle complex primary and foreign keys
- Apply distinct row selection and where-clause to any source data mapping
- Minimize duplicate hashes and leave out rows you don’t want to load
- Especially useful during development
- Map the same source table to multiple classes
- Partial solution generation if parts of model fail validation
- You can restart the Data Vault generation process even though some classes have failed verification. The failed classes will internally be marked as non-implemented before starting the process.
- Deploy parts of model even though other parts are broken.
- Semi-Automating SameAs tables
- Now generated: SameAs-orchestration procedure calling stub procedures for populating the sameas tables. Complete these stub procedures manually, if applicable (many sameas tables can’t be automatically populated using any logic due to the nature of the…sameasness)
- New datatype: geometry (to be used for Business objects only)
- Database filter and Environment type added to Database server metadata in Visual Paradigm
- Create separate server objects for dev, test and prod environments as well as for actual source systems.
- For visual comparison of the different environments
- Telerik UI component upgrade
Fixes
- Reduced left joining when hashing
- Column sizes now created correctly when materializing views as tables
- Materialization procedure now correctly renamed if moved to the raw vault schema
- RAW_ prefix not added to tables when importing table metadata, if the table already has the RAW_ or OUT_ prefix in its name
There are changes in Visual Paradigm Stereotypes (SEStereotypes.xml), so you will need to re-import the file.
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at.
Version 3.2.0
Release date: 2022-09-30
Features
- Database connection
- Connect to source and target servers using native drivers when connecting to Microsoft SQL Server variants, and ODBC otherwise
- In Visual Paradigm, model the Database servers in Infrastructure
- Use Database server stereotype
- Add a working Connection string
- Use placeholders %USERNAME% and %PASSWORD% as necessary. These can be replaced by actual values in the D♯ Engine UI before opening the connection
- For the server that contains the generated DW solution, set Default SQL Target to True to enable class based browsing.
- Explicit Materialization now available for all class types
- Yes = Materialize
- No = Don’t materialize
- Automatic = Materialize if class’ Volume is High or more, or if the class is part of a transformation (for example, directly used as source in a mapping to a BO class, or as part of a transformation path in such a mapping).
- Key Groups now fully functional
- For each class, group sources together that use the same Business key to mean the same thing
- D♯ Engine will then apply the specified prefix in the hashing function, integrating the data within the same key group, and avoiding hash collisions from other sources that may use the same Business key to mean a different thing, or other variations of incompatibility.
User Interface Components
- New: Class Implementation
- Alphabetic list of classes, grouped to Implemented and Non-implemented classes
- For Raw Model classes, shows
- Staging Area objects (tables)
- Hashing objects (work tables and corresponding hashing procedure)
- Raw Vault objects (tables and corresponding load procedures)
- Business Vault objects (class view/table with corresponding materialization procedure)
- For Business Model classes, shows
- Business Vault objects (generated tables as well as class view/table with corresponding materialization procedure)
- For Raw Model classes, shows
- Primary use is to quickly find a class and its implementation. Use together with the SQL pane to verify the implementation.
- Alphabetic list of classes, grouped to Implemented and Non-implemented classes
- New: Servers
- Tree view showing the contents of any registered database server
- Shows Databases, schemas, tables, views, columns, primary keys and foreign keys
- Primary use is to browse structure and data and to provide mapping information
- Default SQL Target is used for providing example data to HTML documentation
- Tree view showing the contents of any registered database server
- Improved: Data Grid
- Now has the same syntax-aware SQL editor as the SQL pane
- Click anywhere on any class or data object, real or virtual, to browse its data
- For classes and generated tables and views, queries the data from the SQL Target server, which can be set in the Properties of the database server
- For real server objects, shows the content of the actual clicked table or view
- Mapping Editor
- Brings the Source-data-to-Model-element mapping process inside D♯ Engine
- Use the familiar spreadsheet layout to edit the mappings
- Create new mapping files with automatic numbering
- Create mappings by dragging and dropping from the Server and Conceptual model panes, either row by row or in larger batches
- For instantaneously correct pairing, click on the model elements in the order you want them to be inserted into the file
- Save & refresh!
Fixes
- # as attribute visibility (protected) in Visual paradigm now correctly generates the hash function call for the attribute value in the Business Layer
- Fixed an issue that caused some UI Panes to remain without a name/caption
- Model analysis when opening a model now identifies classes within the same domain (Business Model, Raw model) that have the same name
- Checking the AlreadyHashed-column in a mapping file now correctly handles the column when hashing
There are changes in Visual Paradigm Stereotypes (SEStereotypes.xml), so you will need to re-import the file.
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at.
Version 3.1.2
Release date: 2022-09-06
This is a minor maintenance release.
Feature
- In the Visual Paradigm Data Vault 2.0 element, Added parameter Nullhash pattern, which is a string value used to generate the hash value corresponding to null, by repeating the string until it fits snugly in the generated hash columns. Default value “-“.
Fixes in the Visual Paradigm Data Vault 2.0 element
- Trimmed list of available Hash functions to MD5, SHA 256 and SHA 512. The selection sets the hash column sizes and the hashing function used in the database
- Installation package now correctly generates the CalculateHash procedure during Full install / DW install, depending on the hash method selection
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at.
You will need to re-import the SEStereotypes file into Visual Paradigm for this release.
Version 3.1.1
Release date: 2022-08-19
This is a maintenance release focused on bug fixes.
Fixes and tweaks
- The text %DATABASE% is no longer present in the deployment package
- Deployment does not back up staging area views anymore if their structure should be changed
- Bracketed table names not used anymore in table name comparisons when running the Full DW Installation command
- Corrected the bug which caused the wrong datatype to be assigned to some view columns
- All database references removed from Azure deployment package
- The ZeroToNull transformation fixed so that it does not assume the input data to be a string constant
- Fixed an error which prevented the SQL comparison operator “different than” (<>) to be used
If you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from. These commands analyse the currently active model for issues that you may need to look at.
Also see the Readme.txt file in the root directory of the installation for information when to re-import the SEStereotypes file.
Version 3.1.0
Release date: 2022-06-30
Features
- Support for automated model based Business Model implementation
- Major functionality boost to Mappings: describe transformations and formulas using model elements and paths, or any target platform compatible code.
Fixes
- Fixed a crash that happened when building a deployment package if the SQL pane was open
Before installing any new generated code with this version, please run the command Help.Upgrades.Upgrade to 3.1.0 for each model to be implemented. This will analyze the model and let you know which issues you need to look at.
In general, if you are upgrading from an earlier version, check the Help.Upgrades menu, and run each of the Upgrade commands that have a version number that is bigger than the one you are upgrading from.
There are changes in Visual Paradigm Stereotypes (SEStereotypes.xml), so you will need to re-import the file.
Version 3.0.0
Release date: 2022-05-13
General
- Branding change: No more SmartEngine, welcome D♯ Engine
- Executable name changed to DSharpEngine.exe
- “Smege”, among friends, does not make sense anymore
- Suggested nicknames: Dshege, Dege, Ege, Endshini, Dshini, …
- License agreement must be accepted in order to run software
- Requires new license file, as the UID changes due to the software name being part of the UID definition.
- Monthly support licenses available: license is target but not developer specific, and can be easily distributed within the company for support purposes (in accordance to support agreement).
Features
- Support for adding new target platforms
- First new platform PostgreSQL: just select PostgreSQL as target in the Infra section’s Data Vault 2.0 settings
- Per project, possibility to turn automatic index management on or off. Useful for Azure projects, as Azure continually optimizes indexes based on actual use. Turn this property on or off in the project’s Data Vault 2.0 settings.
- UI library upgrade
- Deployment mechanism changes
- for quicker installations, work and error tables are now simply dropped and recreated (if needed, manually backup any error tables containing unhandled error cases before deploying)
- all table and view level changes and especially failures while deploying are logged in high detail (remember to always check the log after deployment!)
- more advanced column datatype change handling, for example
- if a column’s new datatype is incompatible with the existing column, the column will be backed up and a new column will be created with the correct datatype. Populating the new column should then be done manually.
- Datatype changes
- new datatypes for specific number of decimal places: decimal1, decimal2, …, decimal38. The default decimal type still supports four decimals.
- idstring is deprecated. Use code instead.
- long and short are deprecated. Use bigint and smallint instead, respectively.
- SQL Pane
- View SQL code for selected database objects
Fixes
- Overflowing Element names are now forced to their platform-dependent maximum length by removing less important characters (vowels, underscores, …) until the correct length has been reached.
- Unnecessary type casts removed from generated views, making them slightly faster
Before installing any new generated code with this version, please run the command Help.Upgrades.Upgrade to 3.0.0 for each model to be implemented. This will analyze the model and let you know which issues you need to look at.
If you are upgrading from a version earlier than 2.7.0, also run the Help.Upgrades.Upgrade to 2.7.0 command.
There are changes in Visual Paradigm Stereotypes (SEStereotypes.xml), so you will need to re-import the file.
Version 2.7.0
Release date: 2021-12-31
- Support for automatic source name inclusion in hash
-
- Even further separate data by source system by automatically adding a source system specific component to the hash, or
- Avoid hash collisions between different source systems that are using same key for different real world phenomena
- No longer need to create an OUT_ only for this purpose
- Same-as support
- Can be used for
- Loading versioned data into a class but displaying only the newest version
- Resolve key changes when old and new keys are known (for example, person id changes)
- Together with source name hash inclusion, further separating the data in the raw vault by source system on hash level, but consolidating them in the view layer.
- Generates same-as table
- The class view may be configured to
- Redirect all incoming references to a master row (ie from old person id to new person id, or newest version)
- Redirect and also filter out irrelevant versions from the view (don’t show old person id’s at all)
- Can be used for
- New transformation: add !Hash to your mapping file’s Transformation column and the field will be hashed
- New command: analyze max length of data for any column
Fixes
- Element names are now trimmed when reading from Visual Paradigm
- Classes with Implement=false are not reported on application startup as having unmapped properties
- If Duplicate handling for a class has been defined as Force uniqueness, the unique index is no longer included in the calculation of the reference hashes, now producing the correct hashes
- Commands/menu structures have been reorganized
Before installing any new generated code with this version, please run the command Help.Upgrades.Upgrade to 2.7.0 for each model to be implemented. This will analyze the model and let you know which issues you need to look at.
Also import the included SEStereotypes.xml as described here. Changes:
- Key consolidation and Key groups parameters added to the following Stereotypes:
- Party, Place, Thing
- Moment – Interval
- Role
- Description
- See Metadata for description of how to use the new parameters
Version 2.6.0
Release date: 2021-09-30
- Integration with the newly released D♯ Developer Community pages
- All tutorial material moved to the community site
- Unneeded indexes no longer created for materialized views’ reference hash columns
- SmartEngine now shows a descriptive error message if the mapping file is locked when opening a model
- The database name is no longer converted to an object name. Eliminates the need for manual fixing of database names containing the ‘-‘ character when generating SQL code.
- Behind-the-scenes cleanup of script code
If you are using materialized views, you may want to re-install them using this version. The reinstallation drops the unnecessary indexes, making the materialization procedure more efficient.
Version 2.5.0
Release date: 2021-06-23
- Major Telerik UI component upgrade and behind-the-scenes UI work, 3 years worth of updates in one go
- Descriptive error message when deployment fails because of unmapped properties
- Unmapped properties listed in separate view after project opened
- UI commands for installing the ghost row, dropping tables and querying views
Version 2.4.1
Release date: 2021-05-14
- More efficient view layer, eliminating real-time hash calculations when referencing Description classes, by
- fetching the hash from the appropriate hub over a join, and
- indexing the BK column in the referenced hub
- Deployment packages can now be built for individual database objects directly from the Server Model pane
- Long index name now shortened if the name exceeds 100 characters
When replacing and older K_ view (or materialization procedure) for an efficiency boost, also remember to re-install all Description type objects that this view references as *_hash columns, so that the indexes are created for the referenced xhub’s key attribute column. This index is required for the new view to be efficient. As an alternative to installing the entire Desctiption classes, you can also make a deployment package with just the individual xhub tables.
Version 2.4.0
Release date: 2021-03-31
- License handling
- A license now has a target, typically a specific customer or a specific solution
- The target name is visible in all generated procedure and view headers
- The target name is visible in the SmartEngine main window’s title bar
- SmartEngine displays a warning in the main window’s status bar once there are less than 30 days left before the license expires
- New analysis functionality
- Link-to-link –situations are automatically detected when analysing the Conceptual model
- UI command: Unmapped attributes listed (attributes with no corresponding data source)
- Datatypes
- Property pane shows the base data of the datatype, including description and how it maps to its appropriate SQL datatype
- Fix: varchar datatypes now implemented with correct template-based sizes
- If changed, the deployment package will try to correct the column sizes for existing tables included in the deployment package
- Comments-column added to most table types
- Existing tables will automatically be altered if included in the incremental deployment packages
- HTML documentation
- Data Lineage information previously only available through the UI now added to the HTML ER-model documentation
- For each table, diagrams with incoming and outgoing data flows on table level, and
- Column level in- and outgoing data flows
- UI reports progress when generating new objects
- Fix: Large deployments (millions of rows of SQL code) no longer halt the SQL code generation due of OutOfMemory errors
- Classes with the Implement parameter set to false can now be “rough and incomplete” without affecting the DW automation
- The calendar dimension now correctly installs when using the Full DW Installation command
- Automatic horizontal scroll bars added to text windows for added convenience
Version 2.3.2
Release date: 2021-01-19
- URL datatype length increased
- Column sizes harmonized
- Now catches non-unique column names when hashing
- When deploying, existing staging area table columns will not be altered
Version 2.3.1
Release date: 2021-01-12
- Commands
- List potentially unused database objects
- Clear DW tables
- Analyze conversion- and reference errors
- “Complete incomplete” data
- Rule based mechanism for marking missing / dependent data as deleted when loading incremental data (but complete within that data set)
- Error analysis
- Conversion / reference error logging
- Added error tables to installation
- Business Layer
- Soft Delete now parameterized
- Satellite naming fixed
- Custom SQL mapping implementation
- Updated Soft Delete tutorial
Version 2.3.0
Release date: 2020-12-04
- Modeling
- Possibility to have an identically named Business- and Raw Model classes. Business Model class will “override” the Raw Model class, which will relocate to the rav vault schema.
- Separate Sterotypes to denote Business Object Archetypes
- Naming of Business Layer objects (formerly “K_” views) now parameterized
- Tutorials finalized
- Fixes
- Fixed bug in class-to-class mapping
- Now produces an error message if a primary/business key component does not exist in the class
- No recursive hash procedure calls when hashing a self-referencing class
Version 2.2.0
Release date: 2020-10-13
- Application
- File based license check added
- Rebranding: “K#” replaced with “D♯” everywhere
- Opening export file (project.xml) directly instead of wrapping it in a D♯ project file
- Model based solution for the equivalent of multiactive satellites
- Mechanism for handling hashing errors (parameter based “remove duplicates” before loading)
- Created Tutorials for self-learning and training
- Fixes
- Association can now be drawn both ways
- Full DW install now always installs the entire model, not just the extended selection
- Diagram commands streamlined
- Removed all unused scripts
Version 2.1.2
Release date: 2020-09-03
- Installation package bug fix
- Added several demo scripts with corresponding demo data
- Re-introduced the Data Grid for demo and data debugging purposes
Version 2.1.1
Release date: 2020-06-15
- General cleaning up
- Added default value to nullable columns
Version 2.1.0
Release date: 2020-06-11
- Support for Ellie as modeling tool
- UI
- Property pane for displaying selected object’s properties
- Changed to a longer delay time for text searches in the tree views: the component waits three seconds before the search starts running after you have entered something in the search box. Pressing return lanches the search immediately.
- Command execution times available in the status bar.
- New incremental deployment package available.
- Raw Vault and Data Flow diagrams now available.
- ETL parameters
- Soft delete possible if data is no longer present in any source it has been loaded from previously.
- Turn duplicate hash handling on or off.
- Commands
- Hash, Load as well as Hash & Load a class directly from the UI.
- Analysis to find datatype conversion errors.
- Analysis to find differences between model and database (tables and views).
- Business Layer
- Classes with Volume = High or more are automatically materialized using a table and a populating procedure instead of a view.
- Better indexes generated for K_ view usage.
- Legacy
- v 1.4 scripts removed, resulting in a cleaner menu structure. All visible commands actually do something.
Version 2.0.5
Release date: 2020-01-27
- Completely re-written internal architecture. New object model to support Data Vault 2.0.
- Internal Object Model rewritten without using interfaces. More flexible architecture.
- Full support for standard DV2 objects: hub, satellite, link (many variations: standard link, link-as-class, non-historized link), state satellite (effectivity satellite), PIT. Business vault objects generated but not automatically populated. Views generated on top of both Raw Vault and Business Vault tables.
- Model-based mappings (simple mapping as well as pivoting) automatically generate the Business Layer views.
