Srinivasan Software Solutions Blog FTP PACKAGES

So with the help of this object package, we can execute multiple of all the objects in a sequence.                                                                            STEP - ICreate a packageRight 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 sectionSo like if we want to perform files related operations, we will use this section. Internet SectionSo if we want to use the FTP protocolOdiFtpGet 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 LinkWe 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 OdiFileCopyfile 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_Transformationmapping 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”