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
Support Request
Download Request
Activation Request
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
Submit a Request
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: Products End of Support Announcement
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
RFC Replication via Syniti Data Provider
Data Replication from SAP Systems using RFC (via CDATA)
SAP BDC Application-Level Loading for Syniti Replicate
Syniti Data Replication 9.7, 9.8.1, 9.8.2 and 10.x Setup Guides
Syniti Replicate Support Matrix
SNC Configuration for SAP
See all 22 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
1584 - Handling a Missing Transaction ID in the Oracle Redo Log
1641 - How Syniti Replicate Uses Oracle Log Miner and Redo Logs
See all 12 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 S/4 HANA Transactional Replications
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 Guide for SAP CDC for RFC
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
See all 38 articles
More Replication Issues & Questions
Moving SAP CData Connections to Syniti Data Provider
Troubleshoot After a SAP Upgrade that Uses SQL Server Database
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
See all 27 articles
Data Connectivity Issues & Questions
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
1057 - Multithreading support
See all 24 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