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