To create a connection to your system, follow these steps:

  1. Navigate to Settings inline-svg-1 > Data Ingestion > Connections.
  2. In the top-right corner, click New connection, find your system, and click Connect.

General configuration

In the general connection configuration step:

  1. Name your connection for easier identification in Dawiso. Use a unique, descriptive name, for example a combination of the server name and environment, such as server1_prod.
  2. Provide a description of the connection’s purpose.
  3. Select a Connection type.
    • Shared: The source is accessible from the public internet, and you can share your credentials with Dawiso.
    • Private: The source isn’t accessible from the public internet, and you can’t share your credentials with Dawiso. For more information, see Create a private connection.
  4. Click Next.

Server configuration

In the server configuration step, provide the following information:

  1. Server: Host name or IP address of your Vertica server, e.g., vertica.mycompany.com. Don’t include the port or a protocol prefix.
  2. Port: The port on which Vertica accepts client connections. The default port is 5433.
  3. Database: Name of your Vertica database, e.g., verticadb. To find it, run SELECT CURRENT_DATABASE(); in Vertica. Dawiso scans this database.
  4. Authentication:
    1. User: Username of the user created in Prepare for Vertica integration.
    2. Password: Password to your user.
Tip

If your connection form has no Database field, enter the database name in Optional settings instead: { "Database": "verticadb" }.

Optional and additional settings

Both Optional Settings and Additional Settings for your connection are optional:

  • Optional Settings: Specify options supported by the provider in JSON format.
  • Additional Settings: A JSON formatted list of additional settings for troubleshooting or advanced connection configuration. Leave this field empty unless Dawiso support asks you to change it.

Enter optional settings as valid JSON.

Test and save connection

If your connection is shared, click Test connection and wait a few seconds.

  • If successful, a green checkmark appears next to the button.
  • If it fails, a red error icon appears. Hover over it for a detailed error message. See the troubleshooting section for more information. You can still save the connection.
Tip

If your connection is private and you used dummy credentials, the connection test fails.

Finally, click Save and continue to the next step: creating a data source, where you specify what metadata to ingest.

Troubleshooting

When Dawiso can’t connect, the connection test and the ingestion fail with an error that starts with Cannot open connection to Vertica, followed by the reason:

Error messageSolution
The following connection settings were missing: DatabaseEnter the name of your database in Database.
Database "database_name" does not existThe database name is wrong. Run SELECT CURRENT_DATABASE(); in Vertica and enter the result in Database.
Authentication failed for usernameCheck the username and password.
Network errorDawiso can’t reach the Vertica server. Check the server name and the port, and make sure your firewall allows connections from Dawiso to the Vertica client port.
The connection works, but the ingestion imports no tablesThe user can connect but can’t see any objects in the catalog. Grant the permissions described in Prepare for Vertica integration.