TIBCO Software Inc. provides data integration and migration software solutions to help people within an organization share critical customer data and, to better focus – and take action – on critical business events. TIBCO’s unique approach with its configurable integration software, can help your organization achieve enterprise-class integration. TIBCO Scribe® Insight is comprised of the Workbench and Console, and Adapters.
The core technologies used by every TIBCO Scribe® Insight customer are:
Workbench — A graphical environment used to create the mapping documents, called Data Translation Specification (DTS) files. DTS files are created in the Workbench and contain all of your translation settings in a small, portable, format. Key features include:
Connections — Define and store your source and target connection information in a secure format. TIBCO Scribe® Insight supports connections to a wide range of source and target data through its application adapters, including the Microsoft Dynamics family of products, Salesforce.com, and SalesLogix. In addition, Insight supports connections to many other leading business applications through standards-based methods such as ODBC, Web services, OLE DB, and message queues.
Data processing rules and logic — From the Workbench, you can easily provide the logic to cause DTS files to perform a number of tasks, including: branching to different steps to update, insert, or stop processing data; setting errors based on user defined criteria; updating or deleting source rows based on defined criteria; using the last run date of a job to determine which records have changed; and comparing source and target values to determine if records need to be updated, inserted, or ignored.
Field transformation using formulas — Add formulas to transform source fields to appropriate target values. Use Insight's rich function library to convert case, calculate, parse, or concatenate fields, perform field substitutions, make conditional changes, and perform many other tasks. Additionally, you can create custom functions to use in-process COM DLLs.
Reports and debugging tools — Use the Workbench tools to debug and optimize DTS files. Tools include tracing, execution logs, exception and conflict reports, and debugging utilities. Use the interactive performance tips to troubleshoot problems, evaluate a DTS run, and improve performance.
Source queries — Filter data to be processed based on changes or user defined criteria.
Duplicate detection — Define exact or “fuzzy” matching to identify duplicates using multiple fields with AND/OR logic.
Console and Integration Server — The Console provides the tools to manage and automate DTS files as well as perform other administrative tasks such as managing security, adding Scribe Publishers, configuring message queues, and error notification. In addition, the Console is the user interface to the Integration Server which facilitates the exchange of data between two or more data sources. Key features include:
Automation — Precisely define events to trigger the integration from scheduling a batch process, to establishing near real-time polling intervals, to real-time processing of messages in a queue.
Notification — System monitoring of business level events or integration errors with configurable alerts via e-mail, page, or net send.
Error and exception handling — Execution history of processes that succeeded or failed including detailed error reporting.
Data views — Editable views that can be displayed in chart or list format.
Windows Services — The underlying Windows services monitor and detect events, process messages, and raise alerts.
Scribe Internal Database — Stores execution and error logging, persisted integration settings, cross reference tables, and integration statistics.
Adapters — Enable Insight to communicate with a variety of datastores including applications, databases, messages, and files. In addition, TIBCO provides adapters for a number of other products that support one-way migrations to CRM and ERP applications.