Connect to Exasol

navigation

Your Exasol database is now up and running, and you can connect to it with a database client and start to 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.

Default: aX1234567.

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, explore the other sections in this documentation:

Connect to Exasol

Learn more about the many ways you can connect to Exasol and how to integrate it with your existing tools and workflows.

Load Data

Learn how to load data into your Exasol database from different types of data sources.

Database Concepts

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

Planning Guide

Guidelines on how to plan, deploy, and operate an Exasol database as the heart of your data ecosystem.

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

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

Administration

This section describes all system administration tasks in Exasol. Learn how to use the different administration interfaces to manage access, scale your system, update software, monitor performance, and much more.