Other databases

The following examples demonstrate how to configure a connection to Microsoft SQL Server and Oracle Database 11g. Username and password fields are omitted for brevity. These fields are part of the platform installation guides.

Microsoft SQL Server with default instance

relution:
  database:
    type: mssql
    url: 'jdbc:sqlserver://localhost:1433;databaseName=relution'

Microsoft SQL Server with custom instance

relution:
  database:
    type: mssql
    url: 'jdbc:sqlserver://localhost\<INSTANCE>:1433;databaseName=relution'

Oracle 11g with SID

relution:
  database:
    type: oracle
    url: 'jdbc:oracle:thin:@localhost:1521:<SID>'

Oracle 11g with service name

relution:
  database:
    type: oracle
    url: 'jdbc:oracle:thin:@//localhost:1521/<SERVICE_NAME>'

Dedicated Liquibase DB user

By default the relution.database.* connection & credentials are used to perform all Liquibase changes, but a dedicated DB user can be configured to perform them.

First you create a new user in the database and assign him the corresponding DB permissions to perform DDL operations. Then you extend the Relution yaml configuration with the credentials like seen below:

spring:
  #datasource: # this is defined in relution.database.*
  liquibase:
    #default-schema: # this is defined in relution.database.*
    user: <liquibaseUser>
    password: <liquibaseUserPassword>