DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 10

changes.mady.by.user Chandra Kumar

Saved on

compared with

New Version 11

changes.mady.by.user Avinash Rao

Saved on

Key

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

...

  • Setup your Database for Integration. For this Tutorial I will be using MySQL Database Named "testIntacctDB".
  • Create tables "dbaccount" in Database with following script.
Code Block
langsql
titleDatabase Script
borderStylesolid
create table `test``IntacctDB`.`dbAccount`

( `AccountID` varchar(100) NOT NULL ,
`AccountName` text NOT NULL ,
`BillingStreet` text ,
`BillingPostalCode` numeric(20) ,
`AnnualRevenue` decimal(30,2) ,
`CreatedDate` date ,
`LastModifiedDate` datetime ,
`NumberOfOfficeLocations` int ,
PRIMARY KEY (`AccountID`)
);

...