Oracle connection in Teiid Designer creating multiple columns for one column

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In