Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Loading file from Oracle UCM to Oracle ADW using Data Syn

Summary
How to provide Oracle Data Sync location of a file in Oracle UCM
Content
I am trying to pick a file from Oracle UCM and load it into Oracle ADW using Oracle Data Sync.
I have been successful in establishing connection from Oracle Datasync with Oracle UCM.
However when I try to set up a connection and enter file name, I get the following error. I am looking for documentation on how to indicate to DataSync where to look for a file.
Error while retrieving columns.
MESSAGE:::No documents that match the search pattern were found! Verify if atleast one file is available with that pattern.
EXCEPTION CLASS::: com.oracle.datasource.pluggablesource.exception.PluggableReaderException
Thank you,
Manav
Version
Oracle Datasynce 2.6
Answers
-
We were able to figure it out. The tool uses the value entered in "Title" field in UCM and not the file name itself.
Regards
Manv
0