Understanding Database Exchange Settings

Document ID : KB000055801
Last Modified Date : 14/02/2018
Show Technical Document Details

Computer Associates Advantage Repository for Distributed Systems (CA-ARDS) includes two separate scanners for extracting meta-data from each applicable database. The database scanner that you use depends upon the method of scanning and loading the extracted meta-data into the repository (PCD or Repository).

Scanner Description
Database-to-PCD Scanner
(PCD Exchange)
Translates Database object definitions into a PCAF-formatted.pcd data file that you can subsequently load into the repository using the PCAF Loader. (Recommended)
Database-to-Repository Scanner
(Repository Exchange)
Loads extracted Database object definitions directly into repository without creating an interim .pcd file. For each database, you can run both scanners using the Population Center.

For each database, you can run both scanners using the Population Center.

Understanding Database Exchange Settings

The Population Center can launch several different database exchanges, including the:

DB2 Exchange
ODBC Exchange
Informix Exchange
Oracle Exchange
Microsoft SQL Server Exchange
Sybase Exchange

The scanners for each type of database have similar settings.

Repository Exchange Settings

Database exchanges that load data directly into the repository have the following pages (tabs) of settings: General, Connection, Input, Repository, and Loader.

General Settings

The General tab for all scanners, PCAF Loader, and extract tools includes the following settings:

Imga

OptionDescription
NameThe name of the profile.
DescriptionAdditional information about the profile.
Use Profile LogCheck to limit the log file to logging information related to scans made using this scanner profile. See Understanding Log Files for more information on log files.
Truncate log contents before profile is executedCheck to specify that you want to truncate the log file every time you execute the scanner profile from the workspace.

Connection Settings

The Connection tab includes the following settings:

Imgb

OptionDescription
Data Source Name (DSN)ODBC data source name representing the database you want to scan. If the database you want to scan is not in the selection list, you will need to set it up as an ODBC data source.
User ID The User ID you use to connect to the database you are scanning (not to be confused with the ID you use to connect to the repository). This user ID must have access to the database catalog/dictionary tables.
Password The password for the User ID.

Input Settings

Imgc

OptionDescription
Input Mode (ODBC only)The Advanced Import option is available for the ODBC Scanner only. This area is display-only for all other database scanners.
Database (DB2 only)The name of the DB2 database you want to scan. This value is case-sensitive.
Table Selection (DB2 only)Criteria for determining which objects in the DB2 database you want to scan. Use the wildcard "%" if you want to include all objects.
Name (non-DB2 scanners only)Criteria for determining which objects in the database you want to scan. Use the wildcard "%" if you want to include all objects.
SchemaThe schema/owner of objects in the database you want to scan. Use the wildcard "%" if you want to include all schemas/owners.

The Options section includes checkboxes for specifying the types of database objects you want to include in the scan.

CheckTo have the scanner extract meta-data for
System TablesTables in the database.
ViewsViews in the database.
Stored ProceduresStored procedures in the database.
TriggersTriggers in the database.
Primary KeysPrimary keys for tables in the database.
Foreign KeysForeign key for tables in the database.
IndexesIndexes in the database.

Repository Settings

The Repository tab includes the following settings:

Imgd

OptionDescription
RepositoryThe name of the repository (as defined in the Repository Configuration Facility) into which you want to load meta-data extracted by the exchange.
User IDThe logon ID used to connect to the repository.
PasswordThe password for the User ID.

Loader Settings

The Loader tab includes the following settings:

Imge

OptionDescription
Reuse FileThe name of the PCAF reuse file (.PCR) for the exchange you are running.
Selected ContainersIf you clicked Test Connection after entering the information on the Repository tab, a list of containers in the specified repository appears in the Selected Containers window.
StatusThe status you want to assign to the imported objects. The exchange uses this status to resolve matches with the existing repository objects using the same name.
Note: This must be an existing repository status. If you specify a new status, the load works, but the status attribute is blank.
  
VersionThe version number you want to assign to the imported objects.
Verify onlyCheck this box to perform a simulated load. The loader will create a log file listing the instances it would have created or reused, but it will not actually write to or change the information in the repository.

PCD Exchange Settings

Database exchanges that load data into a PCD file have the following pages (tabs) of settings: General, Connection, Input, and Output.

General Settings

The General tab for all scanners, PCAF Loader, and extract tools includes the following settings:

Imgf

OptionDescription
NameThe name of the profile.
DescriptionAdditional information about the profile.
Use Profile LogCheck to limit the log file to logging information related to scans made using this scanner profile. See Understanding Log Files for more information on log files.
Truncate log contents before profile is executedCheck to specify that you want to truncate the log file every time you execute the scanner profile from the workspace.

Connection Settings

The Connection tab includes the following settings:

Imgg

OptionDescription
Data Source Name (DSN)ODBC data source name representing the database you want to scan. If the database you want to scan is not in the selection list, you will need to set it up as an ODBC data source.
User IDThe User ID you use to connect to the database you are scanning (not to be confused with the ID you use to connect to the repository). This user ID must have access to the database catalog/dictionary tables.
PasswordThe password for the User ID.

Input Settings

The Input tab for Database Exchanges includes the following settings:

Imgh

OptionDescription
Input Mode (ODBC only)The Advanced Import option is available for the ODBC Scanner only. This area is display-only for all other database scanners.
Database (DB2 only)The name of the DB2 database you want to scan. This value is case-sensitive.
Table Selection (DB2 only)Criteria for determining which objects in the DB2 database you want to scan. Use the wildcard "%" if you want to include all objects.
Name (non-DB2 scanners only)Criteria for determining which objects in the database you want to scan. Use the wildcard "%" if you want to include all objects.
SchemaThe schema/owner of objects in the database you want to scan. Use the wildcard "%" if you want to include all schemas/owners.

The Options section includes checkboxes for specifying the types of database objects you want to include in the scan.

CheckTo have the scanner extract meta-data for
System Tables Tables in the database.
Views Views in the database.
Stored ProceduresStored procedures in the database.

CheckTo have the scanner extract meta-data for
TriggersTriggers in the database.
Primary KeysPrimary keys for tables in the database.
Foreign KeysForeign key for tables in the database.
Indexes Indexes in the database.

Output Settings

The Output tab includes the following settings:

Imgi

OptionDescription
Output FileThe name you would like the exchange to use for the PCD file it will create. You can enter the name directly in the input field or use the Browse button to select a specific file and directory.