Hi <@UDQU92KBK> I am trying to connect pinot produ...
# troubleshooting
m
Hi @Mayank I am trying to connect pinot production environment to tableau desktop and I am getting failed connection error. I was able to connect with local pinot environment and when I use startree connector it asks for certificates and I am not sure how to pass it using startree or other jdbc connector. Can you share valid documentation for such use cases?
cc @Aravind Raj @Pushpendra
@Aravind Raj Can you share supporting screenshots
m
I think the certificate may have expired. @Matt Nicolae is looking into it
m
@Mayank Which certificate this could be
@Matt Nicolae or @Mayank Can you share some knowledge.
m
The connector needs to be signed using a public certificate
m
How do we do the setting, we need guidance on that as well, in document it is not mentioned how to connect with certificates https://docs.pinot.apache.org/integrations/tableau
@Mayank
m
m
@Matt Nicolae Where do I add this? Same place we are adding connectors?
This is what we are getting
m
Did you download the original connector from the tableau exchange website? The file I sent should be a drop in replacement
m
I have replaced with your file. Can I share a bridge to connect if you dont mind?
@Matt Nicolae We must be missing settings
m
Your above output is with the file I sent?
m
yes @Matt Nicolae
We must be missing correct configuration
m
Let me take this back and test locally
m
okay
And our pinot cluster is https
This is how we are setting
@Matt Nicolae In advanced we select protocol as https, let me know what are we missing
What options do we fill in advance tab. Please guide us
@Matt Nicolae Any thing we found?
k
I am looking into this Will update tomorrow
thanks 1
what is the pinot jdbc driver jar you're using can you try with this https://repo1.maven.org/maven2/org/apache/pinot/pinot-jdbc-client/1.3.0/pinot-jdbc-client-1.3.0-shaded.jar copy this to
~/Library/Tableau/Drivers
also remove any old pinot-jdbc-client jars from the directory above