Managing TIBCO Scribe® Online RS Solutions
Use a TIBCO Scribe® Online Replication Services (RS) Solution to copy the contents of your CRM or marketing system to a local database for reporting or business intelligence.
The Solutions page displays information about the status of Integration, Migration, and Replication Services Solutions. The status icon provides a quick visual status of your Solutions. See Solutions for detailed status information.
Once a Replication Solution has been configured and is scheduled to run, the replication process does the following:
Note: If the target Connection configured in the Replication Solution supports Bulk operations, then Batch Processing is used automatically to process records in batches instead of one at a time.
- 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 there is a Fatal Exception during replication, the next time the Replication Solution executes TIBCO Scribe® Online subtracts 500 milliseconds from the date/time field found in the target table where the failure occurred. This ensures that no records are missed, however, a few records may be reprocessed unnecessarily.
Note: If you have manually imported records into your source datastore with a Last Modified Date that is older than the Last Modified Date in the target, these records will be ignored during replication because the dates are too old.
Note: If you change the source schema, those changes are propagated to the target before the data is replicated. See Editing The Source Schema for additional details.
Note: If you change the source Connection for a Replication Solution that has already replicated once and the new datastore has tables with the same names but a different schema, the Solution does not process any records. See the No Records Processed For Replication Solution With New Source Knowledge Base article for more information.
Note: Do not make manual modifications to the target datastore. Manually changing the target datastore can result in errors and prevent your Replication Solutions from running.
Review the following options for RS Solutions:
- Requirements
- Adding Or Editing A Replication Solution
- Selecting Source Entities For Replication Solutions
- Reprocessing Replicated Data Records
- Editing The Source Schema
- Deleting A Solution
- Stopping A Solution
- Disabled Solutions
- Scheduling A Solution
- Viewing Execution History
- Managing Failed RS Execution History Records
Note: If your subscription expires, or if you disable a Solution from the Solution Edit page, the Solution is marked as disabled. See Disabled Solutions for more information.
View the TIBCO Scribe® Online Replication Service video which guides you through the process of creating a Replication Solution to replicate data from one datastore to another.