Set up DataSync Agent to share to Oracle

Install and configure your DataSync Agent

Follow the steps to install the DataSync Agent or the DataSync for Salesforce Agent and make sure that your agent.xml file is configured correctly.

Access your agent.xml configuration file

Navigate to the directory where you saved your agent.xml file when installing your DataSync Agent.

Update database directives to point to Oracle

Open 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:

 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 ldap: 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

Add the <skip_database_creation/> directive

Locate the <task> directive(s) in your <subscribe> directive, and nest the following directive:

Your agent.xml file should look similar to the example shown below:

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
   <agent>
      <share/>
      <subscribe>
         <task instances="4">
            <task_name>OracleAgent_subscribe</task_name>
            <message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.oracletest" use_basic_consume="false" user="exampleuser">https://example.perspectium.net</message_connection>
            <instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="test.user">https://myinstance.service-now.com</instance_connection>
            <handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
            <decryption_key>The cow jumped over the moon and the sun</decryption_key>
            <database_type>oracle</database_type>
            <database_server>localhost</database_server>
            <database_port>1521</database_port>
            <database_user>system</database_user>
            <database_password>encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=</database_password>
            <database_sid>orcl</database_sid>
            <skip_database_creation/>
            <database_column_max_size>251</database_column_max_size>
            <database>psp_repl</database>
         </task>
      </subscribe>
      <max_reads_per_connect>4000</max_reads_per_connect>
      <polling_interval>5</polling_interval>
      <skip_message_set_processing/>
   </agent>
</config>

Save your agent.xml file

Save the changes you made to your agent.xml file and close the file.

Run your DataSync Agent

After configuring your agent.xml file to support replication to your Oracle database, start running your DataSync Agent again.