Data Warehouse Automation

Five Things You Should Know.
BIReady Australia BIReady Pty Ltd 143 Aiken Road, West Pennant Hills NSW 2125 Australia Email info@biready.com.au  Telephone +61 (0)2 8880 5111 www.biready.com.au ABN : 57 167 132 112

Follow Us

Five Things You Must Know About Data Warehouse Automation

by Ian Nicholson, May 2014. Data Warehouse Automation tools are becoming more mainstream now for their obvious benefits:- Fast delivery times, lower cost of development, better decisions being made sooner. At last, businesses are waking up to the fact that waiting three to six months for a Business Intelligence project to complete is no longer acceptable. There are quite a few Data Warehouse Automation tools on the marketplace right now, but like many things, they are not all created equal. Here are some things you should know if evaluating products from different vendors:- 1) Some Tools Don’t Automate Everything! Some Data Warehouse Automation tools follow the same mistake that most developers make – and that is to make the star-schema for reporting the sole objective. That’s fine for a simple data source, but when you need to combine data from multiple data sources, things get complicated. Some tools require you to write some weird XML code to generate ETL packages! That’s not very automated, and a lousy Band-Aid over an already-flawed process. Your Data Warehouse Automation tool should automate everything without the need for additional data modelling work, mapping or ETL coding. 2) Some Tools Require Lots of Consulting Work to Achieve the Result. Ask this simple question of your Data Warehouse Automation software vendor: - “How many consultants do you have?” A large team of consultants suggests their tool isn’t automating much, or their product is complex to use. The whole point of Data Warehouse Automation is that it should be sufficiently managed by your own in-house team and be easy to use without having to call upon external consultants every time you need a small job done. 3) Third Normal Form or Data Vault before Star Schema? If you are planning to build your Data Warehouse properly, then your chosen Data Warehouse Automation tool should automate any or all of the above. Some Data Warehouse Automation tools still require you to manually design the target model, and use their tool to populate it. That isn’t automation – you might as well go back to using an ETL tool. A good Data Warehouse Automation tool will automate the model design AND the code to populate it – allowing you to choose between Third Normal Form and Data Vault, plus of course, Star-Schema. 4) Target Databases for Your Data Warehouse. Many Data Warehouse Automation tools restrict you to just one target database platform, while others will allow you to create Data Warehouses on many more. You may desire, in the future, to move to a different database platform (say, from DB2 to SQL Server, or from Oracle to Teradata), and so you may need a Data Warehouse Automation tool that offers you future migration options. 5) Scheduling with Dependencies For any Data Warehouse project, data needs to be loaded at certain times and in a certain sequence. For example, when combining data from multiple sources, you may need to have all the data loaded first before you can start building your Third Normal Form tables, and they must be updated before you can update your star-schemas for reporting. An enterprise-class Data Warehouse Automation tool will understand these dependencies and automate all the required processes and run them in the correct order.

Summary

Data Warehouse Automation Still Delivers Data Warehouses Faster Than ETL Tools. ETL tools introduce a lot of costly delays and risk into your Business Intelligence project. Worse, they expect your business users to declare their requirements in advance of development, and so the inevitable changes are going to take a long time to fix. The bottom line is, you cannot be Agile with ETL tools and their traditional Waterfall approach they force you to follow. If your traditional Data Warehouse project is estimated to take six months, the same project should be completed in a few weeks or even days with a good Data Warehouse Automation tool.
Join our Email List
Email:
Name:
comments powered by Disqus
At BIReady Australia, we provide our customers with best-of-breed Information Management solutions. As such, our solutions and services offer advanced expertise in Data Warehouse Automation, Data Quality, Textual Analysis and Business Intelligence. Our experience extends across Healthcare, Finance and Retail. See our special offers or visit our online store.
BIReady Australia offers two exciting Data Warehouse Automation solutions. Choose your desired methodology:-
Attunity Compose Data Warehouse Automation offers large-scale Enterprise Data Warehousing.  Attunity Compose analyses your source data, derives a model and designs and builds an enterprise data warehouse in Third Normal Form or Data Vault and data marts for reporting and analysis automatically.  Attunity Compose does this in a fraction of the time and cost of any other ETL/modelling tool-set or method. Sounds amazing? That’s because it is.
Ajilius Data Warehouse Automation allows for the quick and cost-effective creation of star-schema data warehouses. If you think a Kimball data warehouse should be possible within a realistic budget, then Ajilius is for you. Ajilius will save you time over development using standard ETL tools, and save you money over more expensive Data Warehouse Automation solutions. Ajilius is a great, low-cost entry to Data Warehouse Automation.
Attunity Compose Data Warehouse Automation Ajilius Data Warehouse Automation Request a Demo of a Data Warehouse Automation tool from BIReady. Request a Demo of a Data Warehouse Automation tool from BIReady. Request a Demo of a Data Warehouse Automation tool from BIReady. Request a Demo of a Data Warehouse Automation tool from BIReady.
Call us now! 02 8880 5111
Inmon (Third Normal Form) or  Linstedt (Data Vault) plus Kimball (Star-Schema) Kimball (Star-Schema)

Data Warehouse Automation

Five Things You Should Know.
BIReady Australia BIReady Pty Ltd 143 Aiken Road, West Pennant Hills NSW 2125 Australia Email info@biready.com.au  Telephone +61 (0)2 8880 5111 www.biready.com.au ABN : 57 167 132 112

Follow Us

Five Things You Must

Know About Data

Warehouse

Automation

by Ian Nicholson, May 2014. Data Warehouse Automation tools are becoming more mainstream now for their obvious benefits:- Fast delivery times, lower cost of development, better decisions being made sooner. At last, businesses are waking up to the fact that waiting three to six months for a Business Intelligence project to complete is no longer acceptable. There are quite a few Data Warehouse Automation tools on the marketplace right now, but like many things, they are not all created equal. Here are some things you should know if evaluating products from different vendors:- 1) Some Tools Don’t Automate Everything! Some Data Warehouse Automation tools follow the same mistake that most developers make – and that is to make the star-schema for reporting the sole objective. That’s fine for a simple data source, but when you need to combine data from multiple data sources, things get complicated. Some tools take you through a convoluted staging process to combine the data before creating the star-schema. That’s not very automated. Your Data Warehouse Automation tool should automate everything without the need for additional data modelling work, mapping or ETL coding. 2) Some Tools Require Lots of Consulting Work to Achieve the Result. Ask this simple question of your Data Warehouse Automation software vendor: - “How many consultants do you have?” A large team of consultants suggests their tool isn’t automating much, or their product is complex to use. The whole point of Data Warehouse Automation is that it should be sufficiently managed by your own in-house team and be easy to use without having to call upon external consultants every time you need a small job done. 3) Third Normal Form or Data Vault before Star Schema? If you are planning to build your Data Warehouse properly, then your chosen Data Warehouse Automation tool should automate any or all of the above. Some Data Warehouse Automation tools still require you to manually design the target model, and use their tool to populate it. That isn’t automation – you might as well go back to using an ETL tool. A good Data Warehouse Automation tool will automate the model design AND the code to populate it – allowing you to choose between Third Normal Form and Data Vault, plus of course, Star-Schema. 4) Target Databases for Your Data Warehouse. Many Data Warehouse Automation tools restrict you to just one target database platform, while others will allow you to create Data Warehouses on many more. You may desire, in the future, to move to a different database platform (say, from DB2 to SQL Server, or from Oracle to Teradata), and so you may need a Data Warehouse Automation tool that offers you future migration options. 5) Scheduling with Dependencies For any Data Warehouse project, data needs to be loaded at certain times and in a certain sequence. For example, when combining data from multiple sources, you may need to have all the data loaded first before you can start building your Third Normal Form tables, and they must be updated before you can update your star-schemas for reporting. An enterprise-class Data Warehouse Automation tool will understand these dependencies and automate all the required processes and run them in the correct order.

Summary

Data Warehouse Automation Still Delivers Data Warehouses Faster Than ETL Tools. ETL tools introduce a lot of costly delays and risk into your Business Intelligence project. Worse, they expect your business users to declare their requirements in advance of development, and so the inevitable changes are going to take a long time to fix. The bottom line is, you cannot be Agile with ETL tools and their traditional Waterfall approach they force you to follow. If your traditional Data Warehouse project is estimated to take six months, the same project should be completed in a few weeks or even days with a good Data Warehouse Automation tool.
Join our Email List
Email:
Name:
Request a Demo of BIReady Request a Demo of BIReady
comments powered by Disqus