Skip to Main Content

Data Lake & Services

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Only Execute an ODI Load Plan if a Specific File is Found on an FTP Location?

User_62Y9BSep 11 2023 — edited Sep 12 2023

I have an ODI Load Plan that I only want to execute the remaining steps past the very first step if a specific .TXT file is found in a specific FTP location.

Basically, there's a Unix shell script that runs as one of the first steps in the Load Plan. That Unix shell script determines if there are new .ZIP files present in a URL, downloads those new .ZIP files, and create an empty .TXT file in a specific FTP directory to sit there and serve as an indicator that we need to continue going forward executing the remaining steps within the Load Plan to actually load data from the various .CSV files present in the numerous .ZIP files that were just downloaded.

I'd like to determine if this empty .TXT file is present, and if it is, continue moving forward with execution of the remaining 9-9 Loan Plan steps to actually do the data load. If the empty .TXT file is NOT present, then I want to conditionally determine to NOT continue forward with the execution of the additional 8-9 steps since new .ZIP files were not found/downloaded from the URL.

I'm trying to figure out what components to use to accomplish this desired conditional logic. I'm reading some info. on ODIFTP and ODIFTPGet but I haven't found anything concrete on this.

Many thanks for any pointing in the right direction on this.

Comments

Post Details

Added on Sep 11 2023
0 comments
276 views