Skip to main content
Resources
Agent Knowledge Base
Visit our Website
Partner Portal
Data Insiders
Product Help
System Availability
Training Courses
Feature Requests
Software
Knowledge Platform (SKP or ADMM)
Stewardship Tier (SST, ADM, or DSP)
Data Matching (or matchit)
Data Replication (Replicate, SDR)
Data Workbench (SDW or Quadrate)
Rapid Data Governance (RDG)
Product Help
Submit a Request
Knowledge Platform (SKP or ADMM)
Syniti-hosted Database
Stewardship Tier (SST, ADM, or DSP)
Syniti-hosted Server or DB
Data Matching (or matchit)
Data Replication (Replicate, SDR)
Data Workbench (SDW or Quadrate)
Rapid Data Governance (RDG)
Other Syniti Software
Download Request
Activation Request
Internal Syniti CloudOps Request
Sign in
Sign in
Submit a Request
Agent Knowledge Base
Visit our Website
Partner Portal
Data Insiders
Product Help
System Availability
Training Courses
Feature Requests
Data Replication
Formerly DBMoto from HiT Software. Includes Replicate, SDR, & DB2 drivers.
Software Support
Data Replication
Read Product Help
Ask a Question
Suggest a Feature
Download a Product
Update a License
News & Quick Links
AMSP Customers - Download Latest Version
Uploading Files to the Syniti Software Support team
Syniti Replicate, Syniti Data Replication and DBMoto Supported .NET Providers
Vulnerability in Apache Log4j
Guide to the Data Replication & Data Connectivity Support Site
Release Notes
Syniti Replicate v10.x Release Notes
Syniti Data Replication (DBMoto) V9.8.2.15 Release Notes 12/2/22
Important: Before Upgrading to Syniti Data Replication 9.7
ODBC/400 v12.0.0.1 Release Notes 1/29/20
ODBC/u v8.0.0.0 Release Notes 01/13/20 (formerly ODBC/DB2)
JDBC/400 v. 3.34 Release Notes 1/3/20
See all 12 articles
Data Replication Documentation
Data Replication from SAP Systems using RFC
SAP BDC Application-Level Loading for Syniti Replicate
Syniti Data Replication 9.7, 9.8.1, 9.8.2 and 10.x Setup Guides
Data Replication End of Life Details
[Replicate] Volume Testing & Tuning Guide for Refresh Mode
Error after upgrading SDR/DBMoto 9.5.x (and older)
See all 20 articles
IBM Db2 for i
Setup Notes for IBM Db2 for i Transactional Replications
1556 - Managing IBM Db2 for i Journals and Receivers
1570 - Primary Key Not Shown for IBM Db2 for i DDS Tables
1598 - Profiles and Permissions for IBM Db2 for i Replications
1602 - Using IBM Db2 for i, RRNs as Primary Keys in Mirroring
1617 - Replicating IBM Db2 for i Logical Files and Views
See all 17 articles
MS SQL Server
Syniti Replicate - MS SQL Server Database Matrix
Setup Notes for Microsoft SQL Server Transactional Replications
Setup Notes for Replications in SQL Always On AG Environment
1429 - MS SQL Server Replication Never Started
1444 - Configuring MS SQL Server Agents to Provide More Detail
1559 - Extending MS SQL Server Log Beyond 72 Hours
See all 16 articles
MySQL
Enabling LOCAL INFILE in MySQL
Setup Notes for MySQL Transactional Replications
1657 - Converting a MySQL Zero Datetime
1668 - MySQL error when char is automatically used as Guid
Oracle
Setting up a replication from Oracle to SQL Server (Demo)
Setting up Data Replication from Oracle to Kafka
Setup Notes for Oracle Transactional Replications
1529 - Oracle Requirements for Transactional/Mirroring Replications
1572 - Errors in creating dictionary file in Oracle 8.1.7
1584 - Handling a Missing Transaction ID in the Oracle Redo Log
See all 13 articles
PostgreSQL
Setup Notes for PostgreSQL Transactional Replications
1670 - Bulk Insert with PostgreSQL Target Databases
3018 - Using Partition Tables when Mirroring with PostgreSQL
SAP HANA
Setup Notes for SAP HANA Transactional Replications
Replication Scripts
1600 - Creating a Join Between Two Tables for Replication
1604 - Script Examples of Mapping Two Fields to a Single Field
1610 - Script Example of Data to Datetime Conversion
1611 - Script Example for Converting Dates
1612 - Script Example to Filter a Truncate Operation
1613 - Script Example to Skip Processing Records
See all 11 articles
More Replication Setup Guides
Setup Notes for Google BigQuery
Setup Notes for Amazon DocumentDB Targets
Setup Notes for IBM Db2 LUW Transactional Replications
Setup Notes for IBM Db2 for z/OS Transactional Replications with Triggers
Setup Notes for IBM Informix Transactional Replications
Data Replication to MariaDB
See all 37 articles
More Replication Issues & Questions
Advanced Settings for AWS Azure Data Lake Gen 1 and Gen 2
Issue with SDR 9.78.11 Patch and Oracle Replications
1462 - Errors occur when target fields are too small
1466 - No Error on Strings Truncated
1470 - Replicating IDENTITY Fields
1608 - Replicating BLOB and CLOB Data Types
See all 27 articles
Data Connectivity Issues & Questions
Generating an Allora Trace
1011 - SQL0490 - "Numeric value 61504 not valid" on creating stored procedure
1039 - Packages may cause issues following an OS upgrade
1043 - Package Names and Authorizations for Db2 Packages
1047 - Syntax for dropping a table on IBM i
1056 - Using Journals with IBM Db2 for i
See all 27 articles
Ritmo .NET Providers
Generating a Ritmo Trace
1365 - Connecting to IBM Db2 for i using Ritmo/DB2
1375 - Create a trace for diagnostic purposes
1394 - Code Samples for Ritmo .NET Providers
OLE DB Connectivity
Generating a HiT ODBC or OLE DB Trace
1345 - Inner Join Local and Remote Tables on SQL Server
1369 - Creating a SQL Server Linked Server Using T-SQL
1659 - Creating a Linked Server
ODBC Data Connectors
1026 - Difference between ODBC/400 and ODBC/Db2
1110 - Using wildcards when linking/importing into Excel or Access
1155 - ###### values received when linking to Access
1160 - Importing Data into MS Excel and Word
1505 - Two Phase Commit Transaction Support with ODBC Drivers
1635 - Locate a Product License Key
JDBC Data Connectors
Generating a JDBC Driver Trace
1017 - "java.sql.SQLException: [BINDING] invalid authorization id:..." Error Message
1018 - Query fails when the library name contains a period
1137 - "[FETCH] result set is closed” Error Message
1171 - How to generate a JDBC trace file
1201 - “Java.lang.NegativeArraySizeException” Error
See all 10 articles