Replication Solutions are designed to replicate data from one datastore to another.  Once a Replication Solution has been configured and is scheduled to run, the replication process does the following:

• 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.

If enough time elapses between executions of the Replication Solution, it may end up first creating a new record and then later in the execution marking it as deleted as the changes between the last run and the current run are processed.  In this case, TIBCO Scribe® Online counts the created record as a processed record and the deleted record as a processed record for a total of two records processed.

When creating and deleting the same records in a single Replication Solution, both the records created and the records deleted are counted in the Records Processed total for the Organization.