Want to load incremental records on Import Set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2019 02:02 AM
Hello SNOW Developers,
I have a Data Source which take data via JDBC and that data source is for cmdb_ci. So I want that only data to be loaded in Import set which are not availabe on my target table cmdb_ci i.e, I want data to be loaded on import set on Incremental basis. Can anyone help me on this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2019 02:27 AM
you can try to write pre import script here. i did not try but below link can help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2019 05:49 AM
JDBC Data Sources uses the "Last run database field" to indicate the timestamp at which your source of truth last updated an item. If you set this field from your database source, ServiceNow will only import any items that have been updated since that timestamp.
The SCCM integration already works on an incremental basis if you want to review it.
