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.

User Name:

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...