Data Sync Meta data Information

Question

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

User743400-Oracle · Answer

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.

User_J3T0A · Answer

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 · Answer

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