| HTML |
|---|
<style>
.release-box {
height: 30px;
width: 100px;
padding-top: 8px;
text-align: center;
border-radius: 5px;
font-weight: bold;
background-color: #d4af37;
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/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div> |
You can configure your
...
DataSync Agent to share data from ServiceNow or Salesforce to a MySQL database by changing some additional configurations in your agent.xml file.
Prerequisites
...
First, you will need
...
to Install the DataSync Agent
...
.
You will also need to create a ServiceNow
...
dynamic share/bulk share.
Make sure to stop running your DataSync Agent before making any Agent configuration changes.
| Note |
|---|
NOTE: The <schema_connection> password attribute is your salesforce password with your security token appended to it. |
Procedure
To set up your DataSync Agent to share application data to a MySQL database, follow these steps:
...
...
Follow the steps to install the DataSync Agent for ServiceNow or the DataSync for Salesforce Agent and make sure that your agent.xml file is configured correctly.
Access your agent.xml configuration fileNavigate to the directory where you saved your agent.xml file when installing your DataSync Agent. |
| UI Step |
|---|
Update database directives to point to MySQLOpen 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> | mysql | | <database_server> | URL for your MySQL database. If your database is installed on your local machine, set this value to localhost. | | <database_port> | 3306 | | <database_user> | Username used to access your MySQL database | | <database_password> | Password used to access your MySQL database |
Your agent.xml file should look similar to the example shown below: | Code Block |
|---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances=" |
|
|
...
1">
<task_name>datasyncforservicenow_to_mysql_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.testqueue" user="admin">https://testperspectium.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</decryption_key>
<database_type>mysql</database_type>
<database_server>localhost</database_server>
<database_port>3306</database_port>
<database_user>root</database_user>
<database_password>encrypted:vlOtU71yu8N/EFIJH85SSMoilKLTeJHQrNZPJ7c5tFU=</database_password>
<database_parms>characterEncoding=UTF-8 & useSSL=false & serverTimezone=UTC</database_parms>
<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> |
|
|
...
 NOTE: For MySQL8 in the <database_parms> directive, parameters need to be separated by a space, an ampersand, and a following space ("parm=value & parm=value").
|
| UI Step |
|---|
Save your agent.xml fileSave the changes you made to your agent.xml file and close the file. |
|
...
Similar topics
| Content by Label |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| cql | label = "data-sync" and space = currentSpace() |
|---|
|
Contact Perspectium Support
...
