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.

Go to Datastore

Step 2 − Right Click 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.

Import the Metadata

In the Object library, go to the datastore to see the list of imported objects.