Data Visualization Desktop - SQL Server Connection — Oracle Analytics

Oracle Analytics Cloud and Server

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

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