OBIEE 11G Building the Physical Layer of a Repository 2: Import Metadata

1 . Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected.
Screenshot for Step
 
2 . Enter a data source name. In this example the data source name is orcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.
Screenshot for Step

3 . Enter a user name and password for the data source. In this example the username and password are both BISAMPLE. Recall that BISAMPLE is the name of the user/schema you created in the prerequisite section.
Screenshot for Step
4 . Click Next.
5 . Accept the default metadata types and click Next.
Screenshot for Step
6 . In the Data source view, expand the BISAMPLE schema.
7 . Use Ctrl+Click to select the following tables:
SAMP_ADDRESSES_D
SAMP_CUSTOMERS_D
SAMP_PRODUCTS_D
SAMP_REVENUE_F
SAMP_TIME_DAY_D

Screenshot for Step
8 . Click the Import Selected button to add the tables to the Repository View.
Screenshot for Step
9 . The Connection Pool dialog box appears. Accept the defaults and click OK.
Screenshot for Step
10 . The Importing message appears.
Screenshot for Step
11 . When import is complete, expand BISAMPLE in the Repository View and verify that the five tables are visible.
Screenshot for Step
12 . Click Finish to open the repository.
Screenshot for Step
13 . Expand orcl > BISAMPLE and confirm that the five tables are imported into the Physical layer of the repository.
Screenshot for Step

No comments:

Post a Comment

Popular Posts