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
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
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.
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.
Hi sir I have one doubt. I could see you have selected the 'file transfer style' for creating the integration. But in canvas page, its showing schedule orchestration. Both are same sir? Then in gen 3, there is option for 'file transfer style' sir?
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 ?
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
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 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.
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...
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.
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
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.
I just watched and enjoyed the way you had explained
Thanks for the feedback. Glad you found it helpful.
Well explained
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.
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
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.
Hi sir I have one doubt. I could see you have selected the 'file transfer style' for creating the integration. But in canvas page, its showing schedule orchestration. Both are same sir? Then in gen 3, there is option for 'file transfer style' sir?
I will start making videos for Gen 3.
hello i have 5 files one files is error i wants to move my error files in error directory how can we do it?
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 ?
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 :)
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.
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?
How can I insert records by blocks.
Example 100 then 100
Is your question regarding inserting blocks of data in a database?
Please upload more OIC related videos
More planned in the coming weeks
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