TIBCO 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. Our 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 Scribe Adapters.
The Workbench and Console are based on these design features:
No coding — A graphical user interface enables a non-programmer to design and deploy migration and integration solutions.
Easy maintenance — Straightforward access and control of integrations to easily support and maintain the solution after it has been deployed.
Consistent adapter model — The design environment views all applications consistently, and presents information about the application that is important to the migration or integration task.
Open connectivity — One product enables users to integrate core business systems with the wide variety of applications and datastores that are unique to their business.
Template model — Users can quickly assemble reusable integration components and configure them for each deployment’s unique needs.
The core technologies used by every Scribe Software customer are:
Workbench — A graphical environment used to create the mapping documents, called Data Translation Specification (DTS) files. DTS files are created in 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. Scribe 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, Scribe 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 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 Scribe'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 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.
Scribe Adapters enable Scribe to communicate with a variety of datastores including applications, databases, messages, and files. In addition, TIBCO Software Inc. provides adapters for a number of other products that support one-way migrations to CRM and ERP applications.
In addition, you can use XML messaging or other standards based connection methods to access and integrate data from almost any datastore, including applications such as SAP and JD Edwards, databases such as SQL Server, Oracle, and IBM DB2, and text, CSV, or XML data.