|
|
SQData: Data Integration and Synchronization
SQData provides a comprehensive range of data replication and data integration solutions that deliver fast time to value. With enterprise wide scalability, SQData integrates disparate data sources and supports multiple data delivery styles, enabling seamless sharing of data across the entire enterprise.
 Data Replication
|
|
SQData Data Replication provides the power and flexibility to:
- Move data from any source to a range of targets (more than just traditional DBMS
- Move data in any direction, using multiple data delivery styles
- Move data with near real time latency
- Move only data that is changed
- Provide the confidence of consistency checking at the speed of data
- Provide the ability to trigger business events based on the data
With SQData, you can choose the combination of data access, transformation and delivery options to ensure that timely and trusted data is available to all types of consuming applications and DBMSs. In this way you can:
- Synchronize your data multidirectionally amongst a number of like systems for high availability
- Replicate data changes to a live standby subsystem
- Replicate changed data to a variety of disparate systems on different platforms and OS to make it available wherever you need your data
- Implement staged consolidation of data from a variety of heterogeneous systems onto a data warehousing platforms for BI
- Implement near-real-time conversion and integration of data between legacy systems and new systems.
- Create a single view of an object, such as an order, from a multiple of differently formatted source versions
With SQData, data replication options include One-to-One, One-to-Many, Many-to-One or Many-to-Many. With any of these replication options, identified data of interest or captured events can be:
- Routed to a different platform
- Put on a queue, or other downstream delivery
- Options including XML, binary or delimited
- Used for event publishing to capture key business events (such as trouble tickets, orders, product shipments)
- Used as a trigger (for fraud detection)
- Augmented with other information via lookups or joins
- Forwarded to other applications
For more information:
|
|
|
|
Data Integration
|
|
With SQData, organizations can integrate legacy data into newer databases for use on new platforms by new applications, as shown in Figure 1. Source data can be virtually any database on any platform; similarly, target data can be any database on any platform. Figure 1 shows data integration as a one-way process. It can be a one-way process, and it can be a one-time conversion, or an ongoing one-way process. However, it can also be a two-way process.
Figure 2 shows a two-way data integration process. Legacy application data used by legacy applications on one platform can be integrated with data on a second platform that is used by newer applications. At the same time, the data used by the newer applications on the second platform can be integrated with the legacy data used by the legacy applications on the first platform. Further, this type of data integration is not limited to two databases on two platforms—any number of platforms can share integrated data with any number of platforms.
This level of data integration allows organizations to achieve a virtual application integration while avoiding the expense of actually modifying applications.
Both source and target platforms can support many configurations including:
For more information:
|
Figure 1: One-way data Integration
 Figure 2: Two-way (multi-way) data Integration |
|
|
SQData LiveCheck
|
|
SQData LiveCheck is an complementary product that ensures source-to-target integrity during active replication. It can be used with an SQData solution, or to enhance an existing ETL system. LiveCheck also:
- Eliminates post-processing to address data inconsistencies
- Provides data consistency for high-volume, 24x7 data operations
- Resynchronizes individual rows or ranges of rows (with LiveSynch; available with LiveCheck)
- Can be added to existing CDC installations
For more information:
|
Figure 1: SQData LiveCheck |
|
|
SQData Design Studio
|
|
The SQData Design Studio is an easy to use Graphical User Interface (GUI) that enables you to quickly develop and deploy your replication, ETL and data integration interfaces. Here are some highlights:
- Integrated metadata repository
- Create relational DDL from COBOL copybooks
- Generate CDC and ETL interfaces
- Extensive transformation functionality
- Normalization of repeating groups
- External lookups/joins
- Data filtering/cleansing
- Relational and Non-Relational database support
- Multiple data delivery formats - XML, delimited, binary, etc.
- Enables reuse of common objects
- Supports high-performance, cross-platform operation
- Rapid deployment
For more information:
|
Figure 1: Design Studio |
|
|
SQData Control Center
|
|
The SQData Control Center is a web-based component that allows you to manage and monitor your SQData processes from a single control point. Here are some highlights:
- Web based support for all major browsers including smart phones/devices
- View processes on all servers
- Start and stop capture agents and integration engines
- Real-time statistics collection and display
- Monitoring and alert notification
- Historical analysis and trending
- Manage multiple notification schedules
- Flexible security model for users of all levels
- Auditing of controlled events
- Deployed as a self-contained virtual server instance
- Built-in graphs and reports
For more information:
|
Figure 1: Control Center |
|
|
|
