Tableau Desktop & Neon Tech
I'm trying to connect Tableau with my PostgreSQL Neon Tech. I've tried a basic connection, jdbc but I'm not getting through. Are there any documents I can refer to?
6 Replies
rival-black•2y ago
We don't have any documentation on this from what I can see. Is Tableau printing an error that you can share here?
Usual culprits for these issues are failing to enable SSL in the tool you're using.
constant-blue•2y ago
Hey, I successfully connected to Tableau using the PostgreSQL connector with the configuration shown in the image. Your connection server, database, and user details will differ, oif course. You can find those details in your connection string. Is that how you are connecting from Tableau or are you using a different method?
stormy-goldOP•2y ago
I'll try it again in a bit. Do you need to add anything/ certs when you hit require ssl?
stormy-goldOP•2y ago
I'm connecting using a read only replica.
constant-blue•2y ago
No extra certs required with sslmode=require. I wonder if Tableau writes anything to the database on connecting(?). That would not be permitted, as read replicas run on read-only computes. Another possibility might be your connection details. Where the read replica is a different compute instance, make sure you have the right hostname, database, and user for the read replica. You can get the connection details from the Connection Details widget in the Neon Console. You can try connecting with psql first to make sure your connection details are valid.
stormy-goldOP•2y ago
Thanks. I can confirm that it's working as expected.
Appreciate your support. Worked with both RO and RW