Connect to Exasol

navigation

You can now connect to your new Exasol database and start to load data using SQL clients and other tools. To learn more about the many ways you can connect to Exasol and integrate it with your existing tools and workflows, see Connect to Exasol and Load data.

Create a connection

To create a connection to the Exasol cluster, use the following details:

Hostname

Comma-separated list of the public IP addresses of all data nodes.

For example: 203.0.113.11,203.0.113.12,203.0.113.13

The public IP addresses are shown in the EXTERNAL_IP column in c4 ps.

Port

Value of the CCC_PLAY_DB_PORT parameter in the configuration that was used to create the deployment.

Default: 8563.
Username sys
Password

Value of the CCC_PLAY_DB_PASSWORD parameter in the configuration that was used to create the deployment.

If the connection uses a TLS certificate and a valid certification path is not found, you may have to provide the certificate fingerprint. For more information, refer to the documentation for the database client.

Next steps

To know more about how to get the best out of Exasol, we suggest that you explore the following sections:

Concepts

Learn about basic concepts and features in Exasol, such as how to use UDFs (user defined functions) to run your own analysis, processing, and generation functions in your Exasol cluster.

Performance Guide

A collection of best practices to help you attain sustainable good performance from your Exasol system.

Advanced analytics

Learn how you can do advanced analytics and work with data science and machine learning in Exasol.

SQL reference

Learn about the syntax and semantics of all SQL statements, data types, functions, and other SQL language elements that are supported in Exasol.