2022
Page History
...
- Setup your Database for Integration. For this Tutorial I will be using MySQL Database Named "salesforcetest".
- Create tables "dbAccountdbaccount" and "dbAccountNew" in Database with following script.
...
Database Scripts
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
create table `test`.`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`) |
...
); |
...
- 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.
...
Overview
Content Tools