Welcome to Syniti Data Replication, providing data replication and transformation for your enterprise server and desktop needs. More than ever before, today’s business applications depend on data from multiple databases. Whether deploying applications to provide customers with real-time answers, to furnish suppliers with time-critical production requirements, or to supply management with the latest metric and financial reports, key data comes from your core relational databases. Enterprises need to move data between database platforms. Fast data delivery between relational database platforms yields better performing applications. Syniti Data Replication does all this and more!
Achieving efficient data delivery with enterprise-sized data requires expertise in database server environments. HiT Software has been delivering relational data access products since 1994, and Syniti Data Replication incorporates our proven access technology to ensure high performance yet minimally intrusive data replication.
Document Download | |
Syniti Data Replication Presentation | Syniti Data Replication Flyer |
Syniti Data Replication Video Presentation | Syniti Data Replication on Youtube |
Real-Time Data Replication
Syniti Data Replication’s Enterprise Manager includes wizards that help you easily connect to and identify source and target databases, create target tables, and set up replication processes. Replication mapping and rules are maintained in a metadata database that can be stored on any database platform. Syniti Data Replication’s Enterprise Manager offers a graphical point-and-click interface that makes it easy to drill down into databases, tables, and columns to understand data elements. Syniti Data Replication was specifically designed to replicate data between databases in “refresh,” “mirroring” or “synchronization” modes.
Syniti Data Replication’s Enterprise Manager includes wizards that help you easily connect to and identify source and target databases, create target tables, and set up replication processes. Replication mapping and rules are maintained in a metadata database that can be stored on any database platform. Syniti Data Replication’s Enterprise Manager offers a graphical point-and-click interface that makes it easy to drill down into databases, tables, and columns to understand data elements. Syniti Data Replication was specifically designed to replicate data between databases in “refresh,” “mirroring” or “synchronization” modes.
Unmatched Database Replication and Database Transformation Control
With Syniti Data Replication, users define data replication and transformations by applying business rules and mapping. Unlike other solutions, Syniti Data Replication
offers unlimited control over data replication and transformation using programming or scripting technologies. Syniti Data Replication supports two mapping methods: automatic mapping, where source field values are duplicated for the target table, and manual mapping. Both methods can be optionally controlled programmatically or via scripts. Syniti Data Replication also includes a powerful expression generator for interactive data transformation. A key advantage of Syniti Data Replication is data delivery and transformation control via scripts and events independent of the associated databases. Syniti Data Replication automatically generates replication events during operation. Administrators can define responses to these events with scripts and configure Syniti Data Replication to be notified via email if critical events occur.
Syniti Data Replication also includes a Windows environment accessible object class that provides detailed control of source and target data during replication. The object properties and methods give users control to perform source or target table lookups, append log activity, and update target tables. All information retrieved from transaction logs, such as user, date and time and device is available within the class object.
No Programming Required on Source or Target Databases
Highly extendable on the middle tier Windows platform, Syniti Data Replication does not require any programming on the source or target database platforms: no programming needed on the source database; no stored procedures to develop; no proprietary syntax to learn.
- Support for all major database platforms: IBM DB2 UDB (including System i/iSeries/AS400 and zOS), Oracle, Microsoft SQL Server, MySQL, Sybase Adaptive Server Enterprise, SQL Anywhere, Ingres, Informix, MS Access, Gupta SQL Base, Solid, Firebird, PostgreSQL and ANTs
- Replication modes: refresh, mirroring, synchronization
- Administrative wizards for fast, easy configuration and setup
- No programming needed on source or target database platforms
- Full customization via Microsoft VB.NET or C# scripting and event-driven environment
- Built-in transformation functions, with custom functions definable at any time
- Remote accessibility of Enterprise Manager for centralized configuration and management
- Extensive log reporting and accessibility
- Powerful visual tool to provide information on replication status
- Object-oriented data access on both source and target databases
- Automatic creation of target tables
- Configuration and management of entire replication process from Windows platform
- User-friendly and graphical interface
- Standard protocols (.NET, OLE DB and ODBC) to access tables in source and target databases
- Built-in tool for data integrity checking (real-time, or schedule) to safeguard data consistency between source & target databases. The “Verifier” tool has flexibility checking criteria to balance data security and performance.
- Actian™ Vectorwise™.
- Amazon Aurora
- Amazon RDS for MariaDB
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon RDS for SQL Server
- Amazon Redshift
- Apache Hadoop (HDFS) v2.6.0 and later
- Google App Engine DataStore
- Gupta Technologies SQLBase Server V8.5.0 and later
- IBM System i5, iSeries and AS/400 V4R3 and later
- IBM DB2 for zOS (OS/390) v5 and later
- IBM DB2 for LUW v5 and later
- IBM Informix
- IBM PureData System for Analytics (Netezza)
- Ingres 2006
- MariaDB
- Microsoft Azure SQL Database
- Microsoft Azure SQLv11 and later
- Microsoft SQL Server v6.5 and later
- MySQL v3.23 and later
- Oracle v8 and later
- PostgreSQL
- SAP ECC
- SAP HANA
- SAP IQv15.4 and later
- SAP Sybase ASE v12.50 and later
- SAP Sybase SQL Anywhere
- Structured Files (CSV, JSON)
- Teradata V13 and later
- Tibero
- Vertica
- Amazon Aurora
- Amazon RDS for MariaDB
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon RDS for SQL Server
- Gupta Technologies SQLBase Server V8.5.0 and later
- IBM System i5, iSeries and AS/400 V4R3 and later
- IBM DB2 for zOS OS/390) v5 and later
- IBM DB2 for LUW v5 and later
- IBM Informix IBM PureData System for Analytics (Netezza)
- MariaDB
- Microsoft Azure SQL Database
- Microsoft Azure SQLv11 and later
- Microsoft SQL Server v6.5 and later
- MySQL v3.23 and later
- Oracle v8 and later
- PostgreSQL
- SAP ECC
- SAP HANA
- Sybase ASE v12.50 and later
- Sybase SQL Anywhere
- Actian™ Vectorwise™
- Amazon Aurora
- Amazon RDS for MariaDB
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon RDS for SQL Server
- Amazon Redshift
- Apache Hadoop (HDFS) v2.6.0 and late
- Apache Kafka
- Google App Engine Datastore
- Gupta Technologies SQLBase Server V8.5.0 and later
- IBM System i5, iSeries and AS/400 V4R3 and later
- IBM DB2 for zOS OS/390) v5 and later
- IBM DB2 for LUW v5 and later
- IBM Informix
- IBM PureData System for Analytics (Netezza)
- Ingres
- MariaDB
- Microsoft Azure SQL Database
- Microsoft Azure SQLvl1 and later
- Microsoft SQL Server v6.5 and later
- MySQL v3.23 and later
- Oracle v8 and later
- PostgreSQL
- SAP HANA
- SAP IQ V15.4 and later
- SAP Sybase ASE v12.50 and later
- SAP Sybase SQL Anywhere
- Structured Files (CSV, JSON)
- Teradata V13 and later
- Tibero
- Vertica
* Updated database support list please refer to Syniti’s official page here.
- Windows Server 2003/2008/2012 32-bit or 64-bit
- .NET Framework 4.0 or higher
- Pentium i7 (equivalent) 2.50GHz or above
- Minimum 16GB RAM
- 50GB Disk Space (SSD Drive Recommended)