Data warehouses fulfill this role, integrating data from disparate sources and remodeling them to meet reporting and analysis needs from the business. 

Quipu is a unique product designed to model and generate the data warehouse for you, in such a way that you can integrate new or altered data sources quickly and without headaches. 

Quipu solves many problems related to traditional data warehousing implementation.

Customers demand comprehensive business services via a single point of contact. This requires an up to date 360 degree customer view of the services delivered to the customer. 

Other businesses operate in an extended enterprise environment with partners. This requires extensive information availability and exchange. 

Yet other companies realize that they could easily improve their bottom line by developing new services exploiting the data they have collected in their scattered systems landscape.

All of these challenges have one thing in common: they require an integrated and reliable view on company data to enable well informed decisions. Information needs to be traceable to the source to meet compliancy legislation. 

General

•  Fully compliant with DataVault model
• Open source, freely available and fully functional
• Thin frontend runs on Windows
• Backend runs on any Java Virtual Machine (JVM)
• Template based load code generation
• Fully documented source code available

Source model

• Reverse engineer source data models from any database platform using generic JDBC connections
• Automatically generate staging model
• Generate extract and load code from source to staging area (only when sources and data warehosue are on the same database instance)
• Add metadata to source models and identify business keys

 Data warehouse generation

• Automatically generate DataVault data warehouse model from staging area
• Generate load code from staging area to datavault
• Optionally use meaningless ID's
• Option to exclude source tables and/ or columns
• Split and merge satellites
• Identify reference tables
• Group relations into one link
• Generate views that reproduce the (point-in-time) source model

Deployment

• Deploy data warehouse and staging models using generated DDL and load code using ANSI-SQL

• Windows XP or later
• with .NET framework 3.5 or later

• Java Virtual Machine 1.5 or later
• Java Application Server (tested on Tomcat)
• Webserver (tested on Apache)
• RDBMS for repository with JDBC driver  (tested on PostgreSQL and SQL Server 2005 and 2008)
• RDBMS JDBC drivers included: MySQL, PostgreSQL, SQL Server, Sybase ASE
• Any OS supporting above stack (tested on Linux and Windows XP and 7)

Code development (additional to above)

• GRAILS 1.2.0
• Java IDE (e.g. NetBeans)
• Java SDK 1.5 or later
• MS Visual Studio 2008 or later (frontend)