My Oracle Support Banner

OBIEE 12c: Columns are not imported From SAP IQ when table/view name contains an underscore (Doc ID 2353476.1)

Last updated on MARCH 11, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


You have created a connection pool to SAP Sybase IQ16 by using an correct ODBC driver.

You can import columns normally when you don't have underscore in tables/views name.

but if the tables/views contain an underscore character "_" in the name, the result is that the table has no columns.

If you create a column manually you can view data normally.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.