ReplicaDB configuration wizard

Create a configuration file for a ReplicaDB process by filling out the following form

ReplicaDB Basics
Specifies the replication mode
Use n jobs to replicate in parallel
Number of entries to read from database at once
In Kilobytes per second estimated
Print more information while working
Source Options
Data Source Type
Connection Settings
Properties as key=value pairs to pass to the JDBC driver to make the connection, e.g. ApplicationName=ReplicaDB
SQLite Settings

Data Filtering

Table to read, e.g. public.employees
Comma-delimited list of columns to be replicated, e.g. column1, column2, column10
WHERE clause to use during import, e.g. "id > 400"

SQL statement to be executed in the source database, e.g. SELECT a.*, b.* FROM a JOIN b on (a.id == b.id)
File Settings
Sets the columns data types. You should define the correct data type of your columns in the exact order in which they appear in the file.
Column Number Column Data Type

    You can drag and drop table items to rearrange them.


    Parsing and Formating File Data
    Base predefined CSV format

    Field delimiter character
    QuoteChar character
    Escape character
    The String to convert to null
    The first line of the file is the header
    Empty lines between records are ignored
    Spaces around values are ignored
    Trim leading and trailing blanks
    Sink Options
    Data Source Type
    Connection Settings
    Properties as key=value pairs to pass to the JDBC driver to make the connection, e.g. ApplicationName=ReplicaDB
    SQLite Settings

    Data Maping
    Table to be populated. e.g. hr.collaborators
    Comma-delimited list of table columns to be populated, e.g. column2, column10, column1

    Staging Options

    Scheme name, with right permissions, for creating staging tables

    Qualified name of the staging table. The table must exist.

    Escape the strings before inserting into the table.

    Truncate the sink table before populating.
    File Settings

    Parsing and Formating File Data
    Base predefined CSV format

    Field delimiter character
    QuoteChar character
    Field delimiter character
    Escape character
    The String to convert to null
    The first line of the file is the header
    Apache Kafka Settings
    comma-separated list of host and port pairs, that are the addresses of the Kafka brokers in a Kafka cluster
    The Kafka topic used for produced events
    The topic Partition Number
    Properties as key=value pairs to pass to the Kafka producer client.
    All properties: https://kafka.apache.org/documentation/#producerconfigs
    client.id=ReplicaDB
    batch.size=10



    Run replicadb on your machine with this command:
    $ ./bin/replicadb --options-file replicadb.conf