Oracle Integration Cloud (OIC) Tutorial: FTP Adapter To Move Files Between FTP / SFTP Servers
Vložit
- čas přidán 5. 09. 2024
- 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
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
Thank you for your kind words and feedback. Sincerely appreciated.
Great Stuff Arun, keep posting new video around all OIC functionality. please.
Very helpful and timely, Arun. Super-appreciate you taking the time to provide clear and informative instructions on how to do this!!! :)
Thanks for the feedback.
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.
Great ask. Thats something i can definitely show you.
Well explained
I just watched and enjoyed the way you had explained
Thanks for the feedback. Glad you found it helpful.
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
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
Please upload some more videos on OIC
Yes. That is the plan :)
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.
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?
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.
very informative, is it possible to pass file reference as a parameter to one integration from other, and upload the transferred file to ftp?
Interesting question. Love it. I guess it’s possible. Will try it out.
Please upload more OIC related videos
More planned in the coming weeks
thank you very much for the tutorial!! do you know how can we get a FTP URL?
Hey. Are you looking for an FTP Server? Or trying to find the url to your existing FTP server?
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 ?
hello i have 5 files one files is error i wants to move my error files in error directory how can we do it?
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
Are you getting error when you try with multiple parameters only ? Or do you get error no matter how many parameters are there ?
@@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
@@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 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.
How can I insert records by blocks.
Example 100 then 100
Is your question regarding inserting blocks of data in a database?
What is the reason for file transfer from one ftp to another ftp?I faced this question in interview...can u answer?
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.
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...
@@nagaharish214 the example I provided is something we have used in many projects.
Thank you for your response