H2 Connection

Connection to a H2 database.

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	Optional: Database-specific parameters which are added to the generated JDBC URL.

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

Updated June 5, 2023