Today

Microsoft SQL Server


Microsoft SQL Server

    Microsoft SQL Server

    Beta version

    The configuration and connection might need a bit of fine-tuning to get things running smoothly. Let us know if you hit any snags at team@tably.com.

    Once created, a connection can be reused or copy-pasted in all other pages within same workspace without additional setup. The setup can be complex and, if in doubt, ask your developer for help. They will have all needed details and will be able to assist with possible errors.

    The hostname of the database.
    The port of the database.
    The name of the database.
    The list of schemas to sync from. Defaults to user. Case sensitive.
    The username which is used to access the database.
    The password associated with the username.
    Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
    The encryption method which is used when communicating with the database.

    Verify and use the certificate provided by the server.

    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    The replication method used for extracting data from the database. STANDARD replication requires no setup on the DB side but will not be able to represent deletions incrementally. CDC uses {TBC} to detect inserts, updates, and deletes. This needs to be configured on the source database itself.

    CDC uses {TBC} to detect inserts, updates, and deletes. This needs to be configured on the source database itself.

    What data should be synced under the CDC. "Existing and New" will read existing data as a snapshot, and sync new changes through CDC. "New Changes Only" will skip the initial snapshot, and only sync new changes through CDC.
    Existing data in the database are synced through an initial snapshot. This parameter controls the isolation level that will be used during the initial snapshotting. If you choose the "Snapshot" level, you must enable the snapshot isolation mode on the database.
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 1200 seconds. Read about initial waiting time.
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    Hostname of the jump server host that allows inbound ssh tunnel.
    Port on the proxy/jump server that accepts inbound ssh connections.
    OS-level username for logging into the jump server host.
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    Hostname of the jump server host that allows inbound ssh tunnel.
    Port on the proxy/jump server that accepts inbound ssh connections.
    OS-level username for logging into the jump server host
    OS-level password for logging into the jump server host
    Finish step configuration to see output