Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

What is datawarehouse automation?

3 posters

Go down

What is datawarehouse automation? Empty What is datawarehouse automation?

Post  juanvg1972 Wed May 06, 2015 1:51 am

Hi Ajulius,

Can you expliain what is exactly datawarehouse automation?

Is the ETL script generated automatically?, what about complex business rules?

Thanks,


juanvg1972

Posts : 25
Join date : 2015-05-05

Back to top Go down

What is datawarehouse automation? Empty Re: What is datawarehouse automation?

Post  ron.dunn Wed May 06, 2015 2:51 am

Data Warehouse Automation products accelerate the design, development and maintenance of ETL/ELT processes.

DWA tools differ from traditional ETL tools (ie, SSIS, Informatica, etc.) by offering features like:

o Best practice, methodology-specific, design and code
o Metadata driven design and development
o DDL and ETL code generation
o Data lineage and impact analytics
o Documentation generation
o Agile development support

The key difference is that, with ETL tools, you still have to write code. Whether you're dragging arrows between blocks on a diagram, filling the blanks in XML, or coding in a domain-specific language, you're still writing code. DWA products focus on your design, and write the code for you.

As you've seen from my response to an earlier question of yours, there are many DWA tools in the market, supporting a wide range of target platforms and DW methodologies. Browse some of those web sites for a better understanding of what's in the market

ron.dunn

Posts : 55
Join date : 2015-01-06
Location : Australia

http://ajilius.com

Back to top Go down

What is datawarehouse automation? Empty Re: What is datawarehouse automation?

Post  ngalemmo Wed May 06, 2015 1:09 pm

When you think about it, all data warehouse loading functions fall into specific code patterns.  Surrogate key resolution, key dependancies, what kind of dimension is it, what columns have history, are facts insert only or snapshots? So in an automation tool the loading part becomes more declarative than procedural. You map what goes where and the system does the rest.

Aginity Amp is such a tool as well.  It implements a store and publish architecture that manages the entire environment.  It also extends the publication side to include customized derived attributes (such as segmentations, complex calculations, etc).
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

What is datawarehouse automation? Empty Re: What is datawarehouse automation?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum