Sharing data in real-time between all of your diverse systems will allow you to maximize the return on your investment in information assets, but bridging the gap between differing hardware and software components can be difficult and time-consuming if you try to do it yourself from scratch. There is a better way: Integrator, from Vision Solutions.

Integrator copies, filters and transforms data across multiple operating system, database and hardware platforms in real-time. In short, it delivers your data where, when and how you need it.

Now with Integrator 5.0, built on a .NET architecture, there is infinite flexibility to change your custom delivery and without calling in a services team and without a wholesale change in hardware, software, applications or databases.

High Volume, Real-Time Data Integration:



The Integrator Advantage
Integrator supports bi-directional data replication from and to a variety of databases, including Oracle, Sybase, Microsoft SQL Server, and IBM DB2, without the need for consistency between the source and target servers. And, because Integrator transfers only changed data, it makes real-time replication practical and cost-effective. In addition to real-time replication, Integrator also offers scheduled and batch replication capabilities to meet your unique requirements.

At the heart of Integrator are its Manager and Replication Engine, which run on Windows XP, Windows 2000 Server or Windows Server 2003, from which they are able to define, manage and control replication on any hardware and operating system running one of the supported databases.

The power of Integrator Manager allows you to meet your most complex data integration and replication requirements with point-and-click simplicity. Integrator Manager translates your business rules and requirements into specific replication mappings and transformation processes. Using the graphical user interface, you can easily configure source and target servers, create data mappings, and define other data integration tasks. Consequently, you can establish and manage your entire replication environment without the need for any proprietary programming skills.

Some of the key business and technical benefits of Integrator include:

Advanced Transformation capabilities allow you to convert data as it travels between the source and target servers, providing all users with data in the format that’s most appropriate
for them.

Data Filtering capabilities allow you to include or exclude data from the replication process based on user-defined parameters, thereby minimizing the volume of data transmitted over your networks and allowing you to restrict data on a “need-to-know” basis when appropriate.

Scalability and Flexibility are hallmarks of Integrator’s engine-based architecture, which ensures that the solution will be able to grow and evolve with your business requirements.

Ease of Use is assured by Integrator Manager, which provides a single point of control for the entire replication environment through an intuitive graphical user interface.

Non-intrusive access to data means that the architecture does not require installation of software on the source or target systems, thereby reducing implementation and maintenance time and costs.

Programming-free configuration eliminates the need for programming and scripting.

Open transformation and filtering features, which are based on standard SQL, can easily be adapted to fit the most complex environments.

ODBC data access makes the entire solution completely operating system-, application-and database-independent and ensures that it will work across your disparate computing environment.

Dynamic connection control automatically reconnects the source and target servers and resumes replication once the connection is re-established after being temporarily disconnected, thus minimizing operator requirements while maximizing up-time.

Flexible replication options allow you to define how data should be replicated based on transaction types, including the ability to dynamically change transaction types, such as converting all updates to inserts, leaving you in complete control of how your data is replicated.

NEW with Integrator 5.0

Guaranteed FIFO data delivery ensures destination database referential integrity.

Active refresh significantly reduces administration when doing synchronization or resynchronization of tables.

Replication of XML data. Following the widely used open XML standard.

Improved configuration manager allows ETL projects requiring a large number of more sophisticated business rules to be maintained.

Improved dashboard enabling mission critical status to be seen at-a-glance at all times.

Improved enterprise architecture meets the increased need for multiple control servers and structure mappings more easily saved to multiple control servers.

Flexible access to metadata makes it easier to validate vs. changing business rules.

Workflow rules eliminates the needs for programming help with sophisticated transformations.

Flexible apply processing eliminates the need for direct data access for replication to business applications.