What’s new in version 3.3

(released August 2016)

Full template editor

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.

Bulk-edit model properties

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.

Utility scripts

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.

What’s new in version 3.2

(released January 2016)

Edit templates

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.

Rollback dataloads

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.

Reverse engineering connectivity

We have improved the connectivity to various common relational database systems (Oracle, DB/2) for importing source metadata information.

 

Core Quipu functionality

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

  • Source or business model reverse engineering
  • Generate staging model
  • Generate staging load code
  • Enhance source model structures
  • Reverse engineering based on logical models / views

Data Vault Model Design

  • Automated DataVault model generation
  • Full load processing
  • Delta load processing
  • Data Vault load code generation

Data Vault Advanced Modelling Options

  • Split satellites
  • Add business keys in links and satellites
  • Group links
  • Move attributes between satellites
  • Mark tables as reference tables
  • Adjust relationship between tables

Source 3NF View Generation

  • Generate ‘actual’ (current status), ‘last’ (last known status) and ‘point-in-time’ views on the Data Vault model
  • Generate DDL for 3NF views

Runtime Support

  • Default ANSI SQL 92 code generation
  • Option to generate Audit ID in code for linking to custom audit tables
  • All generated code is stored in an open repository, accessible for other (ETL) tooling