You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to an Oracle database by changing some additional configurations in your agent.xml file.
Prerequisites
First, you will need to install a DataSync Agent.
You will also need to create a ServiceNow dynamic share/bulk share or create a Salesforce dynamic share/bulk share.
Make sure to stop running your DataSync Agent before making any Agent configuration changes.
Finally, you will need to create a database in Oracle that will store data replicated via the DataSync Agent.
Procedure
To set up your DataSync Agent to share application data to an Oracle database, follow these steps:
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:
| 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.
Add the <skip_database_creation/> directive
Locate the <task> directive(s) in your <subscribe> directive, and nest the following directive:
| Directive | Description |
|---|---|
| <skip_database_creation/> | Bypasses the dynamic creation of the replicated database
|
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.
