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.

...

• Database Script : MYSQL

...

• Code Block

...

• 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`) ); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000001','ABC Softwares','B-405, Ginger street','411027','500000.00','2010-10-26','2010-10-26 00:00:00','5'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000002','DEF Softwares\r\n','3000 Town Center, Suite 2850, Southfield, MI','411027','100000.00','2010-10-26','2010-10-26 00:00:00','6'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000003','Alfa Softwares','Burlington, MA\r\n','411027','700000.00','2010-10-26','2010-10-26 00:00:00','2'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000004','Cognizant Technologies','566 St. Kilda Road,Melbourne','411028','500000.00','2010-11-02','2010-11-02 10:22:00','56'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000005','Infosys Technologies','3326 160th Avenue SE, Suite 300, Bellevue, WA','411028','700000.00','2010-11-02','2010-11-02 10:23:00','90');

• Enter some test data in "dbAccount" table. Go To www.mydbsync.com.
• Select Customer Login. Enter your User Name and Password and click Login Button.
• Go to My Home and click on Launch Button in Console Area.
• In DBSync console click on Create profile Button, Enter Profile Name and click on Save Button.

...