Oracle Integration Cloud (OIC) Tutorial: FTP Adapter To Move Files Between FTP / SFTP Servers

Подписаться 4,4 тыс.

Просмотров 10 тыс.

50% 1

In this tutorial, lets use FTP Adapter to move / transfer files between FTP/SFTP Servers. We will cover the following topics:
Create FTP Adapter Connection
Create Integration
FTP Adapter List Files
FTP Adapter Read Files
FTP Adapter Write Files
FTP Adapter Move Files
Test the Integration
#oic #oracle #integrations
-------------------------------------------------------------------------------------------------------------------
Let me know your suggestions and feedback!!
Listen to My Podcast:
-----------------------------------
Google Podcast: bit.ly/2RD7VIt
Spotify: spoti.fi/3wr1IhE
Connect with me
--------------------------
LinkedIn - bit.ly/3eFhI6V
Twitter - bit.ly/3dC2rCz
My Blog - quest4apps.com
Medium - bit.ly/3dFhQSX

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 38

@srikanthchandika09 2 года назад

Wonderful Arun. I really appreciate your sincere efforts to impart knowledge in this mode .. Being a health care integration veteran , I feel this tool is very confusing but you made simpler to understand. Good job and Gold bless you with great energy to make more such useful videos

@atarunraj 2 года назад

Thank you for your kind words and feedback. Sincerely appreciated.

@vidyeshranade8849 19 дней назад

Hello Arun, Excellent Tutorial!!! Very clearly explained in simple steps. No confusion. Use case is very-much used in the industry. Really enjoyed doing the same and cleared the doubts and consolidated the various concepts like parameter assignment, looping file operation actions etc. Thanks once again. Best regards, Vidyesh RANADE

@jamalfarooq78 Год назад

Great Stuff Arun, keep posting new video around all OIC functionality. please.

@defaultCharacter 3 года назад

Very helpful and timely, Arun. Super-appreciate you taking the time to provide clear and informative instructions on how to do this!!! :)

@atarunraj 3 года назад

Thanks for the feedback.

@harryraju8829 2 года назад

Hi Arun, I like your way of getting into details and explaining the purpose of each and every point clearly. Note: Request you to please show us an integration to submit a BIP report , generate csv and validate whether the report has generated the output by checking the length of the data file and based on the output need to either write the file or send an email to respective technical team.

@atarunraj 2 года назад

Great ask. Thats something i can definitely show you.

@vinodkumarkandati2115 Год назад

I just watched and enjoyed the way you had explained

@atarunraj Год назад

Thanks for the feedback. Glad you found it helpful.

@newsnetworkz 2 года назад

Well explained

@AnkitaKumari-rk5cq 2 года назад

Great explanation sir !!! Having one silly doubt while listing the file why you haven't used for each loop because we have so many files in input directory so we wanna list those so it's a repeating thing which we wanna perform So that list operation should also come inside the loop.please correct me if I am wrong

@sravanigupta3432 2 года назад

very informative, is it possible to pass file reference as a parameter to one integration from other, and upload the transferred file to ftp?

@atarunraj 2 года назад

Interesting question. Love it. I guess it’s possible. Will try it out.

@tampin7027 Год назад

Thank you for an excellent lesson. I have a basic doubt, I have to transfer a file (let's say AP Invoice file) from my local machine to OIC, to be read by an integration which will kick off the 'Import Payables' process. How do I know the server/user/password for the OIC Sever? I am thinking, I need to place the file on OIC ,so that the integration I create can read from it. I just got a free Oracle CLoud account and trying to learn myself. Any help is appreciated.

@atarunraj Год назад

You will have to upload the file to the FTP /SFTP server. Subsequently the OIC file can read the file the server for processing. Are you signed by for the Oracle Cloud account with access to Oracle Cloud Infrastructure?

@tampin7027 Год назад

Hi Arun, thank for the reply. Yes, I have 30 day free access to OIC. I tried creating a 'UCM Instance' but couldn't get server credentials. Looks like I have to setup a server for just FTP purpose. Not sure how I do it, still figuring out.

@mansoorahamed4420 2 года назад

Hi Arun in this video u are showing u have already SFTP may i know where i can find it because i am not able to do it can share that video

@ralucab1185 Год назад

thank you very much for the tutorial!! do you know how can we get a FTP URL?

@atarunraj Год назад

Hey. Are you looking for an FTP Server? Or trying to find the url to your existing FTP server?

@ohiocolumbus 2 года назад

can we transfer file more than 1GB using FTP adapter ? Can we transfer file more than 1GB from Client SFTP server to oracel Cloud UCM ? The encryption it provides while transferring files from source to destination is 'Base64 encoding or PGP encryption also ? is there a posibility to hack and get this content and decrypt it ?

@sumantkumar1194 2 года назад

hello i have 5 files one files is error i wants to move my error files in error directory how can we do it?

@ganeshwattamwar9268 3 года назад

Please upload some more videos on OIC

@atarunraj 3 года назад

Yes. That is the plan :)

@rajesha8539 3 года назад

Please upload more OIC related videos

@atarunraj 3 года назад

More planned in the coming weeks

@nagaharish214 3 года назад

What is the reason for file transfer from one ftp to another ftp?I faced this question in interview...can u answer?

@atarunraj 3 года назад

Good question. Here is one scenario. Banks generates files and stores in the bank's SFTP server. You pick up the file from bank's server and move it to your SFTP server for data load as well as archival. Similarly there are many others. Hopefully this helps.

@nagaharish214 3 года назад

Actually I told when client or end user doesnot have an access of ftps ...and according to the client requirement...but still in dielamma with your answer...

@atarunraj 3 года назад

@@nagaharish214 the example I provided is something we have used in many projects.

@nagaharish214 3 года назад

Thank you for your response

@cristopherriverarodriguez211 2 года назад

I have tried to perform the same exercise of trying to run a BI report with several parameters but I get the following error InvalidSecurity : error in processing the WS-Security security

@atarunraj 2 года назад

Are you getting error when you try with multiple parameters only ? Or do you get error no matter how many parameters are there ?

@cristopherriverarodriguez211 2 года назад

@@atarunraj The error occurs regardless of whether I have parameters or not when executing the report, I was thinking that perhaps I do not have permissions to execute webservices or perhaps I am missing some parameter since I have double parameter authentication

@cristopherriverarodriguez211 2 года назад

@atarunraj 2 года назад

@@cristopherriverarodriguez211 are you familiar with invoking this in SOAP UI? Give it a try if you know. If you don’t know I could make a video on that.