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 Database Connector

Database Connector

=20
=20
=20
=20

= 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. 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>

Prerequisites

To establish a connection, to any of the desired database via DBSync dat= abase connector, a user must:

  • Have a valid license to DBSync database connector, username and passwor= d to connect to DBSync iPaaS platform.
  • Have a valid database username, password, host/IP address and port on w= hich database is hosted.
  • The username and password configured for Database connector instance sh= ould have sufficient privilege to access the database - which is required f= or integration requirement.
  • The On-demand version of DBSync will not connect to databases hosted lo= cally. It must fall within the network for connection to be successful.

Connector Configurations

 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.

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

JDBC connection string

  • SQLServer:
    jdbc:sqls= erver://[hostname]:[port];databaseName=3D[databasename]
  • Oracle:
    jdbc:oracle:= thin:@[hostname]:[port]:[sid]
  • mySQL:
    jdbc:mysql://= [hostname]:[port]/[databasename]
  • PostgreSQL:
    jdbc:pos= tgresql://[host]:[port]/[database]
  • DB2:
    jdbc:db2://[hos= t]:[port]/[database]
  • RedShift:
    jdbc:redshift://[host]:[port]/[data
  • Access:
    jdbc:[databa= sename]
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


Frequently Asked Questions

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.


=20
=20
=20 =20
------=_Part_85992_373279624.1711629361682--