Skip to main content

APIs Reference

Common aspects reference guide for Backend APIs - GraphQL and REST APIs.


Backend APIs - GraphQL and REST APIs are Spring Java projects and share a common framework and mechanism.

Please find information on those common aspects pertaining to:

  • Support matrix and versions information for languages, tools & technologies, databases, etc.
  • Database Deployment support matrix, databases, versions, etc.

APIs Features Reference

Common aspects pertaining to APIs features reference guide for Backend APIs - GraphQL and REST APIs.

Feature support

Please refer to list at Backend Features

Backend APIs Deployment - Support Matrix

This page mentions version compatibilities for our support matrix.

API Development Framework, Language

  • Spring Boot 2.7.3 with Java 8 (JDK 8)
  • Spring Boot 3.2.3 with Java 17 (or Java 21)


Databases supported for runtime deployment are Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server, Azure SQL, Snowflake, (DB2, H2, HSQLDB).

Please also see compatible-databases list.

Please contact us for help on any suported databases, for which details are not provided.

Database Drivers and Supported Database Versions

Below are provisions in pom.xml. Some old database versions and drivers will also work. Try them out if needed or contact us.

DatabaseJDBC DriverDatabase Versions
Oracleojdbc8.jarOracle 21c, 19c, 18c, and 12.2
MS SQL Server10.2.1.jre8SQL Server 2019 (2017, 2016, 2014, 2012)
Azure SQL10.2.1.jre8Azure SQL
PostgreSQL42.5.1PostgreSQL 8.2 or newer
MySQL Newer Ver8.0.31MySQL Server 8.0, 5.7 and 5.6
MySQL5.1.49MySQL Server ver 5.0, 5.5
Snowflake3.13.32for *

Connecting Databases

Connection examples of providing spring.datasource parameters such as URL, etc as per db type :

  • Please refer to file. Uncomment parameters for the database you want to use.
# mysql
# -----------------------------------------------------------------
# -----------------------------------------------------------------


# mssql Azure SQL
# -----------------------------------------------------------------
# Use with Azure Cloud Shell or Azure CLI

# -----------------------------------------------------------------

Connecting Databases examples

Connection examples of providing URL as per db type :

  • Oracle (oracle)
  • MS SQL Server (mssql)
  • Azure SQL (mssql)
  • PostgreSQL (psql)

Using Amazon RDS | AWS RDS , e.g. :

  • MySQL (mysql)

Please Also provide datbase user and password.


Below parameters, if skipped, are set to defaults for driver, and should not pose any issues.


Help on Setting-Up Databases

MS SQL Server 2019 Express (mssql)

Azure SQL (mssql)


For generating code for snowflake:

  • Please note, you can create snowflake tables temporarily in postgresql db and use them to import in Studio Builder and generate code.

For using snowflake during runtime, use below steps.

  • Add dependency to pom.xml
  • Setup as:
# snowflake
# -----------------------------------------------------------------

Note: The EmptyDialect needs to be added in source. Create a java source file in src/ folder, with below content:

package emrest.spring;
public class EmptyDialect extends org.hibernate.dialect.Dialect {}

Compatible Databases

Compatible Databases: Below Postgres or other compatible databases should be able to be used for Import and runtime deployment: