Data Explorer + Tableau Integration
The discussion revolves around connecting Tableau to a Discourse Data Source (PostgreSQL) to retrieve data from Data Explorer queries. Konrad_Sopala seeks guidance on how to establish this connection.
IAmGav provides a helpful article on integrating Discourse with Power BI, which shares similarities with Tableau. However, Konrad_Sopala inquires about configuring the connection manually to access the PostgreSQL database directly.
IAmGav explains that the PostgreSQL DB is inside the Discourse container and shares an article on connecting to PostgreSQL in a Docker container from outside. Konrad_Sopala attempts to follow the instructions but encounters difficulties connecting to PostgreSQL through Docker in Tableau.
IAmGav offers further guidance on the connection details, suggesting the use of the Discourse IP address, username ‘root,’ and password ‘root password.’ However, Konrad_Sopala questions the use of the Discord IP address.
neounix proposes an alternative solution, recommending running Tableau in a Docker container to take advantage of core Docker networking capabilities. This approach is expected to simplify the integration process.
Hey there Community!
Pretty much as in the title. We want to get some data from our Data Explorer queries to Tableau report. Is there any guide / community thread that will guide us how to connect Tableau to our Discourse Data Source (which is PostgreSQL I guess).
Thanks a lot for the help!
The following article should give you some guidelines as Power BI & Tableau is almost the same 
Thanks! Is there a way to simply configure it manually so I can connect the PostgreSQL database that Data Explorer is running upon directly?
the PostgreSQL DB is inside the discourse container.
I found this article. I hope this helps
We’ll try that and eventually circle back to you!
The problem is that there is no way to connect to PostgreSQL through docker when it comes to data sources in Tableau
Can you provide me @IAmGav with further guidance on that?
Address would be discord IP
Username: root
Password: would be root password
Db name: note sure would need to go check it
Disclaimer: I have not done this myself yet
Address would be Discord IP?
Dear @Konrad_Sopala
The easiest way to accomplish what you want is to run Tableau in a Docker container.
That way, you can take advantage of the core Docker networking capablities between containers.
However, if you run Tableau outside Docker, you are going to have “a bear of a time” trying to get this to work smoothly.
Hope this helps.
Reference:
https://databoss.starschema.net/tableau-server-linux-docker-container/
See also:
https://github.com/tfoldi/tableau-server-docker
Note: This docker image might help things along (not tested or checked out):
