Page History
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. |
Prerequisites
First, you will need to set up one of the Perspectium DataSync Agents that supports upsert.
You should also stop running your DataSync Agent before making any Agent configuration changes.
Procedure
To enable upsert to your database, follow these steps:
UI Steps | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Similar topics
Content by Label showLabels false max 5 showSpace false sort modified cql label = "datasync-agent-advance" and space = currentSpace()