<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> |
Custom Schema Properties for DataSync Agent enables you to customize the table names and column names in the target database. This feature allows you to specify custom prefixes or suffixes.
NOTE: Custom names are customized at a global level for all tables that you select to use this feature for. You cannot specify different custom prefixes or suffixes for different tables.
Prerequisites
First, you will need to either set up DataSync for ServiceNow manually or install the DataSync for ServiceNow app.
Second, you will need to have both the DataSync Agent and DataSync versions to be in Fluorine Plus and above.
Lastly, to use DV tag suffix, you will need to check Enable Replicator to add display value fields (prefixed with 'dv_') for reference and choice fields. Navigate to Perspectium > Replicator > Properties.
To customize database schema's table names and column names, follow these steps:
|