📌 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)
Michael Bruhn (Member) asked a question.
I am trying to connect to a SAP HANA system using Tableau Desktop - but I get the following message after entering the properties of the connection.
An error occurred while communicating with the SAP HANA data source 'Untitled Data Source'
Bad Connection: Tableau could not connect to the data source.
Error Code: DACBE23F
The JDBC driver host process failed to respond.
Unable to connect to the SAP HANA server "....". Check that the server is running and that you have access privileges to the requested database.
I can connect from tableau prep(and other db tools) without any hassel. Now I tried to download and replace the driver for SAP HANA and then restarting the Tableau Desktop but still it doesn't work(it still works from Tableau Prep).
I tried to setup a generic JDBC connection as a workaround to the same server - that responds with the following message:
The JDBC driver host process failed to respond.
Generic JDBC connection error
The JDBC driver host process failed to respond.
Any help, pointers are greatly appreciated;-)
/MiB
Best Answer
Even though the Mac app has been ported from Intel to Silicon, not all the data connectors have. You may have to use the Intel-version for Mac.
https://help.tableau.com/current/pro/desktop/en-us/examples_saphana.htm
We are using Postgres. The special characters are encoded in the tables. How do I decode those encoded characters when I displaying them in Tableau?
Here's are some of the encoding that I have encountered:
TIA
Oliver Roth (Member) asked a question.
I have a csv without headers and with an odd structure in my google drive account. I am trying to get the data into tableau but it is automatically promoting the first row of data to headers despite them not being headers. It also seems to be using spaces as the column delimiter when I need it to use commas. I cant seem to find anywhere to change the data processing settings to set the connection to use commas as the delimiter and to not promote the first row to headers. Any ideas if this is possible, and if so, how?
Jiaoyu Xie (Member) asked a question.
Specifically, I want the Stacked Bar Chart to update based on user interaction with the Hex Map. When a user hovers over a state on the Hex Map, the Stacked Bar Chart should display only the top three candies for that selected state.
Best Answer
Same process as shown already. But this time use the bar chart to create a new separate filter action process.
Best, Don Wise -
Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.
Sonia Mendoza (Member) asked a question.
Hi community,
I am building a health indicators dashboard with many different indicators in one sheet. There are multiple. Example is this: one sheet is health access and then multiple indicators in that one sheet. Next is neighborhood (second sheet), housing (3rd sheet), transportation (4th sheet), etc. It is a rather large dataset.
My question is this: Do I separate my data into different sheets in Excel, or do I separate each sheet into different Excel files and then connect them? I am having difficulty with how to connect. It is a large dataset, and within one sheet, there are various themes for the health indicators.
Thanks for all the help!
The extract is about 4G and we have extracts that are bigger (at least double in size and number of fields) than this with the same set up. The error is below, any suggestions on approaching this?
com.tableausoftware.server.status.reporting.TableauRuntimeException: [Redshift][ODBC Driver]An I/O error occurred while reading streaming cursor.
Brandy Sawyer (Member) asked a question.
I have one user who intermittandly is being asked to reconnect to the data source in Tableau Desktop 2022.1.3. When they click yes, the same screen pops up again asking if they want to reconnect to the data source. They could press yes over and over for 10 minutes without it ever resolving.
If they click no they get the following message.
They can then save the desktop workbook, close and reopen it and connect with no issue.
Has anyone had experience with this? The data source is an extract, and others can use it with no issue. The user is on a VM that has the same image as all other Desktop users.
Daniel Flores (Member) asked a question.
Hi Team,
I'm having an issue trying to enable Tableau Bridge and Tableau Desktop with Tableau Cloud from an instance on Google Cloud Platform (GCP) that is in a private environment for security reasons. As this environment only allows outbound connections to certain IPs and domains, we have configured firewall rules as per the official documentation available at the following link: https://help.tableau.com/current/pro/desktop/en-gb/publish_tableau_online_ip_authorization.htm .
Specifically, we have allowed connections to the hostname 10ay.online.tableau.com and the IPs 34.218.129.202 and 52.40.235.24.
Despite these configurations, we are experiencing the following errors:
Tableau Bridge:
"There was a problem and the client was unable to communicate with Tableau Cloud. If this problem persists, please check your internet connection or go to the Tableau Trust page to check the status of Tableau Cloud."
Tableau Desktop:
"Unable to connect to Tableau Server. Please check the server name and port and try again. Error code: 9F4C5638 Internet Communication Error: SSL Connection Error (online.tableau.com)."
My question is: In addition to the outbound rules we already configured, are there any other settings we need to make on the private instance to ensure Tableau Bridge and Desktop can successfully connect to Tableau Cloud?
I would greatly appreciate your support and guidance on this matter.
I look forward to your reply.
Thank you very much and best regards.
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.