Read Large Files using FTP Adapter in Oracle Integration Cloud
ฝัง
- เผยแพร่เมื่อ 8 ต.ค. 2024
- Read Large Files using FTP Adapter in Oracle Integration Cloud
In this video, you will learn how to read large files from SFTP using an FTP adapter in Oracle Integration Cloud and process records into chunks.
• Read Large Files using...
Please like, comment, and share the video.
Please don't forget to subscribe to my channel
#oraclecloud #oracle #integration #oic #cloud #paas #soaCommunity @soacommunity #PaaSCommunity @oracleace #techsupper #ankur
Join this channel to get access to perks:
/ @techsupper
Follow me on Twitter, Facebook, and LinkedIn
/ ankur_jain2
/ techsupper
/ ankurjain26
My Playlists:
Oracle Integration Cloud: • Oracle Integration Cloud
Oracle Visual Builder:
• Oracle Visual Builder
OCI getting started:
• Oracle Cloud Infrastru...
APEX:
• Oracle APEX
![[#SHORTS CLIP] ใช้ของของตัวเองไปเลยสิคะ l ซานิเบาได้เบา l One Playground](http://i.ytimg.com/vi/Ea_mTywx2p4/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 82 วันนี้!! คู่เอก | ยอดไอคิว vs อับดัลลาห์](http://i.ytimg.com/vi/hSsyTl_9bqs/mqdefault.jpg)
![[Watch Party] RoV Pro League 2024 Winter | ( Bacon Time Vs FS )](http://i.ytimg.com/vi/lD6z1BugdZw/mqdefault.jpg)
This guy is amazing, has complete and precise content, and his English is audible! Good job!
Thank you so much, please subscribe to my channel if still not subscribed.
@@TechSupper I already did it.
Thanks for the sharing your knowledge with us...
Thank you so much.
Please subscribe to my channel if you have not subscribed yet.
Thanks for this video. it's clear many doubts.
But i have some questions... 1) If we have more than 1GB how can we process?
2)It's create multiple files for every 200 records rite, how can i club all those into one file?
Thanks in advance.
1) You can't process. If you to split files into smaller file.
2) You can use append file option while writing the file on FTP location.
Is there no way to process files more than 1 GB? We have a requirement to process files that could be around 5-6 GB and the source system cannot split them into smaller files (
The only solution is to split the source file. No other solution so far.
Thanks for the video. whether we can change segment size?
Yes we can. Export the IAR file, open the assoicated jca file and change the segment size.
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
@@TechSupper While configuring Stage action can we not change the segment size from 200 to any other value?
HI! Amazing video! I got here searching for how to run a report (payload response is more than 10mb) and put the csv file in a SFTP. Do you know how can i do that? THANK YOU!
Hi Matias,
See below blog how to call BI report.
www.techsupper.com/2019/09/call-business-intelligence-api-in-oracle-integration-cloud.html
For your information, I have below Udemy courses that will help you to learn Oracle Integration Cloud.
1) Oracle Integration Cloud in Depth: The online course will help you to enhance your skillset with Oracle Integration Cloud with a lot of real-time examples. You can apply the FREEDOM74 coupon code to get up to a 28% discount.
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
can we run java program in OIC interface using connection or any other way?
No, we can't
I got around 1000 files in stage folder but I am not sure how to load them in to ADW DB. Please let me know if there are any steps to move data from stage files into ADW DB in OIC
Do you want to store file or file data.
Thanks for uploading the video. Can you please share steps to setup winscp for private ip using vpn?
You don't require to take extra step for winscp configuration. You just need a VPN connected on your system and then you can connect your private ip with winscp.
can a stage file read multiple files? if yes, how to determine which file to be used for the schema?
You have to list file operation, you can read only one type of file as you need to provide static schema.
Please subscribe to my channel th-cam.com/users/Techsupper if not subscribed it earlier to get regular updates.
Can we process the 2GB data size file in OICS? Is yes please help me know how to load.
Thanks
No, you can't process 2 GB file at a time. You can process up to 1 GB file in Oracle Integration.
Please subscribe to my TH-cam channel th-cam.com/users/Techsupper if you have not subscribed yet.
Hi Ankur, how to handle if third party system sends around 1k invoices and each invoice having PDF attachment around 5 to 10mb reaches a upper limit of 1gb file size in OIC. what is the best possible way to handle this requirement
How are you getting those 1k invoice and how will you fetch PDF against those invoices ?
@@TechSupper we will get the zip file for invoice and attachments. Each attachment file name will have a corresponding invoice number
ok, so will attachemnt exceeds 1GB per invoice ?
@@TechSupper 1GB for all invoices say 200 invoices, each invoice pdf attachment around 5 mb.200*5 = 1000MB
So OIC will be able to handle file upto 1GB
What happens if mapping fails in one of the chunk?
It's upto you how you want to handle this. You can put scope inside the chunk block and handle in case one chunk failed.
File in my case it json and its size is 1 gb, how can fix this
Same apporach need to apply.
@@TechSupper json is not listed in file type in read in segment
Yes I just saw that. Can you raise a ticket with Oracle and check the solution.
send me that csv file for me