Message-ID: <2047282338.85993.1711629361684.JavaMail.wiki@ip-172-26-1-188> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_85992_373279624.1711629361682" ------=_Part_85992_373279624.1711629361682 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
DBSync's Database connector comes with support for many of the commonly = used databases which are of JDBC compliant - like oracle, Mysql, DB2 etc. I= t is implemented in such way that any user, that uses database connector, c= an perform operations like, select, Insert, update and delete records, on d= atabases. The Database connector contains connection properties of external= database like credentials, endpoint URLs and Password. These properties ar= e dynamic in nature i.e. for different databases the properties vary and ar= e listed in connector configuration section.
A single connector instance, created in a project, can be used across di= fferent processes. However, the processes must belong to the same project.<= /p>
To establish a connection, to any of the desired database via DBSync dat= abase connector, a user must:
A Database connector instance represents a single database connect= ion. If a user wishes to connect to multiple instances of the different dat= abases, create a separate connection for each and configure the URL accordi= ngly. The following table represents parameters required for opening the co= nnection to the database.
Property | Description | Required |
---|---|---|
Username | Database username. | Yes |
Password | Database password. | Yes |
Host | Host name or IP address of the database server.<= /td> | Yes |
Port | The port used to connect to database server. | Yes |
Database | The name of your database. | Yes |
Type | JDBC Driver for the Databases mentioned in th= e URL section in the same order.
|
Yes |
Database URL | JDBC connection string
|
Yes |
The below table lists additional properties that are required while writ= ing/updating to a database. DBSync has an auto create feature. The feature = is enabled when target connector is database so that it replicates the whol= e source schema.
Property |
Description |
Required |
Default Value |
---|---|---|---|
Auto create |
True if you want the table to be created auto= matically. |
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 fo= r the field names |
No |
Empty |
Pkey |
Comma separated list of primary key column na= mes |
Required if update or upsert |
True |
The below table lists the advanced properties that are required while up= dating 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 fie= ld names |
No |
Empty |
Pkey |
Comma separated list of primary key column na= mes |
Required if Update or Upsert |
True |
Supported Databases
The Database connector supports all the database that are JDBC or ODBC c= ompliant. Some of the supported databases are listed below:
Q: Does Database connector support Bi-directional data flow?
A: Yes. Furthermore, if you so choose, you can also make it uni-dir= ectional.
Q: How frequently one can sync the data if reading from, or writ= ing to, any of the supported databases?
A: The sync can be performed at every five minutes time interval.
Q: Is this connector available with both, On-demand and On-premi= se, versions?
A: Yes. Database connector can be used with both, On-demand and On-premi= se, versions of DBSync Cloud Workflow.
Q: How can I try Database connector before purchasing the licens= e?
A: We have a free trial for 15 days after going through the sign up proc= ess.
Q: Can both, source and target, act as database connectors?
A: Yes. If integration requirement demands, one can use the database con= nector to talk to different databases, or to the same databases, with diffe= rent user instances.