DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version 2

changes.mady.by.user Anil Bhimineni

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The below table gives the required and optional parameter to be set for establishing a connection of database and to write the various tables as chosen in the relevant workflows .
  2. Click on save to save the parameter settings.
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
Panel

Configuring Target App

...

The below table gives the required and optional parameter to be set for establishing a connection of Salesforce from which you would like to read the data and write to Salesforce.


Property

Description

Required

UserName

The username to log into salesforce account.

yes

Password

The password to login to salesforce account

Yes

End-point

https://www.salesforce.com/services/Soap/u/32.0

yes

Sid

Session Id

optional

Transport.compression

For compression

optional

Proxy Host

If you use a proxy server then put <<proxy ip or host>>

optional

Proxy Port

If you use a proxy server then put <<proxy port>>

optional

Proxy Username

If you use a proxy server then put <<proxy username>>

optional

Proxy Password

If you use a proxy server then put <<proxy password>>

optional

Accept Gzip

As Applicable

optional

Send Gzip

As Applicable

optional

Tip

For the sake of understanding, I have chosen MySQL database with tables as contacts, customers, items, oppheader, opplineitem in which data from Salesforce is dumped. In You can download the sql script from this link and import the table structures in-case if you do not have existing database in which you wish to dump the data, you can use autocreate functionality of database connector which would create the table structure and mapping basing on the source tablethe same integration requirement which this tutorial explains.

Panel

DBSync Project Setup

...