Replicating from a Flat File

When replicating from a relational database to a flat file, Syniti Replicate allows you to replicate data as a Refresh.

A one-time complete replication from CSV or TXT format flat file, according to replication settings and scripts. You can control the timing of the replication, identify the columns to be replicated and add scripts to transform data during replication.

When replicating from a file as a source, use the Microsoft Text ODBC Driver. This driver is typically available with Microsoft Office packages containing Access, or by installing the Microsoft Access Database Engine 2010 Redistributable.

Source data files should contain comma-separated column names as the first row, followed by one row of data per record as a list of comma-separated column values.

ID,NAME

1,"aaa"

2,”bbb”

If you want to define a different separator, like pipe or tab, you must set the ODBC connection:

  1. Open the ODBC Data Source Administrator in Windows and create a New Data Source, selecting Microsoft Access Text Driver.

  1. Select the directory in your local network where the flat files are stored.

  1. Select Options to define the format for your source flat files. You can select a Custom Delimiter, to select a special character as text delimiter (pipe, semicolon, etc.)

  1. Download the Flat File Setup Guide in the Help Center for complete details.