Oracle connection in Teiid Designer creating multiple columns for one column
Issue
- Duplicate columns from unselected schema are being imported during JDBC import
- Importing via
JDBC connection >> Source Model
an Oracle View that also has several synonyms adds a set of columns in the Source Model for every Synonym:
Oracle View contains only 4 columns:
METRIC_KEY
METRIC_NAME
METRIC_DESCR
METRIC_TYPE
But after importing the database via JDBC and viewing METRIC_DIM in the datasource explorer, there are four entries for each column in the view:
METRIC_KEY
METRIC_NAME
METRIC_DESCR
METRIC_TYPE
METRIC_KEY1
METRIC_NAME1
METRIC_DESCR1
METRIC_TYPE1
METRIC_KEY2
METRIC_NAME2
METRIC_DESCR2
METRIC_TYPE2
METRIC_KEY3
METRIC_NAME3
METRIC_DESCR3
METRIC_TYPE3
Environment
- Red Hat JBoss Data Virtualization (DV) 6.4
- Red Hat JBoss Developer Studio (JBDS) 11.3
- Teiid Designer Runtime for JBDS 11.1.3, 11.2
- Oracle Driver
ojdbc7.jar
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.