Data Visualization Desktop - SQL Server Connection — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data Visualization Desktop - SQL Server Connection

Received Response
22
Views
2
Comments
Vinoth Gopalsamy-Oracle
Vinoth Gopalsamy-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Data Visualization Desktop - SQL Server Connection

Content

Hi Team,

In Hyperion IR, we use an ODBC connection to access SQL Server data and the ODBC connection uses the users NT ID/ Password to access data. I do not see an ODBC connection option in Desktop DV so I went to the SQL Server option.

I see the below enhancement request in progress

Bug 25511899 - DATA SOURCES - GENERIC ODBC SUPPORT - UI

When I use the NT ID/PWD combination that I use with IR, the connection fails to save with invalid user id/password.

I do not have a native ID in sql server.

How do I get the SQL Server connection to work with my NT credentials vs having a specific db logon. Is it possible to achieve this?

Thanks

Answers