FTP PACKAGES

So with the help of this object package, we can execute multiple of all the objects in a sequence.

                                                                           STEP - I

Create a package
Right click the new package.

Name of package will be FTP_PACKAGE click OK

Inside this package you can add multiple objects, multiple ODI objects, and you can execute them in a sequence like you can add mappings, you can add procedures, packages, sequences etc.

Left side we have the section called Toolbox.
Inside this section I have different options like Files Related section

So like if we want to perform files related operations, we will use this section.

Internet Section

So if we want to use the FTP protocol
OdiFtpGet protocol is used to get files from another server.
So basically FPP protocol, which is file transfer protocol is used, then you have to transfer files between two different servers.  

Example:

OdiFtpGet Executive Order File Transfer Protocol.

Click OdiFtpGet, which is the file transfer of protocol GET method used to get all the files from another server and in order to put is used to place files in another server.

Let’s configure this FTP get step

Before configuring this step, we need to download and install FTP filezilla server

https://filezilla-project.org/ - Click Link



We need to download this for Windows download filezilla server, click download

Open filezill server interface in Windows.
Lets check whether FileZilla Server is Running or not.
To check that click Windows in search bar type SERVICEs.

The server is running.

Next step is to create a USER.

Open FileZilla server interface and Click Connect.

Then click EDIT,
I need to create a new user click USERS and Add New User “ODI12C”

Click OK.

We need to provide the password.

Click “Shared folder”

So this is going to be the directory FTP directly.

Provide FPP directory.

Click OK

The USER has been created

 

 

 

 

Next step is to configure the step on ODI

Remote Host – Localhost

Remote Username – ODI12c

Remote User Password – Provide password while we create username in FTP server

Remote Directory – Our FTP Directory (We given FTP Directory in Shared Folders Before, I have some csv files placed in that directory)

 

Local Directory – This is going to be my local directory, In this particular directory the data is going to be placed. GET going to read Remote Directory data and it is going to place out here in this particular directory local area.
(Create Local Directory of You Own)

(Example - D:\ODI COURCE\Documents\Transformation)

Save Package FTP file and Execute IT.

Get method going to place files inside in local directory.

 

 

 

Here we need to get files from one server to another server

After executing Remote Directory of FTP files will be transferred into Local Directory means in Transformations files

Remote Directory (Our FTP Files)

Local Directory

         

STEP – II

Before going into this step, we need to delete all the files in local directory (Transformations)

Now, In this step is to make directory.

Get “OdiMkDir 2” from File section, so this is going to create a directory

Next step is to create a directory. I create a “Backup” folder

Copy directory of “Backup” folder

Delete the backup file, this step is going to create a folder

Backup folder will be created inside this directory

Save It

Now, let me take the next step after this

I need to use the OdiFileCopy file

So OdiFileCopy step is going to create a copy of files

 

Here we need to connect each step by click OK

The first step will be executed (OdiFtpGet), then second step will be executed (OdiMkDir), then third step will be executed (OdiFileCopy).

After this step I'm going to use mapping I already created mapping.

Here I’m using Join Transformation mapping

It is reading two files and it is having a union, then it is having a join then it is going to insert data in the TRG_CUSTOMER

Next step is to use this Join Transformation mapping, Drag & Drop in FTP_Packages

Here, we need to connect this OdiFileCopy step with Join Transformation mapping step

Next is to create a step in OdiFileCopy

 

Source Directory – Our source directory will be “Transformation” folder we have to copy the directory of that folder and paste in Source Directory in OdiFileCopy properties

Example - D:\ODI COURCE\Documents\Transformation

Target Directory – Our Target directory will be “Backup” folder we have to copy the directory of that folder and paste in Target Directory in OdiFileCopy properties

Example - D:\ODI COURCE\Documents\Backup

So all files will be placed in the backup folder

Let’s see how these steps will be executed

First step OdiFtpGet is going to read files of FTP Folder and Place those files in Transformation

Second step OdiMkDir is going to create a target folder called Backup Folder

Third step OdiFileCopy is going to copy files from Transformation and placed it in Backup Folder

OK, a backup folder will be created where this step is going to do this step is going to copy files

Fourth step JOIN_Transformation mapping will separately be executed and the data will get into the target table “TRG_CUSTOMER” in database

Just check server is up and running or not

Let’s EXECUTE

All steps EXECUTED.

Server is also Up n Running

Backup Folder is Created, all files are placed in the target directory

 

Check out target table “TRG_CUSTOMER”