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> |
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.
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.xmlNavigate 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 |
---|
| <?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 ShareLog into your ServiceNow instance. In ServiceNow's left side navigation window, navigate to Perspectium > Replicator > 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 optionCheck Advanced. Once that option is checked, an Advanced tab will appear with the rest of the selection tabs. |
UI Step |
---|
Enable Share SchemaCheck Share Schema. Once that option is checked, the Target Application field will appear. In that field, select Replicator Agent. Image Modified
|
UI Step |
---|
Click the Save or Update button at the bottom of the form to save the configurations for your bulk share. |
|
Similar topics
Content by Label |
---|
showLabels | false |
---|
max | 5 |
---|
showSpace | false |
---|
sort | modified |
---|
cql | label = "datasync-agent" and space = currentSpace() |
---|
|