4.43 Master Repository Import Wizard

Use to create a new Master Repository by exporting another Master Repository.

How?

The Master Repository Import Wizard has the following steps:

4.43.1 Step 1 - Repository Connection

Use to enter the database connection and the repository configuration details.

Database Connection

Properties Description
Login User ID/login of the owner of the tables you have created for the Master Repository.
JDBC Driver Driver used to access the technology, which hosts the repository.
JDBC URL Complete path for the data server to host the repository.

Note: The parameters JDBC Driver and URL are synchronized and the default values are technology dependent.

User User ID/login of the owner of the tables.
Password Password of the user.
DBA User Username of the database administrator.
DBA Password Password of the database administrator.

Click Test Connection to test the connection to your Master Repository.

Repository Configuration

Properties Description
ID A specific ID for the new Master Repository, rather than the default 0. This affects imports and exports between repositories.

Note: All master repositories should have distinct identifiers. Check that the identifier you are choosing is not the identifier of an existing repository.

Use a Zip File If using a compressed export file, select Use a Zip File.
Import Path (File) If using zip file, enter or select the file containing your Master Repository export. If not using a zip file, enter or select the folder containing the export data of your Master Repository.
Technology From the list, select the technology your repository must be based on.

Click Next to move to the next step of the Master Repository Import Wizard.

4.43.2 Step 2 - Password Storage

Use to select the password storage mode. Do one of the following:

  • Select Use Password Storage Configuration specified in Export to reuse the same password storage mode as the exported Master Repository.

  • Select Use New Password Storage Configuration to configure a new password storage mode and do one of the following:

    • Select Internal Password Storage to store passwords in the Oracle Data Integrator repository.

    • Select External Password Storage to use JPS Credential Store Framework (CSF) to store the data server and context passwords in a remote credential store. Indicate the MBean Server Parameters to access the credential store.

      Enter the following MBean Server Parameters:

    Properties Description
    Host MBeans Server Host, for example: mymachine.oracle.com
    Port MBeans Server Port, for example: 7001
    User MBeans Server User Name, for example: weblogic
    Password MBeans Server Password, for example: weblogic

Click Test Connection to test the connection to your MBean Server.

Click Finish to complete the Master Repository Import Wizard and create a new Master Repository by exporting another Master Repository.

"Setting Up External Password Storage" in the "Managing Security in Oracle Data Integrator" chapter in Oracle Fusion Middleware Administering Oracle Data Integrator