Data Visualization Desktop - SQL Server Connection

Question

Summary

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

Sujay Ramaiah-21858 · Answer

We see that the SQL Server Database connection is available in the latest version of DVD. But I am still not able to connect successfully.

Can you please let us know if you were able to connect?

Thanks,

Sujay

Adam Bloom-Oracle · Answer

Not currently possible.