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.
SQL
user
03-10-2022 03:49:35 -0400
code

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](https://community.denodo.com/kb/en/view/document/Creating%20views%20on%20SQL%20Server%20Functions%20and%20Stored%20Procedures). 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](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Power%20BI%20Custom%20Connector%20-%20User%20Manual#h.nyusex7kczg3) 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
code
You must sign in to add an answer. If you do not have an account, you can register here