Scribe Certified Partner for Data Integration and Migration
Scribe Certified Partner
SyncraTec has been a Scribe Certified Partner for over ten years
Scribe is a top provider of cloud and on-premise data integration solutions worldwide. With over 12,000 customers and a Microsoft President’s Award winner, Scribe has proven its ability to deliver cost-effective, reliable data solutions that give both its customers and partners a competitive advantage in business today.
Scribe provides data migration and system tools to help people within an organization share critical customer data, to better focus – and take action – on critical business events. Scribe recognizes that no two customers’ integration requirements are the same… even if they are integrating between the same packaged business applications.
Scribe’s unique approach, configurable integration software, enables mid-market and large businesses alike to achieve enterprise-class integration; with limited budgets and small IT staffs.
- 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 data stores that are unique to their business.
- Template model – Users can quickly assemble reusable integration com-ponents and configure them for each deployment’s unique needs.
Scribe Insight is the core technology used by every Scribe customer and is comprised of three components; the Workbench, the Integration Server, and the Console.
The Workbench is a graphical environment used to create the mapping documents. Key features include:
- Connection – Define and store your source and target connection informa- tion in a secure format.
- Data processing rules/logic – Branch to different steps to update, insert, or stop processing data. Set errors based on user defined criteria.
- Field transformation – Convert data using one or more of 150 functions for case conversion, field concatenation or decomposition.
- Source queries – Filter data to be procesed based on changes or user defined criteria.
- Duplicate detection – Define exact or “fuzzy” matching to identify duplicates using multiple fields with AND/OR logic.
The Integration Server facilitates the exchange of data between two or more data sources. It has a modular, multi-threaded architecture that allows for scaling. Key features of the integration server include:
- Set of Windows Services – The underlying Windows services monitor and detect events, process messages, and raise alerts.
- Internal Database – Stores execution and error logging, persisted integration settings, cross reference tables, and integration statistics.
The Console provides a user interface for the Integration Server and single point of access for creating and managing integration. Key features include:
- Automation – Precisely define an event 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.
Scribe Adapters enable the Scribe Insight tool to communicate with a variety of data stores including applications, databases, messages, and files. Scribe Adapters are classified in two ways, application adapters and connectivity adapters. Both types of adapters provide the following functionality:
- Allow users to connect to a data store using its security model.
- Present schema information including: object properties and relationships, field properties such as data types, lengths, restrictions, defaults, and pick list values, object properties and relationships, and detailed field attributes such as labels, data types, lengths, restrictions, and default values and picklist values.
Schema information from all types of adapters is presented in the same graphical user interface. So whether users are connecting to an enterprise application or a text file, they are working in a familiar Scribe Insight user interface.
Application Adapters work with leading CRM and ERP ap- plications including Microsoft Dynamics CRM, Microsoft Dyamics GP, Microsoft Dynamics NAV, Microsoft Dynamics AX, Salesforce, and SalesLogix. Application adapters work with vendor approved interface methods such as a Web services interface, OLE DB provider, XML messaging, or a proprietary API. Key features of application adapters include:
- Automation of common tasks such as assigning primary ID values, setting default values, validating input data, and setting object relationships; all designed to eliminate run-time errors and provide for greater data integrity.
- Dynamic discovery of objects or fields that presents the unique configuration of each application or database instance to the Scribe Console and Workbench without requiring coding or recompiling.
- Seamless integration of application and database messages to provide detailed exception handling and reporting.
Some application adapters include a publishing component that pushes changes in the application’s data, in XML format, to a message queue.
Application adapters are sold as add-ons to the Scribe Insight tool. Scribe also provides, at no charge, application adapters for products such as ACT!, GoldMine, Exchange, and QuickBooks that support one-way migrations to CRM and ERP applications.
Connectivity Adapters compliment the application adapters by providing a wide variety of connections to a variety of data sources. Connectivity adapters include XML, ODBC, OLE DB, and SQL Server. These connectivity adapters are included with the Scribe Insight tool. Connectivity adapters enable Scribe Insight to communicate with applications and databases in the following ways:
- Direct communication with database tables, views, and stored procedures through ODBC 3.0 or higher and natively to SQL Server. Scribe Insight leverages the filtering and querying capability of these databases when employing this approach.
- The exchange of flat files or XML documents via a directory or FTP/HTTP location.
- The asynchronous exchange of XML messages via an industry standard message queue, email, or integration broker.