Page tree
Skip to end of metadata
Go to start of metadata

Overview 

DBSync's Database connector comes with support for many of the commonly used databases which are of JDBC compliant like oracle, Mysql, DB2 etc. It is implemented in a way so that any user who uses database connector can perform operations of select, Insert, update and delete records on databases. The Database connector contains connection properties of external database like credentials, endpoint URLs, password and these properties are dynamic in nature i.e. for different databases the properties vary and are listed in connector configuration section.

A single connector instance created in a project can be used across different processes but processes should belong to the same project.

Prerequisites

To establish a connection to any of the desired database via DBSync database connector, the user has to do the following.

  • Having a valid license to DBSync database connector, username and password to connect to DBSync iPaaS platform.
  • Should have a valid database username, password, host/IP address and port on which database is hosted.
  • The username and password configured for Database connector instance should have sufficient privilege to access the database which is required for integration requirement.
  • The On-demand version of DBSync will not connect to databases hosted locally and should fall within the network for connection to be successful.

Connector Configurations

 A Database connector instance represents a single database connection. If a user wishes to connect to multiple instances of the different databases, create a separate connection for each and configure the URL accordingly. The below table represent parameters required for opening the connection to the database.

PropertyDescriptionRequired
UsernameDatabase usernameyes
PasswordDatabase passwordyes
HostHost name or IP address of the database serveryes
PortThe port used to connect to database serveryes
DatabaseThe name of your databaseyes
Type

JDBC Driver for the Databases mentioned in the URL section in the same order.

  • sqlserver
  • oracle
  • mysql
  • postgresssql
  • db2          
  • access
yes
Database URL

JDBC connection string

  • SQLServer:
    jdbc:sqlserver://[hostname]:[port];databaseName=[databasename]
  • Oracle:
    jdbc:oracle:thin:@[hostname]:[port]:[sid]
  • mySQL:
    jdbc:mysql://[hostname]:[port]/[databasename]
  • PostgresSQL:
    jdbc:postgresql://[host]:[port]/[database]
  • DB2:
    jdbc:db2://[host]:[port]/[database]
  • Access:
    jdbc:[databasename]
yes

The below table lists out the additional properties that are required while writing/updating to a database. We have a auto create feature and is enabled when target connector is database so that it replicates the whole source schema.

Property

Description

Required

Default Value

Auto create

True if you want the table to be created automatically

no

false

Table

Name of the table to write into

yes

empty

Write type

one of create, update or upsert operations

yes

empty

Prefix

The prefix excluding the '.' operator used for the field names

no

empty

Pkey

Comma separated list of primary key column names

Required if update or upsert

true

The below table lists the advanced properties that are required while updating the source.

Property

Description

Required

Default Value

Table

Name of the table to write into

yes

Empty

Prefix

The prefix excluding the '.' used for the field names

no

Empty

Pkey

Comma separated list of primary key column names

Required if Update or Upsert

true


Supported Databases

The Database connector supports all the database which are JDBC or ODBC compliant. some of the database which we support are as follows.

  • Access
  • DB2
  • MySql
  • Oracle
  • Pervasive Btrive
  • PostgreSql
  • Redshift
  • Sqlserver

Frequently Asked Questions

Q: Does Database connector support Bi-directional data flow?

A: Yes, and you also have the control to make it uni-directional if you chose.

Q: How frequently one can sync the data if reading from or writing to any of the supported databases?

A: The sync can be performed every five minute interval of time.

Q: Is this connector available with both on-demand and on-premise versions?

A: Yes, the Database connector can be used both on-demand and on-premise versions of DBSync Cloud Workflow

Q: How can I try Database connector before purchasing the license?

A: We have a free trial for 15 days after going through the sign up process.

Q: Can both source and target be as database connector?

A: Yes if the integration requirement demands, one can use the database connector to talk to different database or to same databases with different user instances.


  • No labels