CODEWITHSUNDEEP
odbctableau-api
Rahul Patel
Rahul Patel

Reputation: 317

Tableau Server Error connecting to ODBC driver

I can able to connect/fetch data from Tableau Desktop but in tableau server it is throwing below error with datasource, Datasource is build on BI ODBC driver. Access permission are assign granted to root folder Oracle_HOME.

enter image description here

Upvotes: 0

Views: 2223

Answers (2)

Rahul Patel
Rahul Patel

Reputation: 317

By Default, tableau server pre-populates “Server Run As user” account to Network Service account (NT AUTHRITY\NetworkService). And this account does not have full permission.

enter image description here

Upvotes: 0

Karthik Venkatraman
Karthik Venkatraman

Reputation: 1657

Based on the error, it seems the the driver is not properly installed. Try downloading the Oracle driver from tableau drivers page. If its installed correctly please cross check on the configurations you have provided. If you are using the ODBC driver, have you created the DSN properly. The DSN needs to be configured properly with the server name and authorisations and once this is done you can use this DSN in tableau.

Once you have installed the driver properly

Click Connect to Data. On the Connect page, click Other Databases (ODBC). In the DSN drop-down list, select the name that you gave to your Oracle BI Server ODBC connection, and then click Connect.

Below is the link on how to connect with the BI Connector

How to Connect to Oracle BI Server with Tableau without the shortcomings of Oracle ODBC driver

Upvotes: 1

Related Questions