Thursday, January 3, 2013

Oracle DAC – Quick Setup Steps



1. Install Oracle DAC
2. Import DAC repository (the DAC repository is in dwrep folder in BI Apps Installation)
3. Do DAC Server Set up and change the DAC system parameters
4. Start the DAC server
5. Install Oracle 32 bit client ODAC 32 bit since DAC is a 32 bit component
6. Set up physical connections
7. Create Datawarehouse using ETL Configure. The OBAW is ready.
8. Copy pmcmd command from Informatica server to Informatica Client bin
9. Set up Informatica Servers tab
10. DAC is ready for BI Apps configuration