Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Support ODBC connection using Snowflake and OBIEE 12C
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