Automating DAC

Post date: 19-Jul-2010 10:40:04

about options to automate the DAC. In most cases the question is around controlling or monitoring execution plans.

There are two command line utilities available, both of which are well documented, so for details please refer to the documentation links. This post is intended to give you a quick overview and point to the often overseen DAC documentation.

1. DACCmdLine.bat

This is a rather well-known batch file which resides in the DAC folder. Before you can use it you must edit it and insert the path to your Java SDK and the DAC home directory. It comes along with two other files

• dac.properties

• DAWSystem.jar

where dac.properties is a text file which needs some editing before first use and DAWSystem.jar is the main executable. You can copy all three files on a different machine if you need to work with the DAC remotely.

Please click here for more information about the initial setup

You can use DACCmdLine.bat in a command shell with 5 different commands basically allowing you to start, stop and monitor an execution plan as well as retrieve the status of all registered databases and Informatica servers.

• StartETL

• StopETL

• ETL

• DatabaseStatus

• InformaticaStatus

all of which are described in the Bookshelf. Click here to access the documentation.

2. AutomationUtils.bat

The second option for DAC automation is another not-so-well-known batch file which allows you to do the following from the command line:

• Import and export DAC metadata

• Create or drop a DAC repository schema

• Analyze the DAC repository tables

• Upgrade the DAC repository

• Set the password on Informatica servers and data sources

Please click here for the documentation of AutomationUtils.bat

Ref: http://siebel-essentials.blogspot.com/2009/01/automating-dac.html