Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Loading file from Oracle UCM to Oracle ADW using Data Syn

Received Response
61
Views
1
Comments
Manav Purohit
Manav Purohit Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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

  • Manav Purohit
    Manav Purohit Rank 4 - Community Specialist

    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