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 dataloreEnv: section of the values.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 |