You can translate the question and the replies:

How to Integrate Tableau with Denodo hosted in AWS

Hello team, We have Denodo hosted in AWS and we are trying to integrate Tableau with Denodo and we have a reqirement that is: different Tableau users using the same service account but accessing different databases or data based on the privileges set for the user in denodo. Can you please suggest how this can be done. Thank you!
user
07-01-2022 08:17:15 -0500

3 Answers

Hi, In general, if the need is to provide specific privileges over the virtual database or at the element level for specific users, then connecting to Virtual DataPort server from Tableau through service user/account is not considered as a good practice nor a feasible option. For your use case, I will use either a Virtual DataPort (VDP) user or a [**LDAP**](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/server_configuration/server_authentication/ldap_authentication/ldap_authentication) user (if the necessary roles are imported) with the necessary privileges assigned to connect from Tableau. This way, the access to virtual database/element or even data (masking) level restriction can be imposed among different users (VDP or LDAP). You can refer to the Knowledge Base Article [**How to connect to Denodo from Tableau Desktop**](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop?category=Northbound+Connections) and below documentations for more information. [**Creating Users**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/creating_users) [**Modifying and Deleting Users**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/modifying_and_deleting_users#modifying-the-privileges-of-a-user) [**Import roles from LDAP**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/administration_of_databases_users_roles_and_their_access_rights/creating_roles#wizard-import-roles-from-ldap) Hope this helps!
Denodo Team
10-01-2022 08:24:01 -0500
Hi Hi We have done this using VDP, but actually we are trying to connect Tableau with denodo (design studio)which hashasisis been hosted in aws and in this we have a reqirement that is: different Tableau users using the same service account but accessing different databases or data based on the privileges set for the user in denodo.
user
11-01-2022 11:48:04 -0500
Hi, If I understand well, currently different users are connecting to Virtual DataPort (VDP) server from Tableau using a same service account (created in VDP). Now you are looking for a way to allow the users to directly connect VDP which offers UBAC (User Based Access Control). In this scenario, I would use the [**Integrated Authentication**](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop?category=Northbound+Connections) (Single - Sign On), instead of Username and Password to connect to the VDP Server. In order to leverage Integrated Authentication method, you will need to [**Set-Up the Kerberos Authentication in the Virtual DataPort Server.**](https://community.denodo.com/docs/html/browse/8.0/platform/installation/postinstallation_tasks/postinstallation_tasks_in_virtual_dataport/setting-up_kerberos_authentication) To know more, you can refer to the Knowledge Base articles: * [**Kerberizing Denodo for SSO**](https://community.denodo.com/kb/en/view/document/Kerberizing%20Denodo%20for%20SSO%20-%20Step%20by%20step%20guide%20-%20Introduction%20%28I%29) - Step by step guide * [**How to set up SSO with pass-through for ODBC connections to Denodo**](https://community.denodo.com/kb/en/view/document/How%20to%20set%20up%20SSO%20with%20pass-through%20for%20ODBC%20connections%20to%20Denodo). * [**How to connect to Denodo from Tableau Desktop**](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop?category=Northbound+Connections#h.tuvyxb93hl3h) Hope this helps!
Denodo Team
13-01-2022 08:15:19 -0500
You must sign in to add an answer. If you do not have an account, you can register here