Database configuration examples

This page provides examples of how to configure the database connection for the different database types supported by the platform.

For more information, see the create-db reference ⧉ in the Spotfire documentation, with the "Examples of creating a Spotfire database schema"-sections for each database type at the end.

PostgreSQL

StandardAuroraAWSAzure

database:
  bootstrap:
    databaseUrl: "jdbc:postgresql://server/"
    driverClass: "org.postgresql.Driver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "postgres"
    adminPassword: "postgresPassword"
    databaseUrl: "jdbc:postgresql://server/"

database:
  bootstrap:
    databaseUrl: "jdbc:postgresql://server:5432/spotfire"
    driverClass: "org.postgresql.Driver"
    username: "postgres"
    password: "postgresPassword"
  create-db:
    adminUsername: "postgres"
    adminPassword: "postgresPassword"
    databaseUrl: "jdbc:postgresql://server:5432/"
    doNotCreateUser: true

database:
  bootstrap:
    databaseUrl: "jdbc:postgresql://server:5432/spotfire"
    driverClass: "org.postgresql.Driver"
    username: "postgres"
    password: "postgresPassword"
  create-db:
    adminUsername: "postgres"
    adminPassword: "postgresPassword"
    databaseUrl: "jdbc:postgresql://server:5432/postgres"
    doNotCreateUser: true

database:
  bootstrap:
    databaseUrl: "jdbc:postgresql://server:5432/spotfire"
    driverClass: "org.postgresql.Driver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "spotfire"
    adminPassword: "spotfirePassword"
    databaseUrl: "jdbc:postgresql://server:5432/postgres"
    doNotCreateUser: true

Microsoft SQL Server

StandardAWS

database:
  bootstrap:
    databaseUrl: "jdbc:sqlserver://server:1433;DatabaseName=spotfire"
    driverClass: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "sa"
    adminPassword: "saPassword"
    databaseUrl: "jdbc:sqlserver://server:1433"

database:
  bootstrap:
    databaseUrl: "jdbc:sqlserver://server:1433;DatabaseName=spotfire"
    driverClass: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "admin"
    adminPassword: "adminPassword"
    databaseUrl: "jdbc:sqlserver://server:1433"
    variant: "rds"

Oracle

StandardAWSAzure

database:
  bootstrap:
    databaseUrl: "jdbc:oracle:thin:@server:1521:spotfire"
    driverClass: "oracle.jdbc.OracleDriver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "system"
    adminPassword: "systemPassword"
    databaseUrl: "jdbc:oracle:thin:@server:1521:ORCL"
    oracleTablespacePrefix: "spotfire"
    oracleRootfolder: 'C:\Oracle19c'

database:
  bootstrap:
    databaseUrl: "jdbc:oracle:thin:@//server:1521/ORCL"
    driverClass: "oracle.jdbc.OracleDriver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "admin"
    adminPassword: "adminPassword"
    databaseUrl: "jdbc:oracle:thin:@//server:1521/ORCL"
    spotfiredbDbname: ""
    variant: "rds"

database:
  bootstrap:
    databaseUrl: "jdbc:sqlserver://server:1433;DatabaseName=spotfire"
    driverClass: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    # username: "spotfire"
    password: "spotfirePassword"
  create-db:
    adminUsername: "spotfire"
    adminPassword: "spotfirePassword"
    databaseUrl: "jdbc:sqlserver://server:1433"
    variant: "azure"