Loading file from Oracle UCM to Oracle ADW using Data Syn

Manav Purohit

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

Manav Purohit

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