Oracle Analytics Cloud and Server

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

Data Sync Meta data Information

Received Response
71
Views
3
Comments

Summary

Accessing OACS Data Sync Meta data for connections and projects

Content

I am looking for OACS Data Sync Meta data information.

I required this information to identify where exactly DataSync stores metadata related to Connections, Project etc

In context of connections where it stores source and target connection and for projects where it stores all meta information for data loads and its load strategy, underlying sql etc.

Version

OACS 2.6

Answers

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    All the metadata for Data Sync is stored in a file based relational database called JAVADB. 

  • User_J3T0A
    User_J3T0A Rank 3 - Community Apprentice

    Hi Vijay, 

    Thanks a lot. Could you please suggest me a way so that i can access it.

    E.g. I need to check for data loads meta information and jobs execution logs.( though logs are already available in form of files)

    Thanks

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    Both the design and runtime data is stored in a file based relational database called Java DB in datasync directory.  The Data Sync UI is the only way to access the data.  Consider setting email notifications (use 2.6.1) which will send out some stats about the run at the end of the job.