Update database directives to point to OracleOpen your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and update the following database-related directives: Directive | Value to enter |
---|
<database_type> | oracle | <database_server> | URL for your Oracle database | <database_port> | 1521 | <database_user> | Username used to access your Oracle database | <database_password> | Password used to access your Oracle database | <database_sid> | System Identifier (SID) used to access your Oracle database |
NOTE: A TNS connect string can also be used to connect to your Oracle database. To configure your Agent in this way, enter the TNS connect string as the value for the <database> directive and delete the <database_port> and <database_sid> directives. If using LDAP, request the databases.xml file for your DataSync Agent by contacting Perspectium Support. Once you've received the databases.xml file, follow these steps:
- Open the file in a text-editing application and locate the configurations for <database_type>oracle</database_type>. Within the parent <database> directive, locate the <database_uri> directive and add ladpldap: following the @ tag. If added correctly, the tag will read <database_uri>jdbc:oracle:thin:@ldap:</database_uri>
- Locate the database_uri_database tag and clear its contents. The final line should read: <database_uri_database></database_uri_database>
The following fields should be configured in your agent.xml: - The database_port tag should be configured as port/database\,cn=example\,dc=example... i.e. <database_port>8080/testdb\,cn=OracleContext\,dc=Perspectium</database_port>
- The backslashes are used to escape the commas as needed
- The database_server tag should include the desired server <database_server>ExampleLDAP.perspectium.com</database_server>
- The database_sid tag should be removed entirely
|