User Tools

Site Tools


Share Table Schemas to a Database


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"?>
        <message_connection password="encrypted:XXXXX" queue="psp.out.replicator.example" use_basic_consume="true" user="exampleUser">amqps://</message_connection>
        <decryption_key>The cow jumped over the moon</decryption_key>
  • 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