Configuring your connectionsConnection configurations

MySQL

Connection

Description

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
hostnamestringtruefalse
accountstringtruefalse
passwdstringtruefalse
dbnamestringtruefalse
portintegertruefalse
sslbooleanfalsefalse
sshbooleanfalsefalse
ssh_userstringfalsefalse
ssh_hoststringfalsefalse
ssh_portintegerfalsefalse
ssh_private_keystringfalsefalse
change_detectionbooleanfalsefalse

Example

1{
2 "name": "mysql connection",
3 "type": "mysql",
4 "configuration": {
5 "account": "admin",
6 "change_detection": false,
7 "dbname": "mydb",
8 "hostname": "database.example.com",
9 "passwd": "password",
10 "port": 3306,
11 "ssh": false,
12 "ssh_host": "",
13 "ssh_port": 22,
14 "ssh_private_key": "",
15 "ssh_user": "",
16 "ssl": false
17 }
18}

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
querystringfalsefalse
tablestringTablefalsefalse
viewstringViewfalsefalse

Example

1{
2 ...
3 "configuration": {
4 "query": "SELECT * from users",
5 "table": "users",
6 "view": "active_users"
7 }
8}

Target

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
preserve_table_on_resyncbooleanPreserve destination table when resyncingfalsefalse

Example

1{
2 ...
3 "target": {
4 "configuration": {
5 "preserve_table_on_resync": false
6 }
7 }
8}

Bulk Sync

Source

N/A

Destination

N/A