Demo environment ready
Yesterday I completed the setup of a virtual machine containing an Oracle database, OIBEE as reporting tool and both Powercenter and Oracle Warehouse Builder as ETL software. On the client side I installed OWB and Powercenter (obviously) and Informatica Mapping Architect (formerly: Data Stencils / the Visio mapping template). With this demo environment I can resume the tryouts of mapping generation based on the reference architecture on this blog. Theoretically the entire system could be generated with minimal user input and I’ll see how far I can get with the current software. I’ll be posting scripts and examples when they work :). There are too few available now.