Requirements
This page describes the required tools and their versions to use ScalarDB correctly.
Client SDK
Because ScalarDB is written in Java, the easiest way to interact with ScalarDB is to use the Java client SDKs:
Java
The following Java Development Kits (JDKs) are verified and supported.
- Oracle JDK: 8, 11, 17 or 21 (LTS versions)
- OpenJDK (Eclipse Temurin, Amazon Corretto, or Microsoft Build of OpenJDK): 8, 11, 17, or 21 (LTS versions)
.NET
ScalarDB is provided as a gRPC server called ScalarDB Cluster, which also has a .NET client SDK that wraps the .NET client generated from the proto file.
The following .NET versions are verified and supported:
Other languages
ScalarDB Cluster uses gRPC version 1.65.0, so you can create your own client by using the generated clients of your preferred languages.
Databases
ScalarDB is middleware that runs on top of the following databases and their versions.
Relational databases
- Oracle Database
- IBM Db2
- MySQL
- PostgreSQL
- Amazon Aurora MySQL
- Amazon Aurora PostgreSQL
- MariaDB
- SQL Server
- SQLite
- YugabyteDB
Version | Oracle Database 23ai | Oracle Database 21c | Oracle Database 19c |
---|---|---|---|
ScalarDB 3.16 | ✅ | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ | ✅ |
Version | Db2 12.1 | Db2 11.5 |
---|---|---|
ScalarDB 3.16 | ✅ | ✅ |
ScalarDB 3.15 | ❌ | ❌ |
ScalarDB 3.14 | ❌ | ❌ |
ScalarDB 3.13 | ❌ | ❌ |
ScalarDB 3.12 | ❌ | ❌ |
ScalarDB 3.11 | ❌ | ❌ |
ScalarDB 3.10 | ❌ | ❌ |
ScalarDB 3.9 | ❌ | ❌ |
ScalarDB 3.8 | ❌ | ❌ |
ScalarDB 3.7 | ❌ | ❌ |
Only Linux, UNIX, and Windows versions of Db2 are supported. The z/OS version is not currently supported.
Version | MySQL 8.4 | MySQL 8.0 |
---|---|---|
ScalarDB 3.16 | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ |
Version | PostgreSQL 17 | PostgreSQL 16 | PostgreSQL 15 | PostgreSQL 14 | PostgreSQL 13 |
---|---|---|---|---|---|
ScalarDB 3.16 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ | ✅ | ✅ | ✅ |
Version | Aurora MySQL 3 | Aurora MySQL 2 |
---|---|---|
ScalarDB 3.16 | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ |
Version | Aurora PostgreSQL 16 | Aurora PostgreSQL 15 | Aurora PostgreSQL 14 | Aurora PostgreSQL 13 |
---|---|---|---|---|
ScalarDB 3.16 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ | ✅ | ✅ |
Version | MariaDB 11.4 | MariaDB 10.11 |
---|---|---|
ScalarDB 3.16 | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ |
Version | SQL Server 2022 | SQL Server 2019 | SQL Server 2017 |
---|---|---|---|
ScalarDB 3.16 | ✅ | ✅ | ✅ |
ScalarDB 3.15 | ✅ | ✅ | ✅ |
ScalarDB 3.14 | ✅ | ✅ | ✅ |
ScalarDB 3.13 | ✅ | ✅ | ✅ |
ScalarDB 3.12 | ✅ | ✅ | ✅ |
ScalarDB 3.11 | ✅ | ✅ | ✅ |
ScalarDB 3.10 | ✅ | ✅ | ✅ |
ScalarDB 3.9 | ✅ | ✅ | ✅ |
ScalarDB 3.8 | ✅ | ✅ | ✅ |
ScalarDB 3.7 | ✅ | ✅ | ✅ |
Version | SQLite 3 |
---|---|
ScalarDB 3.16 | ✅ |
ScalarDB 3.15 | ✅ |
ScalarDB 3.14 | ✅ |
ScalarDB 3.13 | ✅ |
ScalarDB 3.12 | ✅ |
ScalarDB 3.11 | ✅ |
ScalarDB 3.10 | ✅ |
ScalarDB 3.9 | ✅ |
ScalarDB 3.8 | ❌ |
ScalarDB 3.7 | ❌ |
Version | YugabyteDB 2 |
---|---|
ScalarDB 3.16 | ✅ |
ScalarDB 3.15 | ✅ |
ScalarDB 3.14 | ✅ |
ScalarDB 3.13 | ✅ |
ScalarDB 3.12 | ❌ |
ScalarDB 3.11 | ❌ |
ScalarDB 3.10 | ❌ |
ScalarDB 3.9 | ❌ |
ScalarDB 3.8 | ❌ |
ScalarDB 3.7 | ❌ |
NoSQL databases
- Amazon DynamoDB
- Apache Cassandra
- Azure Cosmos DB for NoSQL
Version | DynamoDB |
---|---|
ScalarDB 3.16 | ✅ |
ScalarDB 3.15 | ✅ |
ScalarDB 3.14 | ✅ |
ScalarDB 3.13 | ✅ |
ScalarDB 3.12 | ✅ |
ScalarDB 3.11 | ✅ |
ScalarDB 3.10 | ✅ |
ScalarDB 3.9 | ✅ |
ScalarDB 3.8 | ✅ |
ScalarDB 3.7 | ✅ |
Version | Cassandra 4.1 | Cassandra 4.0 | Cassandra 3.11 | Cassandra 3.0 |
---|---|---|---|---|
ScalarDB 3.16 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.15 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.14 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.13 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.12 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.11 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.10 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.9 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.8 | ❌ | ❌ | ✅ | ✅ |
ScalarDB 3.7 | ❌ | ❌ | ✅ | ✅ |
Version | Cosmos DB for NoSQL |
---|---|
ScalarDB 3.16 | ✅ |
ScalarDB 3.15 | ✅ |
ScalarDB 3.14 | ✅ |
ScalarDB 3.13 | ✅ |
ScalarDB 3.12 | ✅ |
ScalarDB 3.11 | ✅ |
ScalarDB 3.10 | ✅ |
ScalarDB 3.9 | ✅ |
ScalarDB 3.8 | ✅ |
ScalarDB 3.7 | ✅ |
For details on how to configure each database, see Configurations for the Underlying Databases of ScalarDB.
Permission requirements
This section describes the required permissions for using ScalarDB with its supported databases.
Oracle Database
ScalarDB requires the following actions to be granted to the Oracle Database user that ScalarDB uses to access Oracle Database:
- Oracle Database 23ai
- Oracle Database 21c
- Oracle Database 19c
CREATE SESSION
CREATE USER
DROP USER
ALTER USER
CREATE ANY TABLE
DROP ANY TABLE
CREATE ANY INDEX
DROP ANY INDEX
ALTER ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE SESSION
CREATE USER
DROP USER
ALTER USER
CREATE ANY TABLE
DROP ANY TABLE
CREATE ANY INDEX
DROP ANY INDEX
ALTER ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE SESSION
CREATE USER
DROP USER
ALTER USER
CREATE ANY TABLE
DROP ANY TABLE
CREATE ANY INDEX
DROP ANY INDEX
ALTER ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
IBM Db2
ScalarDB requires the following database authorities to be granted to the Db2 user that ScalarDB uses to access Db2:
- Db2 12.1
- Db2 11.5
DBADM
DATAACCESS
DBADM
DATAACCESS
MySQL
ScalarDB requires the following privileges to be granted to the MySQL user that ScalarDB uses to access MySQL:
- MySQL 8.4
- MySQL 8.0
CREATE
DROP
INDEX
ALTER
SELECT
INSERT
UPDATE
DELETE
CREATE
DROP
INDEX
ALTER
SELECT
INSERT
UPDATE
DELETE
PostgreSQL
ScalarDB requires the following PostgreSQL database role to be granted to the PostgreSQL role that ScalarDB uses to access PostgreSQL:
- PostgreSQL 17
- PostgreSQL 16
- PostgreSQL 15
- PostgreSQL 14
- PostgreSQL 13
SUPERUSER
SUPERUSER
SUPERUSER
SUPERUSER
SUPERUSER
MariaDB
ScalarDB requires the following privileges to be granted to the MariaDB user that ScalarDB uses to access MariaDB:
- MariaDB 11.4
- MariaDB 10.11
CREATE
DROP
INDEX
ALTER
SELECT
INSERT
UPDATE
DELETE
CREATE
DROP
INDEX
ALTER
SELECT
INSERT
UPDATE
DELETE
SQL Server
ScalarDB requires the following database roles to be granted to the SQL Server user that ScalarDB uses to access SQL Server:
- SQL Server 2022
- SQL Server 2019
- SQL Server 2017
db_ddladmin
db_datareader
db_datawriter
db_ddladmin
db_datareader
db_datawriter
db_ddladmin
db_datareader
db_datawriter
YugabyteDB
ScalarDB requires the following YugabyteDB database role to be granted to the YugabyteDB role that ScalarDB uses to access YugabyteDB:
SUPERUSER
Amazon DynamoDB
ScalarDB requires the following actions to be granted to the AWS IAM user that ScalarDB uses to access DynamoDB:
dynamodb:ConditionCheckItem
dynamodb:PutItem
dynamodb:ListTables
dynamodb:DeleteItem
dynamodb:Scan
dynamodb:Query
dynamodb:UpdateItem
dynamodb:DeleteTable
dynamodb:UpdateContinuousBackups
dynamodb:CreateTable
dynamodb:DescribeTable
dynamodb:GetItem
dynamodb:DescribeContinuousBackups
dynamodb:UpdateTable
application-autoscaling:RegisterScalableTarget
application-autoscaling:DeleteScalingPolicy
application-autoscaling:PutScalingPolicy
application-autoscaling:DeregisterScalableTarget
application-autoscaling:TagResource
Apache Cassandra
ScalarDB requires the following actions to be granted to the Cassandra role that ScalarDB uses to access Cassandra:
- Cassandra 3.11
- Cassandra 3.0
CREATE
DROP
ALTER
SELECT
MODIFY
CREATE
DROP
ALTER
SELECT
MODIFY
Kubernetes
ScalarDB is provided as a Pod on the Kubernetes platform in production environments. ScalarDB supports the following platforms and tools.
Platform
- Kubernetes: 1.28 - 1.32
- Red Hat OpenShift: TBD
Package manager
- Helm: 3.5+