...
In this case we are matching data from / to a database to data to / from a file. There is no specific requirement on names. The columns belonging to a table in the database must be muched matched by the user to the columns defined in the file. Following For example the example below defined, we will match below table matches the columns of a table named Account , which contains fields that resemble (see below Preliminary Steps) with the fields in the table Accounts in Salesforce.
Image Removed
BSync's process will match each of the field tables with the database tables as defined in the Data Map. In our example:
Image Removed
You can map any of the table columns to any of the file columns. However, it is advisable to keep the nomenclature. I our example we will match similarly to what we defined in our data map.
Panel |
---|
Preliminary steps Steps (Database preparation): |
- Setup your Database for Integration ( For this Tutorial I will be using MySQL Database named "Accounts".)
- Create a Table "dbAccount" in Database. The scrips below show how to do it for MySQL, SQLSERVER and Oracle databases.
- Once you have created the table insert some dummy values on it.
Database Script : MYSQL | Database Script : SQLSERVER | Database Script : Oracle |
Code Block |
---|
create table `Accounts`.`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`) );
|
| Code Block |
---|
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) );
|
| Code Block |
---|
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")
); |
|
Panel |
---|
Creating the integrationIntegration |
Once you have your database ready, do the following steps:
...