Oracle® Business Intelligence Data Warehouse Administration Console Guide > Common Tasks Performed in the DAC >
DAC Repository Command Line Options
This section describes the DAC repository command line parameters that are exposed by the AutomationUtils.bat file, which is located in the OracleBI\DAC folder. Import DAC Metadata by Application
The IMPORT option imports DAC metadata into the DAC repository for specified source system containers. The import process truncates all imported tables. You cannot perform an incremental import with this command. Syntax: IMPORT <folderName> <contName1> <contName2> ...
where:
folderName
|
Full path to the root of the import file structure. |
contName
|
(Optional) Name of the source system container for which you want to import DAC metadata. If no container is named, all containers that are found in the file structure will be imported. |
Export DAC Metadata by Application
The EXPORT option exports DAC metadata from the DAC repository for specified source system containers. Syntax: EXPORT <folderName> <contName1> <contName2> ...
where:
folderName
|
Full path to the root of the export file structure. |
contName
|
(Optional) Name of the source system container for which you want to export DAC metadata. If no container is named, all containers that are found in the file structure will be exported. |
Import DAC Metadata by Categories
The IMPORTCATEGORY option imports DAC metadata into the DAC repository based on the Logical, Run Time, or System categories. The import process truncates all imported tables. You cannot perform an incremental import with this command. Syntax: IMPORTCATEGORY <folderName> <logicalFlag> <runtimeFlag> <systemFlag>
where:
folderName
|
Full path to the root of the import file structure. |
logicalFlag
|
If the value of this parameter is true , all data categorized as logical is imported (information contained in the DAC Design view). Otherwise, this parameter is ignored. |
runtimeFlag
|
If the value of this parameter is true , all data categorized as run time is imported (information contained in the DAC Execute view). Otherwise, this parameter is ignored. |
systemFlag
|
If the value of this parameter is true , all data categorized as run time is imported (information contained in the DAC Setup view). Otherwise, this parameter is ignored. |
Export DAC Metadata by Categories
The EXPORTCATEGORY option exports DAC metadata from the DAC repository based on the Logical, Run Time, or System categories. Syntax: EXPORTCATEGORY <folderName> <logicalFlag> <runtimeFlag> <systemflag>
where:
folderName
|
Full path to the root of the import file structure. |
logicalFlag
|
If the value of this parameter is true , all data categorized as logical is exported (information contained in the DAC Design view). Otherwise, this parameter is ignored. |
runtimeFlag
|
If the value of this parameter is true , all data categorized as run time is exported (information contained in the DAC Execute view). Otherwise, this parameter is ignored. |
systemFlag
|
If the value of this parameter is true , all data categorized as run time is exported (information contained in the DAC Setup view). Otherwise, this parameter is ignored. |
Create Schema
The CREATESCHEMA option creates the schema of a new DAC repository. Syntax: CREATESCHEMA <unicodeFlag> <workSpace name>
where:
unicodeFlag
|
If the value of this parameter is true , the schema is created as unicode. If the value is false , it is not created as unicode. |
workSpace name
|
The name of the workspace in which the schema is created. |
Drop Schema
The DROPSCHEMA option drops the schema of the DAC repository. Syntax: DROPSCHEMA
Analyze
The ANALYZE option analyzes the DAC repository tables. Syntax: ANALYZE
Upgrade
The UPGRADE option upgrades the DAC repository. Syntax: UPGRADE
Set Password
The SETPASSWORD option sets the passwords for the Informatica servers and physical data sources in the DAC repository. Syntax: SETPASSWORD <type> <logicalName> <password>
where:
type
|
Possible values are server or dbconn. |
logicalName
|
Logical name of the server or data source record in the DAC. |
NOTE: If the logical name or password contains spaces, quotes are required.
|