Not able to connect to Vertica database

2»

Answers

  • LazzkaLazzka Vertica Customer

    @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

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    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?

  • fnaffnaf Community Edition User

    Hello. You can follow these steps:

    • Open DBeaver.
    • From the menu, click Database > New Database Connection.
    • In the Connect to a database window, search Vertica.
    • Click Next.
    • Enter your connection details:
    • Click Edit Driver Settings.
    • Select Libraries and then click Add File.
    • Select the Vertica JDBC file you downloaded.
    • five nights at freddy's
  • LazzkaLazzka Vertica Customer
    edited September 2022

    @Connyrt-emp1 no, I can connect via vsql

    vsql -h ... -U dbadmin -w ...
    Welcome to vsql, the Vertica Analytic Database interactive terminal.

  • moshegmosheg Vertica Employee Administrator

    DBeaver use JDBC driver while Power BI use ODBC to connect.

    Please verify all connection instructions as shown in the guide below.
    https://www.vertica.com/kb/Integration-with-Microsoft-Power-BI-Connection-Guide/Content/Partner/Integration-with-Microsoft-Power-BI-Connection-Guide.htm

  • RajasekharVuppalaRajasekharVuppala Vertica Employee Employee

    @Lazzka Can you try to ping the Vertica server IP from your company's external server and can you try vsql from your company's external server?
    Are you using Vertica Named connector?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file