StarQuest Data Replicator
The StarQuest Data Replicator (SQDR) software provides:
- full-refresh (snapshot) data replication
- bi-directional replication between heterogeneous database systems
- flexible scheduling
- enterprise-level security
- easy-to-use GUI and Wizards
- fast, reliable performance
- comprehensive management function including statistics
StarQuest Data Replicator (SQDR) efficiently replicates data between IBM DB2, Oracle and Microsoft SQL Server databases, providing necessary data integration for Internet and intranet publishing and electronic commerce, data warehousing and data mining. SQDR directly enables these solutions through robust and efficient bi-directional snapshot replication of data.
StarQuest also offers the separately licensed components SQDR Plus for iSeries and SQDR Plus for DB2 UDB that provide incremental replication support for SQDR users. Incremental replications copy only the data that has changed, reducing the amount of data that is transferred and allowing the replication to occur more frequently.
Meeting Mission Critical Database Replication Needs
When you're integrating a client/server application, a data warehouse, or the latest system for the Web, ease of use and comprehensive administration are key requirements. SQDR meets these requirements by providing advanced tools for easy system setup and centralized graphical administration of all replication functions, including filtering, scheduling, and statistics gathering.
Bi-directional Replication
In a heterogeneous environment, applications generally require sending data from the host to distributed systems and consolidation of data from distributed systems to the host. To satisfy these diverse needs, SQDR allows you to move data between IBM DB2, Microsoft SQL Server, and Oracle databases.
Flexible Replication Options
SQDR supports replication of selected columns ("vertical partitioning"), selected rows ("horizontal partitioning"), and replication of selected columns from selected rows (combined vertical and horizontal partitioning). The replicated data can either replace existing tables or be merged on a row-by-row basis. SQDR also supports derived destination columns and data transformations, including automatic conversion of date and timestamps.
Flexible Scheduling
SQDR allows you to control the timing of the replication. Whether it's a repeatable one-time on-demand replication, a one-time scheduled replication, or recurring replication at predefined times, SQDR lets you replicate your data when needed.
Security with Use of Management
Mission-critical data requires mission-critical security. That's why SQDR is fully integrated with both SQL Server/Windows NT security and the native security of your DB2 system.
Complete Statistics
SQDR provides full statistics so you can monitor and view replication activity using the SQDR Manager or Windows NT Performance Monitor. For each replication operation, you can track:
- Throughput
- Number of bytes transferred
- Elapsed time
SQDR v3.4
StarQuest Data Replicator v3.4 adds support for Windows Vista and Windows 2008. Refer to SQDR System Requirements for a complete list of the operating systems and databases that SQDR supports.
Licensing and Pricing Information
Flexible licensing options are available on all StarQuest products. For SQDR pricing information, contact StarQuest at contact@starquest.com, or call 1-415-669-9619.