DBSync Cloud Workflow (iPaaS)

2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 38 Next »

Database to Intacct Integration

  • Setup your Database for Integration. For this Tutorial I am using MySQL Database Named "IntacctDB".
  • Create tables "dbaccount" 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 a sample data in "dbAccount" table.
  • Go to www.mydbsync.com. Open www.mydbsync.com in your browser and click on Customer Login.
  • 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 Database-Intacct & click on Save.
  • A new Project will be created by given Name. In this tutorial I have used name Database-Intacct.
  • Click on Create New Process, enter process name as DatabasetoIntacct, click on Save to save the process.
  • Click on Connectors on the left section of Project console. You need to create new connectors for Database & Intacct.
  • Click on Create New Connector enter the connector name as Intacct & select the connector type as Intacct Adapter and click on Save.
  • Enter all the required details, click on Save & then Validate connection.
  • Intacct Connector is created and the connection is validated. Next, Database adapter need to be created.
  • Click on Connectors on the left section of Project console. Click on Create New Connector.
  • Enter connection name as Database & select the connector type as Database Adapter and click on Save.
  • Enter all the required details, click on Save & then Validate connection.
  • Click on Projects, click on the project Database-Intacct, there you will see the new process DatabaseToIntacct. Click on the newly created process DatabaseToIntacct.
  • Using the button Create New Workflow, create the workflow "Execute".
  • Click on workflow Execute, You will see two sections Trigger on the top & Rules in the bottom.
  • In Trigger section, go to Advanced Query Builder select Datasource as Database.
  • Click on Switch to Advanced view & enter the below query in the Query Builder. Click on Save and Close.
 select AccountID, AccountName, BillingStreet, BillingPostalCode, AnnualRevenue, LastModifiedDate, NumberOfLocations from dbaccount
  • In Rules section of a workflow, click on Add New Rule, Select Target Connector, Operation, Target Object as Intacct, Insert, create_customer respectively.
  • Click on the Map in this newly created Rule, you will see a mapping screen.
  • In the mapping screen, you will see list of target fields in the left section. On the right you will the source fields under Schema.
  • Drag & drop the required fields from Schema into the required source fields.
  • Once you are done close the mapping screen from Save and Close button on the top right. Save the workflow and ensure that the status of workflow is On.
  • You can run the integration, using the Run button or the Scheduler in the left section of Project console. Run button is available once you open the project.
  • Using the button Logs in the left section, you can view the Logs.
  • This concludes brief introduction on building DBSync integration data flow from Database to Intacct.
  • No labels