We are proud that we can deliver a fully open “Datawarehouse Automation Framework” in a box.
With this framework you can:
generate 95% your datawarehouse code;
in your datawarehouse database platform;
in your BI architecture.
All the steps to generate your datawarehouse code are described in roadmap manuals, a kind of cookbook, which describes exactly what an ETL developer must do to generate each part of your datawarehouse. These steps are supported by videos with examples.
What is the base of this “Datawarehouse Automation Framework”
Python: All generators are written in the open source language Python, the generated datawarehouse ETL code is Python, too all.
SQL: Database specific set based SQL code is generated, and embedded in Python, to modify the data in your datawarehouse.
Code templates: The generated ETL- and DDL-code is based on code templates for all different kind of tasks in your datawarehouse.
Metadata manager: The metadata manager is the base for generating the ETL- and DDL-code. The base metadata is imported by reading it from any database type and 3 file types. With the metadata manager you can optimize the metadata, check the consistency before generating your code.
And as a bonus we are able to deliver the “Datawarehouse Automation Framework” with your own company specific name and your company logo inside.
BI-Quest is a specialist in designing and creating datawarehouses for Business Intelligence (BI) systems. When creating a BI system, thorough knowledge of theoretical models plus the applied software tools plays a central role. To this we add a healthy dose of common sense, years of experience and a methodical approach. That is how BI-Quest will bring your BI project to a successful ending.The knowledge and expertise of BI-Quest lie with datawarehouse automation in BI systems. Through this specialisation and craftsmanship we create and implement your BI systems successfully together with you. You can make use of the products and services we developed.