Skip to Content

List of some Tables and Views in Data Service Repository

The metadata for the mappings created will get stored in the repository.

Data Services provides full access to the repository metadata used by the applications you create. To access this metadata either manually enters SQL SELECT statements or open the metadata reporting tool.

1. The following set of tables in the Data Services repository stores the statistics that the audit feature collects.12.PNG

2. The below set of tables (prefixed by AL_) and views (prefixed by ALVW_) will capture the information about the metadata imported into Data Services from external databases and applications (such as Oracle, PeopleSoft, and SAP ERP or R/3).


3. The below set of tables and views capture information about built-in metadata objects used by Data Services and the relationships between those objects.


4. These following tables and views contain information about the run-time statistics of Data Services jobs and data flows.


You must be Logged on to comment or reply to a post.