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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content