Versions Compared

Old Version 3

changes.mady.by.user user-1bc08

Saved on

compared with

New Version Current

changes.mady.by.user user-1bc08

Saved on

Key

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

By default, table schemas are created by passing your ServiceNow instance username and password into the <instance_connection> tag of the agent.xml file created upon installation of the DataSync Agent. Alternatively, you can send ServiceNow table schemas directly to a database that your DataSync Agent replicates to.

(info) NOTE: Table schemas can be shared through bulk share only.


Procedure

To share table schemas from ServiceNow to a database through the DataSync Agent, follow these steps:


UI Steps


UI Step

Access agent.xml

Navigate to the directory in which your agent.xml file was saved upon installation of the DataSync Agent. Then, open the agent.xml file in a text editing application.


UI Step

Remove and add a directive 

Delete the <instance_connection> tag. Then, within the <task> tag, add a self-closing <use_cache/> tag.

Your agent.xml file will look like the following example:

Code Block
languagexml
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
  <agent>
    <subscribe>
      <task>
        <task_name>example_subscribe</task_name>
        <message_connection password="encrypted:XXXXX" queue="psp.out.replicator.example" use_basic_consume="true" user="exampleUser">amqps://example.perspectium.net</message_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>exampleHost</database_server>
        <database_port>3306</database_port>
        <database_user>exampleUser</database_user>
        <database_password>encrypted:XXXXX</database_password>
        <database_params>characterEncoding=UTF-8</database_params>
        <database>psp_repl</database>
 
        <use_cache/>
      </task>
    </subscribe>
    <max_reads_per_connect>4000</max_reads_per_connect>
    <polling_interval>5</polling_interval>
    <skip_message_set_processing/>
  </agent>
</config>



UI Step

Navigate to Bulk Share

Log into your ServiceNow instance. In ServiceNow's left side navigation window, navigate to Perspectium > ReplicatorDataSync > Bulk Share or simply type and then click on Bulk Share. Then, click the timestamp next to the name of the bulk share table schemas for or create a new one.


UI Step

Enable Advanced option

Check Advanced. Once that option is checked, an Advanced tab will appear with the rest of the selection tabs. 


UI Step

Enable Share Schema

Check Share Schema. Once that option is checked, the Target Application field will appear. In that field, select Replicator DataSync Agent.



UI Step

Save the form

Click the Save or Update button at the bottom of the form to save the configurations for your bulk share.