Versions Compared

Old Version 1

changes.mady.by.user user-b790a

Saved on

compared with

New Version 2

changes.mady.by.user user-b790a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #0ACA8B;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/fluorineplus" style="text-decoration: none; color: #FFFFFF; display: block;">
Fluorine+
</a>
</div>



You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to a MySQL database by changing some additional configurations in your agent.xml file.

Prerequisites

(warning) First, you will need to install a DataSync Agent.

(warning) You will also need to create a ServiceNow dynamic share/bulk share or create a Salesforce dynamic share/bulk share.

(warning) Make sure to stop running your DataSync Agent before making any Agent configuration changes.

Procedure

To set up your DataSync Agent to share application data to a MySQL database, follow these steps:

UI Steps


UI Step

Install and configure your DataSync Agent

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


UI Step

Access your agent.xml configuration file

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


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

UI Step

Update database directives to point to MySQL

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:

DirectiveValue to enter
<database_type>oraclemysql
<database_server>

URL for your Oracle databaseMySQL database. If your database is installed on your local machine, set this value to localhost.

<database_port>15213306
<database_user>Username used to access your Oracle MySQL database
<database_password>Password used to access your Oracle database
<database_sid>

System Identifier (SID) used to access your Oracle database

(info) 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.

UI Step
MySQL database

Add the <skip_database_creation/> directive

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

DirectiveDescription
<skip_database_creation/>

Bypasses the dynamic creation of the replicated database

(info) NOTE: This directive is added for an Oracle replication scenario with the DataSync Agent, as you must create the database used for replication in Oracle before configuring your DataSync Agent

Code Block
languagexml
themeEclipse
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
   <agent>
      <share/>
      <subscribe>
         <task instances="4">
            <task_name>datasyncforservicenow_to_name>OracleAgentmysql_subscribe</task_name>
            <message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.oracletesttestqueue" use_basic_consume="true" user="exampleuseradmin">https://example.perspectiumtestperspectium.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<moon</decryption_key>
            <database_type>oracle<type>mysql</database_type>
            <database_server>localhost</database_server>
            <database_port>1521<port>3306</database_port>
            <database_user>system<user>root</database_user>
            <database_password>encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4EFIJH85SSMoilKLTeJHQrNZPJ7c5tFU=</database_password>
            <database_sid>orcl</database_sid>
            <skip_database_creation/>parms>characterEncoding=UTF-8 & useSSL=false</database_parms>
            <database_max_column_size>251</database_max_column_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>



UI Step

Save your agent.xml file

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


UI Step

Run your DataSync Agent

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






Similar topics

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "data-sync" and space = currentSpace()

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com