Extracting Data from Database Tables

By using database datastores, you can extract the data from tables and functions in database. When you perform data import for metadata, Tool allows you to edit the column names, data types, description, etc.

You can edit the following objects −

Table Name

Column Name

Table Description

Column Description

Column Data Type

Column Content Type

Table Attributes

Primary Key

Owner Name

Importing Metadata

To import Metadata, follow the steps given below −

Step 1 − Go to Local Object Library → go to Datastore that you want to use.

Step 2 − Right Cpck on Datastore → Open.

In the workspace, all the items that are available for import will be displayed. Select the items for which you want to import the metadata.

In the Object pbrary, go to the datastore to see the pst of imported objects.