Connection to H2

image_pdfimage_print

Connection to a H2 database.

Main settings:

Mode

H2 can be run in two modes:

  • Embedded: H2 running as a local file-based database engine. As connection parameters, only Database is required. It has to be set to the path of the database folder.
  • Server: H2 running in Client-Server Mode.

Host

The host name (DNS name) or the IP address of the server on which the database is located.

Port

The TCP/IP port number used by the database.

Username

User name for the connection to the database.

Password

Password for the connection to the database.

Database

Name, schema, or instance of the relational database.

Additional JDBC parameters can be set in advanced settings.

Note: this connection type is used internally in Jedox Integrator (ETL) for temporary results.

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...