Tibco-Scribe Online RS Replicating All Records In A Salesforce "_History" Object
Article ID: KB0078247
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
When a Replication Solution has been configured and is scheduled to run, the replication process does the following:
These date fields are used each time a Replication Solution executes to select only new or updated source records for replication. When the Replication Solution executes, Tibco-Scribe Online checks the target datastore for the most recent date in the fields specified by the Connector. Tibco-Scribe Online uses that date to filter records in the source datastore. Records selected for replication include only records newer than the most recent date in any target record in the selected table.
Salesforce offers a Custom History Object for which all names end with "_History". Entities ending in "_History" do not have a SystemModstamp field. If this object or entity is selected in Tibco-Scribe Online for Replication, all records for that entity are replicated on every execution of the Replication Solution. You can unselect this entity in the Replication Solution configuration to prevent it from replicating.
To determine whether or not an entity has a SystemModstamp field, you can use Select * From Entity in the Target database. If there is no SystemModstamp column, then all records for that entity will replicate in each RS run.
See the following in the Tibco-Scribe Online Help for additional information: Selecting Source Entities
- First Execution — The Replication Solution creates the tables and corresponding fields in the target datastore in the likeness of the source datastore. Then, all source records for the entities selected in the Solution are replicated.
- Subsequent Executions — The Replication Solution selects new or updated source records, based on a datetime field, and only replicates those records. The source Connector automatically chooses the datetime field to be used for the Last Modified Date for each table.
These date fields are used each time a Replication Solution executes to select only new or updated source records for replication. When the Replication Solution executes, Tibco-Scribe Online checks the target datastore for the most recent date in the fields specified by the Connector. Tibco-Scribe Online uses that date to filter records in the source datastore. Records selected for replication include only records newer than the most recent date in any target record in the selected table.
Salesforce offers a Custom History Object for which all names end with "_History". Entities ending in "_History" do not have a SystemModstamp field. If this object or entity is selected in Tibco-Scribe Online for Replication, all records for that entity are replicated on every execution of the Replication Solution. You can unselect this entity in the Replication Solution configuration to prevent it from replicating.
To determine whether or not an entity has a SystemModstamp field, you can use Select * From Entity in the Target database. If there is no SystemModstamp column, then all records for that entity will replicate in each RS run.
See the following in the Tibco-Scribe Online Help for additional information: Selecting Source Entities
Issue/Introduction
Salesforce Custom Objects "_History" are not given a SystemModstamp field in Salesforce, causing a Replication Solution to replicate all records for that object on every Solution execution.
Feedback
Yes
No
Powered by
