Data Warehouse Automation Tools

[oelimtrila7]

I am looking for a good tool to streamline the process of developing a data warehouse. The tools I have seen so far are Wherescape RED, Dimodelo, and Talend. Are there any I am missing? Does anyone have any experience with any of these? I will be developing a data warehouse from scratch. I am open to a good set of templates, a dedicated tool, or even separate tools for each piece. We use the Microsoft stack for our databases and reporting. Any ideas?

[TimGarrod · Accepted solution]

Hi - you've come to the right place!  

While those are certainly good solutions in their own right, you have certainly missed one to consider - QLIK's!!! 🙂

Qlik Data Integration provides a Data Warehouse Automation solution powered by Qlik Replicate and Qlik Compose for Data Warehouses.   The solution provides end-to-end data warehouse management, from data ingestion and managing the data warehouse model to etl automation / code generation and data mart creation for your bi and reporting solutions.   The entire solution is architected for near-real time data warehousing with Qlik Replicates ability to deliver real-time data from source systems.   Qlik Compose automates the data warehouse lifecycle to provide faster time to value from your data. 

I recommend taking a look at Qlik.com for more information on our data warehouse automation solution.   If you'd like to know more, feel free to message me in this community and I can certainly provide more information / get demo's scheduled for you etc. 

Here are a few links for you - 

High level information on Qlik.com - https://www.qlik.com/us/data-warehouse-automation

Paper on Compose for Data Warehouse automation features https://www.qlik.com/us/-/media/files/resource-library/global-us/direct/datasheets/ds-qlik-compose-d...

Hope that helps.  Feel free to reach out for more info.