User Tools

Site Tools


agent_share_table_schema

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
agent_share_table_schema [2019/02/28 15:56]
timothy.pike
agent_share_table_schema [2019/03/13 15:53] (current)
jackson.davenport formatting
Line 8: Line 8:
  
 To share table schemas from ServiceNow to a database through the Replicator Agent, follow these steps: 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 [[agent_installation|installation of the Replicator Agent]]. 
-\\ +  * Open the **agent.xml** file in a text editing application. 
-**1.** Navigate to the directory in which your **agent.xml** file was saved upon [[agent_installation|installation of the Replicator Agent]]. +  * 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: 
-**2.** Open the **agent.xml** file in a text editing application. +
-\\ +
-**3.** Delete the ''​instance_connection''​ tag. +
-\\ +
-**4.** Within the ''​task''​ tag, add a self-closing ''<​use_cache/>''​ tag. Your **agent.xml** file will look like the follow +
-ing example: +
-\\+
 ====Example Agent.xml File Configuration==== ====Example Agent.xml File Configuration====
-<​code>​+<​code ​xml>
 <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​ <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​
 <​config>​ <​config>​
-<​agent>​ +  ​<​agent>​ 
-<​share/>​ +    <​subscribe>​ 
-<​subscribe>​ +      <​task>​ 
-<​task ​instances="​4"​+        <​task_name>​example_subscribe</​task_name>​ 
-<​task_name>​testagent_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>​ 
-<​message_connection password="​encrypted:​vlOtU71yu8N/​EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="​psp.out.replicator.dev30098" use_basic_consume="​true"​ user="admin">​amqps://​yourmesh.perspectium.net</​message_connection>​ +           
-<​handler>​com.perspectium.replicator.sql.SQLSubscriber</​handler>​ +        ​<​handler>​com.perspectium.replicator.sql.SQLSubscriber</​handler>​ 
-<​decryption_key>​The cow jumped over the moon</​decryption_key>​ +        <​decryption_key>​The cow jumped over the moon</​decryption_key>​ 
-<​database_type>​mysql</​database_type>​ +        <​database_type>​mysql</​database_type>​ 
-<​database_server>​dev30554-rds1545100863220.cu4y5yedojn3.us-east-1.rds.amazonaws.com</​database_server>​ +        <​database_server>​exampleHost</​database_server>​ 
-<​database_port>​3306</​database_port>​ +        <​database_port>​3306</​database_port>​ 
-<​database_user>​root</​database_user>​ +        <​database_user>​exampleUser</​database_user>​ 
-<​database_password>​encrypted:​vlOtU71yu8N/​EFIJH85SSN5XSG53HcWuez8OI+XN2Hg=</​database_password>​ +        <​database_password>​encrypted:​XXXXX</​database_password>​ 
-<​database_params>​characterEncoding=UTF-8</​database_params>​ +        <​database_params>​characterEncoding=UTF-8</​database_params>​ 
-<​database>​psp_repl</​database>​ +        <​database>​psp_repl</​database>​ 
-<​use_cache/>​ +           
-</​task>​ +        ​<​use_cache/>​ 
-</​subscribe>​ +      </​task>​ 
-<​max_reads_per_connect>​4000</​max_reads_per_connect>​ +    </​subscribe>​ 
-<​polling_interval>​5</​polling_interval>​ +    <​max_reads_per_connect>​4000</​max_reads_per_connect>​ 
-<​skip_message_set_processing/>​ +    <​polling_interval>​5</​polling_interval>​ 
-</​agent>​+    <​skip_message_set_processing/>​ 
 +  </​agent>​
 </​config>​ </​config>​
 </​code>​ </​code>​
  
-**6.** Next, log into your sharing ServiceNow instance and navigate to **Perspectium** > **Replicator** > **Bulk Share**. +  ​* 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. 
-**7.** 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.  
-**8.** On the right side of the form, check the **Advanced** box. +  * 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.
-\\ +
-**9.** Scroll down and click the **Advanced** tab.  +
-\\ +
-**10.** 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.+
 \\ \\
  
 {{ screenshot_agent_sharetableschemas.png?​750 }} {{ screenshot_agent_sharetableschemas.png?​750 }}
agent_share_table_schema.txt · Last modified: 2019/03/13 15:53 by jackson.davenport