DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 24

changes.mady.by.user Tushar Singh

Saved on

compared with

New Version Current

changes.mady.by.user Avinash Rao

Saved on

Key

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


Initiating DBSync integration through Rest-Call



DBSync integration can also be initiated without having to login to www.mydbsync.com. The sync can be initiated from an external application, say with a click of a button or a URL. The following section illustrates how this customization can be achieved.

...

Info
titleHTTP Post Request

Post URL: http(s)://<<server>>:<<port>>/dbsync2cw/dbsyncrestservice.m
Post Parameters:
1. authenticationXML:  It provides the authentication username/password and name of the profile.
2. profileXML: Defines the connection profile for the integration process to execute. See "Profile" section below
3. payload: Defines the process to execute. The name is in the form of "processdefinition_"<<process_name>>".xml 

All post parameters should be UTF-8 encoded.

...

Code Block
<authentication>
<userName>username@yourcompany.com</userName>
<password>your_password</password>
<profile>Sage Sage IntacctToDatabase</profile>
</authentication>


Image RemovedImage Added

Profile :

Profile is basically an XML file and it defines the Business Process to execute. The name of a profile or the xml file is always prefixed with "processdefinition" and usually is in the form of "processdefinition_"<<process_name>>".xml

Profile.xml file stores configuration details of your integration adapters for which you have registered at the time of purchase. The default installation folder of DBSync would be "C:\DBSyncIS292DBSync_Cloudworkflow_x". Presuming that DBSync is installed in the default directory, you can find the path of the profile.xml as shown below.

C:\DBSyncIS292\ dbsync2DBSync_CloudWorkflow_x\CloudWF\WEB-INF\conf\db\<DBSync Username>\<Profile Name>\ profile.xml

Image RemovedImage Added

A sample profile.xml file is shown below with configuration details of the adapters that are used for integration.

...

  1. Login to www.mydbsync.com and click on Customer Login tab
  2. Login with the provided DBSync Username & Password
  3. Click on My Home link from the Menu, you will be re-directed to Launch page.
  4. Once into DBSync Home page, Click on Launch Development Studio button and you will be directed to Profile workspace page of DBSync.
  5. Once inside the profile page, click on Manage --> Edit as shown below. You will be re-directed to Process-Builder page

...