My Oracle Support Banner

Using a Wildcard in -REMOTE_FILE for ODIScpGet to Get Multiple Files Does Not Work (Doc ID 2815612.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


When attempting to copy multiple files with the same extension from an SSH server using OdiScpGet with a wildcard like *.csv, Oracle Data Integrator (ODI) creates a file called "*.csv", instead of pulling multiple files.

The issue can be reproduced at will with the following steps:
1. Apply the ODI Bundle Patch
2. Create an OdiScpGet Package with the -REMOTE_FILE=*.<EXTENSION>
3. Execute the Package using OdiScpGet to copy files from an SSH server with a wildcard search like *.csv and the behavior occurs


results in one file named *.csv instead of multiple <FILENAME>.csv files.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.