| Panel |
|---|
FTP To Database Integration
|
In this article you will learn how to transfer data from an FTP server to a database.
Preliminary setps (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")
); |
|
Creating the integration:
Once you have your database ready, do the following steps:
...