After your Actian warehouse or database is created and running (see Create a Warehouse and Restart a Warehouse or Create a Database Instance and Restart a Database), you may connect to it from external applications. These applications could deal with loading data, performing ad-hoc querying, using BI tools for reporting, loading data into a Spark warehouse or into a Data Science workbench. You may use any tool or application that is ODBC- JDBC-, or .NET-compliant.

You can access connection information for various third-party tools through the Connection tab on the Warehouse Details or Database Instance Details page. The dropdown menu on the Connections tab displays the various warehouse/database connection strings for JDBC, ODBC, as well as the tools listed in Connection Tools.

Connection strings will work only from machines with an Allow List IP address. For more information, see Update Allow List IP Addresses.