You can translate the question and the replies:

Connect to SQL Server Stored Procedures in Denodo

Need help on connecting to SQL Server Stored Procedures in Denodo and then access it in PowerBI Desktop.
03-10-2022 03:49:35 -0400

1 Answer

Hello, I understand that you want to create a base view in Denodo from SQL Server Stored Procedures and later access these base views via PowerBI Desktop. It can be accomplished by implementing the following steps: 1. In Denodo, create a JDBC data source for MS SQL Server database by going to File > New > Data Source > JDBC. 1. Create the required base view from the available databases, functions, stored procedures in SQL Server data source. You can refer to the document [Creating Views On SQL Server Functions & Stored Procedure]( 1. Install the Denodo ODBC driver by going to `<DENODOHOME>\tools\client-drivers\odbc\denodo-vdp-odbcdriver-windows\denodo-vdp-odbcdriver-windows\msi` and unzip & execute the appropriate version of driver installer. 1. In PowerBI, go to Get Data > Denodo and provide the details to establish the connection. You can refer to the document [Denodo PowerBI Custom Connector]( for more information to establish this connection. 1. Navigate to the required base view of the Stored Procedure. Hope this helps!
Denodo Team
03-10-2022 17:59:35 -0400
You must sign in to add an answer. If you do not have an account, you can register here