What is DAC?
DAC stands for Data Warehouse Application Console. It is a centralized console for the set up, Configuration, administration, loading, and monitoring of the Siebel Data Warehouse. It is used to manage various ETL mappings and executing workflows that are created using ETL software such as Informatica.
DAC stands for Data Warehouse Application Console. It is a centralized console for the set up, Configuration, administration, loading, and monitoring of the Siebel Data Warehouse. It is used to manage various ETL mappings and executing workflows that are created using ETL software such as Informatica.
Why use DAC?
Scheduling Tasks: It helps in scheduling an execution plan run. An execution plan can be scheduled for different frequencies or recurrences by defining multiple schedules. (An execution plan is defined based on business requirements for when the data warehouseneeds to be loaded. Execution plans are scheduled in sequence, not in parallel)
Automate Execution: It can be quite difficult and error prone to run different workflows manually and DAC helps us to automate execution of workflows according to our needs.
Easy Flow Management: It helps easy management of workflow execution. Take a simple example I have created 5 different workflows 3rd should only be run after 4th and 5th workflow. Running them manually can always leave a possibility of error and result in wrong data load. DAC can help us define dependency and order of the workflows in which they should be run.
After the theory part its time for the practical’s. Following are the steps to ConfiguringDAC (client)
- Open the DAC client and click Configure. A small pop up window will come up.
- Select Create Connection and click > Next
- Give any name to the connection and select the Connection type .The third field will depend on the Connection type like if you select DB2 then you want to provide the Connection string or if Oracle (OC18) then TNS name. (For this example we are choosing Oracle Connection Type)
- After filling all the fields click on Test Connection .A small Pop up window will come up where you need to provide Table owner name and password. After that click Test .If it is successfully established then you will get the message “Connection was successfully established”. (In case if you get error you will need to verify if the TNS is setup correctly or not)
- Now click close and then Apply.
- Now when you open the DAC client next time, you will get that option to connect the DAC server.
