(released August 2016)
We already added the option to add your own statements before or after QUIPU generated code. Now you can customize each of the templates that generate code as well! This opens up a lot of possibilities to enhance and adapt the generated code to your specific needs. All applicable API objects are shown in the editor screen. Changes made can be checked immediately in the output of the template, you will see the resulting (SQL) statements before saving your changes.
Want to add meaningfull column names to your model? Simply export the model to Excel and add the new names for columns and/or tables in the ‘alias’ fields. Import the model into QUIPU and you’re done! You can now use these new meaningfull names as columns in your Data Vault.
We have added a new menu entry “Utility Scripts” under the “Generate” menu. QUIPU generates SQL Server code for various tasks, such as backup/restore, create/drop constraints, query the QPDB repository and rollback code for remove faulty datasets from your Data Vault.
(released January 2016)
The flexibility of Quipu is largely driven by the use of templates. Templates translate models and mappings between models into executable statements for specific platforms or even tools.
To bring more power to our Quipu users, we have added the option to add statements before or after our template table code. You can use this feature to add specific optimizations like options and hints.
Loading data on a frequent basis into your Quipu generated data warehouse is easy. But what to do when erroneous data is inserted by accident? No worries, we have added a set of rollback templates for SQLServer that remove this faulty dataset from your satellites for a specified load date.
We have improved the connectivity to various common relational database systems (Oracle, DB/2) for importing source metadata information.
The core functionality of Quipu software was developed based on our extensive experience in model-to-model conversion. The overview below lists the major functionalities.
Source and Staging Model
Data Vault Model Design
Data Vault Advanced Modelling Options
Source 3NF View Generation