Page History
HTML |
---|
<style> .release-box { height: 30px; width: 100px; padding-top: 8px; text-align: center; border-radius: 5px; font-weight: bold; background-color: #DDA0DD; 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/Helium" style="text-decoration: none; color: #FFFFFF; display: block;"> Helium </a> </div> |
Database indexing are is used to speed up data retrieval when querying for records from database tables. Enabling the Share Index option allows you to share the indexes of a table in ServiceNow through a bulk share . so the same indexes can be created in the database where you've shared data to.
With this option enabled, the bulk share The bulk share then shares out an index message that contains the columns that will be are indexed in the database table as its configured in ServiceNow. With DataSync Agent, the messages created by the bulk share will send over to your database and will The DataSync Agent will then pick up this message and create indexes on the columns of the database table that was shared to match.
NOTE: Indexing database tables is compatible with Oracle, SQL Server, and MySQL databases, and is only used for DataSync. Snowflake does not support indexing, therefore, this feature is not compatible for Snowflake.
Procedure
To share indexed tables from ServiceNow to a database through the DataSync Agent, follow these steps:
UI Steps | ||||||||
---|---|---|---|---|---|---|---|---|
|
Similar topics
Content by Label showLabels false max 5 showSpace false sort modified cql label = "datasync-agent" and space = currentSpace()