DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 11

changes.mady.by.user Vishwanath B

Saved on

compared with

New Version 12

changes.mady.by.user Vishwanath B

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Panel

Intacct to Database Integration

  • Setup your Database for Integration. For this Tutorial I am using Oracle Database named "IntacctDB".
  • Create table "Account" in Database with following script.

Database Script : MYSQL

Database Script : SQLSERVER

Database Script : Oracle

create table `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`) );

create table 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) );

CREATE TABLE "SYS"."DBACCOUNT"

("ACCOUNTID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"ACCOUNTNAME" VARCHAR2(100 BYTE),
"BILLINGSTREET" VARCHAR2(50 BYTE),
"BILLINGPOSTALCODE" VARCHAR2(50 BYTE),
"ANNUALREVENUE" NUMBER(30,2),
"CREATEDDATE" DATE,
"LASTMODIFIEDDATE" VARCHAR2(40 BYTE),
"NUMBEROFOFFICELOCATIONS" NUMBER(*,0),
CONSTRAINT "DBACCOUNT_PK" PRIMARY KEY ("ACCOUNTID")
);

  • Enter your DBSync username and password to login. Click on Launch to navigate to Project console.
  • Click on Project on the left section of console. Click on Create New Project, enter project name as Intacct-Database & click on Save.
  • A new Project will be created by given Name. In this tutorial I have used name Intact-Database.
  • Click on Create New Process, enter process name as IntacctToDatabase, click on Save to save the process.

...