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> |
For .bulk messages, the DataSync Agent will query for a record to see if it exists and if so, update that record. Otherwise if the record doesn't exist, an insert will occur. However for databases that support it, the Agent can perform an upsert action where updating or inserting is done in one action to improve performance. To enable this, you will need to use the <enable_upsert/> directive.
Note |
---|
|
Enabling upsert is only available for SAP Hana. |
Procedure
To enable upsert to your database, follow these steps:
UI Steps |
---|
UI Step |
---|
Access your agent.xml configuration fileNavigate to the directory where you saved your agent.xml file when installing your DataSync Agent. |
UI Step |
---|
Add the <enable_upsert/> directiveOpen your agent.xml file in a text editing application. Then, locate the <task> directive(s) and nest the <enable_upsert/> directive. |
UI Step |
---|
Save your agent.xmlSave the changes you've made to your agent.xml and close the file. Your agent.xml should look similar to the example shown below: Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<truncate_utf8/>
<share/>
<subscribe>
<task instances="4">
<task_name>test_hana2_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.testqueue" user="admin">https://testperspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="test.user">https://myinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>hana</database_type>
<database_server>localhost</database_server>
<database_port>3306</database_port>
<database_user>root</database_user>
<database_password>encrypted:vlOtU71yu8N/EFIJH85SSMoilKLTeJHQrNZPJ7c5tFU=</database_password>
<database_parms>characterEncoding=UTF-8 & useSSL=false</database_parms>
<database_column_max_size>251</database_column_max_size>
<database>psp_repl</database>
<skip_alter/>
<enable_upsert/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config> |
|
|
Similar topics
Content by Label |
---|
showLabels | false |
---|
max | 5 |
---|
showSpace | false |
---|
sort | modified |
---|
cql | label = "datasync-agent-advance" and space = currentSpace() |
---|
|
support@perspectiumcom