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. NOTE: If you are using Oracle 12.2+ with the 12.2 JDBC driver, you can set the table and column names to support Oracle 12.2's larger 128 bytes limit (prior to 12.2, the limit was 30 bytes meaning table and column names could only be up to 30 standard characters). To do so, follow these steps: - Request the databases.xml file for your DataSync Agent by contacting Perspectium Support.
- Once you've received the databases.xml file, 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 <identifier_max_length> directive and replace the value of 30 with preferred value up to 128. Do not enter any values greater than 128 as it will result in Oracle errors when trying to create tables and columns.
- Save the databases.xml file and put the file within the conf directory that was created upon installation of your DataSync Agent.
Download - Verify you have the ojdbc8-12.2.0.1.jar in the jars directory that was created upon installation of your DataSync Agent. This should be included by default when the Agent was installed. However if it isn't, download the Oracle 12.2 JDBC driver jar, specifically the ojdbc8.jar. This jar will be named with the version number such as ojdbc8-12.2.0.1.jar.
- Replace the ojdbc8.jar within the jars directory
that was created upon installation of your DataSync Agent with the version downloaded in the previous step- .
|