Connecting to data sources
Choose a data source to get started with below.
Note that Cube also supports connecting to multiple data sources out of the box.
Most of the drivers for data sources are supported either directly by the Cube team or by their vendors. The rest are community-supported and will be highlighted as such in their respective pages.
The following drivers were contributed by the Cube community. They are not part of the Cube distribution, however, they can still be used with Cube:
- CosmosDB driver (opens in a new tab)
- SAP Hana driver (opens in a new tab)
- ArangoDB driver (opens in a new tab)
- OpenDistro Elastic driver (opens in a new tab)
- Mydremio driver (opens in a new tab)
- Trino driver (opens in a new tab)
- Cratedb driver (opens in a new tab)
- Dremio ODBC driver (opens in a new tab)
- Vertica Driver (opens in a new tab)
You're more than welcome to contribute new drivers as well as new features and
existing drivers (opens in a new tab). Please
contribution guidelines (opens in a new tab)
and join the
#contributing-to-cube channel in our
Slack community (opens in a new tab).
All Cube database drivers come with presets for concurrency and pooling that work out-of-the-box. The following information is included as a reference.
For increased performance, Cube uses multiple concurrent connections to
configured data sources. The
CUBEJS_CONCURRENCY environment variable controls
concurrency settings for query queues and the refresh scheduler as well as the
maximum concurrent connections.
For databases that support connection pooling,
the maximum number of concurrent connections to the database can also be set by
CUBEJS_DB_MAX_POOL environment variable; if changing this from the
default, you must ensure that the new value is greater than the number of
concurrent connections used by Cube's query queues and refresh scheduler.