FTP adapter allows you to process files from remote FTP server however Stage File action is used to process file on stage location of OIC server. Yes, you can use FTP adapter alone.
You're very welcome! Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step. 1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples: www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples: www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042 3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end. www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC 4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications. www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15 5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself. www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
Could you please explain. Willing to learn more in OIC? Buy the Udemy course which will help you to learn Integration and VBCS in more detail. www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4 Apply coupon code "TECHSUPPER" and get flat 30 % discount. Code is valid for next 5 days only. Grab the deal now. Regards, Ankur
Sir why scheduled integration?Can we do it by using app driven orchestration? Is there any upper limit on the number of files to be transferred from source to target?
Hi, This is Maulik I am new to OIC and I want to Rename multiple files at a time from the Same SFTP Folder and target folder is also Same. Ex: File1.txt and File2.txt are in Folder /TEST/ABC. I want to rename both the files from FIle1.txt to File1.OUT and File2.txt to File2.OUT respectively and keep in the Same /TEST/ABC folder at the same time. Please help me out with that.
* List all the files from folder * Loop over the file * Read file one by one without schema * Write the file on the same folder. In the write mapper, do the filename -> filename mapping (but use substing function to take it from .txt and append .out) * And delete the source file.
Very well explained. crystal clear. Thanks Ankur.
You're most welcome
What is the difference between FTP adapter and stage file?Is it that FTP adapter can be used to read/write files from SFTP server alone?
FTP adapter allows you to process files from remote FTP server however Stage File action is used to process file on stage location of OIC server. Yes, you can use FTP adapter alone.
why did you use two different ftp adpaters for read files and target file.... can i use single ftp to perform this action?
you can use same as well but why a integration to be built to read and write on a single host.
@@TechSupper got it...thank you ...do a more videos on integrations ..
Thank you so much!
This lesson was really helpful ! :D
You're very welcome!
Just for your information, I have below Udemy courses that will help you to learn Oracle Cloud step by step.
1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with lot of real-time examples:
www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
2) Process Cloud Service: This course is dedicated to the Process Cloud Service and will help everyone to learn PCS end to end with several good real-time examples:
www.udemy.com/course/oic-oracle-process-cloud-service/?referralCode=21C3195B0C0E37817042
3) Oracle API PCS Cloud: The course is designed to teach you Oracle API PCS with a lot of examples. All concepts are covered in very depth end to end.
www.udemy.com/course/oracle-api-pcs-platform-end-to-end/?referralCode=F55B56F964C25334E2EC
4) Oracle Visual Builder Cloud Service: With the help of this course, you will be able to build web and mobile applications that will help you and organization to extend SaaS applications.
www.udemy.com/course/oracle-visual-builder-cloud-service-vbcs/?referralCode=BA1BCA38C23181358B15
5) 1Z0-1042-20: Oracle Cloud Platform Application Dumps: The course will help you to crack your OIC certification. Answers have been verified via different documentations and documentation links have been provided to verify the answer yourself.
www.udemy.com/course/1z0-1042-20-oracle-cloud-platform-application-dumps/?referralCode=8EA851F35C2474C29C27
any difference in background mechanism of copy and move? something like resource utilization, storage consumption?
Could you please explain.
Willing to learn more in OIC? Buy the Udemy course which will help you to learn Integration and VBCS in more detail.
www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
Apply coupon code "TECHSUPPER" and get flat 30 % discount. Code is valid for next 5 days only. Grab the deal now.
Regards,
Ankur
Sir why scheduled integration?Can we do it by using app driven orchestration?
Is there any upper limit on the number of files to be transferred from source to target?
The app driven should be trigger by someone. there is no upper limit to transfer files.
Hi,
This is Maulik
I am new to OIC and I want to Rename multiple files at a time from the Same SFTP Folder and target folder is also Same.
Ex: File1.txt and File2.txt are in Folder /TEST/ABC.
I want to rename both the files from FIle1.txt to File1.OUT and File2.txt to File2.OUT respectively and keep in the Same /TEST/ABC folder at the same time.
Please help me out with that.
* List all the files from folder
* Loop over the file
* Read file one by one without schema
* Write the file on the same folder. In the write mapper, do the filename -> filename mapping (but use substing function to take it from .txt and append .out)
* And delete the source file.