Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Assign the required permissions.
•Download the Oracle Business Intelligence RPD repository file.
•Convert the Oracle Business Intelligence RPD repository file to an XML or UDML file.
•Install the Informatica Secure Agent on a Windows or Linux machine.
•Import SSL certificate to the JRE folder of the Informatica Secure Agent.
•Copy the following files to a directory on the Informatica Secure Agent machine:
- Oracle Business Intelligence RPD variable values file that contains a list of RPD variable values in the key=value format.
- Converted XML or UDML metadata files.
- Data sources XML file that defines the Oracle Business Intelligence Publisher data source connections.
•If your database is SSL-enabled, specify appropriate values for the Trust Store file and Trust Store password fields in the configuration properties.
Note:
Test Connection to an SSL-enabled database fails if either the trust store file or trust store password value is not specified in the configuration properties.
•Create endpoint catalog sources for connection assignment.