User Tools

Site Tools


agent_share_table_schema

Share Table Schemas to a Database

Fluorine

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 Replicator Agent. However, as of the Fluorine release, you can send ServiceNow table schemas directly to a database that your Replicator Agent replicates to.

NOTE: Table schemas can be shared for bulk shares ONLY.

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

  • Navigate to the directory in which your agent.xml file was saved upon installation of the Replicator Agent.
  • Open the agent.xml file in a text editing application.
  • Delete the instance_connection tag.
  • Within the task tag, add a self-closing <use_cache/> tag. Your agent.xml file will look like the following example:

Example Agent.xml File Configuration

<?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>
  • Next, log into your sharing ServiceNow instance and navigate to Perspectium > Replicator > Bulk Share.
  • Click the name of the bulk share you want to share table schemas for.
  • On the right side of the form, check the Advanced box.
  • Scroll down and click the Advanced tab.
  • Check the Share schema box to start sharing ServiceNow table schemas to your Agent-configured database. Then, in the upper right-hand corner of the form, click the Update button to save your changes.


agent_share_table_schema.txt · Last modified: 2019/03/13 15:53 by jackson.davenport