Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Not able to connect to Vertica database
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
@Jim_Knicely Actually i'm trying to connect through PowerBI Desktop (not through Azure Data Factory) and getting same error as fabmel1:
[DataSource.Error] ODBC: ERROR [08001] [Vertica][Vertica DS] (160) Connection attempt failed: could not connect to server: ... Connection timed out (0x0000274C/10060) Is the server running on host and accepting TCP/IP connections on port 5433?
Btw i'm struggling with this error only on my company's external server (on my local laptop everything is working just fine)
Also when i'm connecting to same Vertica database through DBeaver (via external server), it's working okay, can see all the data with no such problem - so IP address should be reachable
Hi, the client (Power BI) where ever it is, must be able to reach the target Vertica server IP, and any firewalls in between them must allow TCP over the port 5433.
@Lazzka, on the Power BI Desktop machine, have you tried testing the connection to Vertica using vsql? Do you get the same error message?
Hello. You can follow these steps: