Skip to main content

Supported Backend Databases

The consumer can persist messages to the following databases. These can be either on-premises or as Platform as a Service (PaaS).

Supported Databases​

DatabaseSupported
PostgreSQL✅
Microsoft SQL Server✅
MySQL✅
MariaDB✅
Oracle Database✅

Database Requirements​

You must provide a user that can create/update database schemas in the database. The consumer comes pre-built with schema information and manages it automatically.

Key Points​

  • The consumer will automatically create tables for each Kafka topic you configure
  • If auditing is enabled, accompanying audit tables will also be created
  • Tables are adjusted based on the messages received
  • Schema changes are detected automatically from the Schema Registry
Database User Permissions

Ensure your database user has the following permissions:

  • CREATE TABLE
  • ALTER TABLE
  • INSERT, UPDATE, DELETE
  • CREATE INDEX (recommended for performance)

Database Connection Examples​

PostgreSQL​

spring:
  datasource:
    url: jdbc:postgresql://192.156.31.82:5432/solifidb
    driver-class-name: org.postgresql.Driver
    username: postgres
    password: postgres

Microsoft SQL Server​

spring:
  datasource:
    url: jdbc:sqlserver://hostname:1433;database=master;encrypt=true;trustServerCertificate=true;
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    username: admin
    password: password

MySQL​

spring:
  datasource:
    url: jdbc:mysql://192.168.29.82:3306/solifidb
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: mysql

MariaDB​

spring:
  datasource:
    url: jdbc:mariadb://192.156.31.82:3304/solifidb
    driver-class-name: org.mariadb.jdbc.Driver
    username: root
    password: mariadb123

Oracle Database​

spring:
  datasource:
    url: jdbc:oracle:thin:@192.156.31.82:1521/XE
    driver-class-name: oracle.jdbc.OracleDriver
    username: sys as sysdba
    password: Oracle123$

Next Steps​