Message-ID: <1467396788.86175.1711714411309.JavaMail.wiki@ip-172-26-1-188> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_86174_2063325250.1711714411307" ------=_Part_86174_2063325250.1711714411307 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
In this article, you will learn how to transfer data from a file, residi= ng in an FTP server, to a table in a database. First, you will see a data m= ap. Then, you will learn the preliminary steps necessary to prepare a datab= ase. Finally, you will see how to create your integration.
In this case, we are matching data, from a file, to the data in a databa= se. There is no specific requirement on names. All that is necessary is tha= t the columns, belonging to a table in the database, must be mapped by the = user to the columns defined in the file. For example, the below table match= es the columns of a table named Account (see below Preliminary Steps) with = the fields in the file.
The following is an example of a file that can be transferred to a datab= ase:
After the transfer, you should have the foll= owing data in your database:
=
Database Script : MYSQL <= /td> | Database Script : SQLSERVER<= /p> |
Database Script : Oracle = |
=20
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`) );=20 |
=20
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) );=20 |
=20
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") );=20 |
Once you have your database ready, perform the following steps: