Page History

...

• Setup your Database for Integration. For this Tutorial I will be using MySQL Database Named "IntacctDB".
• Create tables "dbaccount" in Database with following script.

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 to www.mydbsync.com.
• Select Open www.mydbsync.com in your browser and click on Customer Login.
• Enter in your User Name and Password and click Login Button.Go to My Home DBSync username and password to login.
• Once logged in, click on My Home from the menu and click on Launch Button in Console Area.In DBSync console button in the following page to navigate to DBSync console page.
• Once into the DBSync console, click on Create profile Button, Enter Profile Name and click on Save Button as shown.

• A new Profile will be created by given Name. In this tutorial I have used name Database-Intaact. The Profile will be listed in the profile area as shown below:

...

• Once you are done close the mapping screen from close button on the top right. In the DBSync Console click the RUN button to run the sync (A screenshot is shown below).

• Open www.mydbsync.com in your browser and click on Customer Login.
• Enter in your DBSync username and password to login.
• Once logged in, click on My Home from the menu and click on Launch button in the following page as shown.