Data Management & Data Mapping Software

The technology foundation for Scribe Adapters and all Scribe integrations and migrations is Scribe Insight. This powerful, yet flexible tool incorporates the essential building blocks to support a wide range of integration and migration requirements. The three key components of Scribe Insight are: Scribe Workbench, Scribe Console, and Scribe Integration Server.

Scribe Workbench

The Scribe Workbench is a rich graphical environment in which you can create template files that define source and target data connections, data cleansing rules, data mappings, transformation formulas, and data processing logic. Template files created by the Scribe Workbench are reusable, portable, and easily modified.

• Lookups - Define exact or "fuzzy" matching to de-dupe data using multiple fields with AND/OR logic.
• Formulas - Convert data using one or more of 150 functions for case conversion, field concatenation or decomposition, calculations, field parsing, field substitution and conditional conversion.
• Step control - Automatically branch to different steps to update data, insert data, stop processing data, or set an error based on user defined conditions.
• Source configuration - Filter data to be processed based on changes or user defined criteria.
• Custom function creation - Create custom functions in the form of in-process ActiveX DLLs written in languages such as VB, Java, or C++.

Scribe Console

The Scribe Console provides an intuitive user interface and single point of management to create, control, and manage key aspects of any number of data loading or integration processes.

• Event management - Precisely define the latency for integrations from scheduling batch processes, to establishing near real-time polling intervals based on a file drop or the results of a source-side query, to real-time processing of messages arriving in a queue.
• Notification - Automate system monitoring of business level events or integration errors with configurable alerts via e-mail, page and net send.
• Error and exception handling - Review execution history of what processes succeeded or failed including detailed error reporting.
• Data views - Get on-screen editable views of pre-defined queries that can be displayed in chart or lists format.

Scribe Integration Server

The Scribe Integration Server facilitates the exchange of data between two or more applications or databases.

• Windows services - Monitor and detect events, process messages, raise alerts, and provide an access point for the Scribe Console to the other services.
• Internal database - Store all execution and error logging, persisted integration settings, cross reference tables, and important integration statistics in its own internal database.
• Small footprint - Eliminate the need for a dedicated server by running Scribe Insight on one of your application or database servers.