Doco on Goldengate / Oracle Data Integrator integration
Looking for info on how to utilise Oracle Golden Gate and ODI together. Official doco is here:
http://docs.oracle.com/cd/E14571_01/integrate.1111/e12644/ogg.htm
This chapter describes how to work with Oracle GoldenGate in order to capture changes on source transactional systems and replicate them in a staging server for consumption by Oracle Data Integrator interfaces.
Moving SAS Servers
Moving the SAS 9.2 environment from the old SAN based server to a new server with a dedicated disk array, to resolve some I/O issues under high load. Will be using shadow copy to automate the move across machines as it manages the swap out of drivers etc for the new hardware.
BI/DW Architecture
Currently working on a developing a BI/DW technical architecture to define how we will manage an environment with multiple ETL and Reporting tools.
Will feed into the Enterprise Information Management and Reporting Strategy we are working on.