Scenarios › Export the Archived Databases into an RDBMS › Export Archived Databases into an RDBMS › Configure the Database Configuration File

Configure the Database Configuration File

Configure the DBExportConfiguration.xml file to configure the target database.

Follow these steps:

1. Navigate to the following location:

   /opt/CA/SharedComponents/iTechnology
   

2. Execute the following command from the console:

   vi DBExportConfiguration.xml
   

3. Navigate to the following line:

   <dbToUse values="MSSqlServer/OracleServer/PostgresSqlServer">specify_db</dbToUse> line.
   

4. Type your RDBMS name in specify_db as shown in the dbToUse values.
5. Select the database connection configuration section depending on your database server, and complete the following fields:

   host_name

   Defines the host name of the machine where your RDBMS is installed.

   port_number

   Defines the port number to connect to your RDBMS.

   db_name

   Defines the name of the database into which the utility exports the archived databases.

   user_name

   Defines the username that connects to the target database.

   munged_pwd

   Defines the munged password of the username that is specified in user_name.

   BulkInsertSize

   Defines the number of events that the utility must export into the target database at a time.

   Default: 5000

   Limits: 1000 - 10000

6. Save the changes.

Important! If you update the file after enabling the utility, restart the CA iTechnology iGateway by executing the ./S99igateway stop and ./S99igateway start commands.