Support ODBC connection using Snowflake and OBIEE 12C

Nakia Bell

Organization Name

FMR LLC

Description

We would like an enhancement for OBI 12C to support the Snowflake ODBC driver.

Use Case and Business Need

Instead of using the JDBC we will be able to directly use the ODBC when connecting to snowflake database for obi reporting.

More details

We are integrating snowflake DB with OBIEE using odbc, we are able to make a successful connection, but when running reports we are seeing the below errors.

[nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL statement. [[

[nQSError: 16001] ODBC error state: 22003 code: 40470 message: [Snowflake][Support] (40470) Conversion error at column 5 and row 1: numeric value out of range..
[nQSError: 16001] ODBC error state: 01000 code: 40460 message: [Snowflake][Support] (40460) Fractional data truncated while performing conversion..

When we pull the query from obi and directly run on snowflake db there are no errors.

Original Idea Number: 3fef4206b2

User_B8VQC

Good Idea

User_B8VQC

It is good idea but I don't think it is posted in correct place. This is for Ideas related to cloud products. 

Srinivas Pendyala-Oracle

Good idea.

Poonam Saini

Good Idea

Nakia Bell

Thank you.  An oracle support rep mentioned, all ERs are implemented usually in the new release of the product. Since development already released OAS (Oracle Analytics Server) as a new generation of BI on-prem, all new enhancements will likely be implemented for OAS. So I added here. Hopefully this is the correct place.