📌 Data Connectivity | Resources
- Supported Connectors (Tableau Help)
- How to connect to different data sources in Tableau (courtesy of Tim Ngwena)
- Connect to your data (Tableau Help)
Dwayne Kenneth Contreras (Member) asked a question.
I've shared our Tableau work to our employees but they have the OAuth error for Google Drive. I've also shared the actual google sheet contain the data but to no avail. Any help?
asaki moriya (Member) asked a question.
I cannot connect Tableau Desktop to the MySQL Server.Even after installing the MySQL connector and entering the server information to sign in,a pop-up message saying "Data source title is not entered. Do you want to reconnect?" appears, and pressing "Yes" still does not allow me to connect.
It has been confirmed that connection to the server itself is possible.
I don't know what the cause of the error is. Can someone please tell me?
Lance Pate (Member) asked a question.
We are currently running Tableau Server 2024.2 and we recently added Data Labels to our system. I'm trying to add the label data to reports using the TS Content data source our Solution Engineer provided to use about a year ago. However, I'm not sure how to join the label data in the label_values table to the data pulled from the datasources table.
Patricia Hoffmann (Member) asked a question.
Hello Tableau community,
I'm doing research on the SAP HANA connector for tableau.
I read that in order to connect to SAP HANA, you need a driver, then you're able to log in with your credentials, then you can connect to a port and choose if you want to connect to a single or to multiple nodes.
When I did some research, I couldn't find out if live connections to SAP HANA via the tableau connector are possible, or if you have to use extracts.
Does anyone here work with SAP HANA and can tell me about the data and connectivity and how the data is structured in SAP HANA?
Also when using SAP HANA, do you need additional licenses?
Kind Regards
Patricia
Felix Riedl (Member) asked a question.
This is less of a question and more of a knowledge share to help others that might be struggling with a similar setup.
Our data source is a SAP BW4/HANA, from which we are using Calculation Views, using Tableau Server to display workbooks. The issue was that metadata loading would take a really long time (sometimes 10+ seconds), even on views where the queries themselves were optimized.
The following steps helped us get the metadata load times to sub-second level:
<customization name='CAP_ODBC_METADATA_SUPPRESS_EXECUTED_QUERY' value='yes' />
<customization name='CAP_ODBC_METADATA_SUPPRESS_PREPARED_QUERY' value='yes' />
<customization name='CAP_ODBC_METADATA_SUPPRESS_SELECT_STAR' value='yes' />
<customization name='CAP_ODBC_METADATA_SUPPRESS_SQLCOLUMNS_API' value='no' />
<customization name='CAP_ODBC_METADATA_SUPPRESS_SQLSTATISTICS_API' value='yes' />
tsm configuration set -k enable_metadatacache --force-keys -v shared
tsm pending-changes apply
Source: Best practices for Tableau on SAP HANA
To give a sense of perspective, a workbook that previously had a metadata load time of 20 seconds now only needs 0.7 seconds to load the metadata.I have attached our TDC settings to the post, so you have a starting point for your own optimizations.
EDIT: V10 that is linked in this post suppresses the labels for HANA Columns, so the V11 from the pinned answer should be a better place to start.
Andrew Hyles (Member) asked a question.
Hello,
My company has a Tableau Cloud site, which connects to an Azure MS SQL server. I am using a service account for this (not SSO). The Azure server has an address used internally, and then a .public address used when connecting from Tableau Cloud.
I am able to connect to the Azure SQL server from the cloud normally, There are multiple data sources regularly refreshing extracts. However, when I try to add an Initial SQL, it asks me to sign in, and then states "The username or password is not valid. Check the database name and credentials and try again." The error message goes on to call out the service account username, which is correct. I don't see a way to confirm what password it is sending, but it should be the same as when signing in without the initial SQL.
For testing purposes, I have been attempting to sign in with the Initial SQL blank, or with a simple select statement.
When connecting to the Azure DB using the Tableau desktop client, I am able to do an initial SQL without any issue. This is using the same credentials, though it is the internal, not the ,public Azure server address. I don't think that this should be an issue though unless the connecting IP for an initial SQL connection is different than a normal connection (and therefore not one the Azure server's allow list).
What is different about the Tableau Cloud initial SQL sign in that might be causing the credentials, which work in all other contexts, to be rejected? Any insight on his would be greatly appreciated.
Thanks,
Andrew
Please check out our post with some tips on asking a question and how to help you get answers more quickly.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.