Was this helpful?
Connection Tools
On the Connections panel on the Warehouse Details or Database Instance Details page, the Connect to Actian warehouse/Database dropdown menu lists the following tools.
To copy information from the fields on the Connections tab, see Copy Connection Strings to the Clipboard.
Tool
Description
Common Properties
Properties provided:
Host
Database
Username
JDBC/.NET Port
ODBC Port (listen address)
Authentication Type
Authentication Server
ODBC Connectivity
Provides ODBC connection information. Requires the Avalanche Client Runtime Package.
JDBC Connectivity
Provides JDBC connection information. Requires the Actian JDBC Driver. If you are using JDBC driver 4.3.7 or later, switch the toggle on to update the connection string before copying.
Actian SQL CLI
Provides SQL Command Line Interface (Terminal Monitor) connection information. Requires the Avalanche Client Runtime Package.
For more information, see Start the SQL CLI and sql Command Options and Flags.
DBeaver
Provides DBeaver connection information. Requires the Actian JDBC Driver. If you are using JDBC driver 4.3.7 or later, switch the toggle on to update the connection string before copying.
For more information, see Connect to DBeaver with JDBC.
DBVisualizer
Provides DBVisualizer connection information. Requires the Actian JDBC Driver. If you are using JDBC driver 4.3.7 or later, switch the toggle on to update the connection string before copying.
Looker
Provides Looker connection information:
Dialect
Host
Port
Database
Username
Additional Param
Requires the Actian JDBC Driver.
For more information, see Connect to Looker with JDBC.
Power BI
Provides Power BI connection information:
Connection string
Username
Requires the Avalanche Client Runtime Package.
For more information, see Connect to Power BI with ODBC.
Squirrel SQL
Provides Squirrel SQL connection information. Requires the Actian JDBC Driver. If you are using JDBC driver 4.3.7 or later, switch the toggle on to update the connection string before copying.
Tableau
Provides Tableau connection information:
Server
Port
Virtual node
Options
Database
Username
Password
Requires the Avalanche Client Runtime Package.
For more information, see Connect to Tableau with ODBC.
Last modified date: 01/04/2024