Does the repository allow automatic discovery of database objects from database sources?
Yes, for Oracle data sources, the user supplies connection information (e.g. the username, password, SQL*Net connect string), which will be used to create a database link in the database that hosts the Warehouse Builder repository. OWB uses this database link to query the source databases data dictionary (catalog) and extract metadata that describes the tables, views, etc. of interest to the user. Other sources accessed through Transparent Gateways also look like Oracle to OWB. The user experiences this as a process of visually inspecting the source and selecting objects of interest. The integrator for SAP provides the same transparent capabilities.
Yes, for Oracle data sources, the user supplies connection information (e.g. the user name, password, connection information), which will be used to create a database link in the database that hosts the Warehouse Builder repository. Warehouse Builder uses this database link to query the source databases data dictionary (catalog) and extract metadata that describes the tables, views, etc. of interest to the user. Other sources accessed through Oracle’s Transparent Gateways also look like an Oracle database to Warehouse Builder. The user experiences this as a process of visually inspecting the source and selecting objects of interest. The integrator for SAP provides the same transparent capabilities.
