You can import relational source definitions from database tables, views, and synonyms. When you import a source definition, you import the following source metadata:
Source name
Database location
Column names
Datatypes
Key constraints
When you import a source definition from a synonym, you might need to manually define the constraints in the definition.
After importing a relational source definition, you can optionally enter business names for the table and columns. You can also manually define key relationships, which can be logical relationships created in the repository that do not exist in the database.