The DTS Oracle Connector fully supports all tables and views in the Oracle database and does not differentiate between the two.
DTS Naming
DTS Name |
<table_or_view_name> |
DTS Key |
<schema_name>.<table_or_view_name> |
DB Synonyms are fully supported
Metadata
The connector is also capable of extracting metadata regarding the table/view columns:
▪DATA_TYPE
▪DATA_TYPE_OWNER
▪DATA_LENGTH
▪DATA_PRECISION
▪DATA_SCALE
▪NULLABLE
▪CHAR_LENGTH
▪CONSTRAINT -> PRIMARY_KEY
▪CONSTRAINT -> FOREIGN_KEY
Standard functionality only makes use of DATA_TYPE, DATA_TYPE_OWNER and PRIMARY_KEY, but the other items are available for extension in DTS descriptor objects.