Configuring your connectionsConnection configurations
MySQL
Connection
Description
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
hostname | string | true | false | |
account | string | true | false | |
passwd | string | true | false | |
dbname | string | false | false | |
port | integer | true | false | |
ssl | boolean | false | false | |
ssh | boolean | false | false | |
ssh_user | string | false | false | |
ssh_host | string | false | false | |
ssh_port | integer | false | false | |
ssh_private_key | string | false | false | |
change_detection | boolean | false | false |
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
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
query | string | false | false | |
table | string | Table | false | false |
view | string | View | false | false |
Example
1 { 2 ... 3 "configuration": { 4 "query": "SELECT * from users", 5 "table": "users", 6 "view": "active_users" 7 } 8 }
Target
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
preserve_table_on_resync | boolean | Preserve destination table when resyncing | false | false |
Example
1 { 2 ... 3 "target": { 4 "configuration": { 5 "preserve_table_on_resync": false 6 } 7 } 8 }