Security and authentication in denodo while connecting to PowerBI

Hey team, Good morning! I was just trying to connect to denodo from PowerBI desktop application, using import option. Now that how will i ensure security of my data based on different role types of user at denodo level before or while importing data to powerBI? As of now, clients haven't provided the admin privileges for the VDP to access roles and user management under administration tab. Is there any alternate way to accomblish it using parameterization in denodo? Please advice! Thank you, Have a great day!
user
19-08-2019 05:56:30 -0400

1 Answer

Hi, To ensure the security of data based on different roles in Virtual DataPort. I would do the following steps * Create the ODBC without giving any credentials to connect to Virtual DataPort.If the credentials fields are empty, then it will request the credentials when you are accessing the ODBC DSN. * In Power BI, navigate to Get Data > others > Denodo. * Provide the DSN name and select Data connectivity mode as “Import”. * Then select the authentication mode as Basic and provide the user credential to connect to Virtual DataPort. * Based on their privileges the data can be accessed from Virtual DataPort. Please note that, while creating the ODBC you need to provide a Database name, if the user at least has privilege such as connect, metadata and execute to access to the database to connect using ODBC DSN or otherwise you may need to create different DSN for particular Database. For more information, you can refer to the User Manuals [Denodo Power BI Custom Connector - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Power%20BI%20Custom%20Connector%20-%20User%20Manual). Hope this helps!
Denodo Team
20-08-2019 05:17:04 -0400
You must sign in to add an answer. If you do not have an account, you can register here