Datalore 2023.4 Help

Configure database list

For security reasons, you can configure the list of database types to hide some of the options. As a result, when creating a connection, such database types will not be available.

Use the following configuration parameters under the environment: section of the docker-compose.yaml file:

  • databases.filter.include: to specify those databases you want to keep available. If empty, all default options will be preserved.

  • databases.filter.exclude: to specify those databases you want to hide. If empty, no default options will be excluded.

Find all available database types and their IDs in the list below.

Database Id

Database Name

athena

Athena

cloudspanner

Google Cloud Spanner

elasticsearch

Elasticsearch

firebird

Firebird

hana

SAP Hana

informix

Informix

intersystemsiris

InterSystems IRIS

openedge

OpenEdge

phoenix.thick

Apache Phoenix

phoenix.thin

Apache Phoenix Thin

presto

Presto

tarantool

Tarantool

teradata

Teradata

tibero

Tibero

trino

Trino

duckdb

DuckDB

mimiersql

Mimer SQL

ignite

Apache Ignite

bigquery

Google BigQuery

clickhouse

ClickHouse

db2.11

IBM Db2

db2

IBM Db2 for 9.X, 10.X

db2.jtopen

IBM Db2 (JTOpen)

derby.remote

Apache Derby (Remote)

exasol

Exasol

h2.unified

H2

hive

Apache Hive

mariadb

MariaDB

sqlserver.ms

Microsoft SQL Server

sqlserver.jtds

Microsoft SQL Server (jTds)

azure.ms

Azure SQL Database

sqlserver.localdb.jtds

Microsoft SQL Server LocalDB

synapse.ms

Azure Synapse Analytics

mysql.8

MySQL

memsql

SingleStore

tidb

TiDB

mysql_aurora

Amazon Aurora MySQL

oracle.19

Oracle

oracle

Oracle for 9.X, 10.X, 11.1

postgresql

PostgreSQL

yugabyte

YugabyteDB

cockroach

CockroachDB

greenplum

Greenplum

redshift

Amazon Redshift

snowflake

Snowflake

spark

Apache Spark

sybase.jtds

Sybase (jTds)

sybase.ase

Sybase

vertica

Vertica

Last modified: 03 July 2023