Using a remote database

When using the CLI with the Agent SDK, it comes pre-configured for using a local database powered by H2. In all other use cases, you'll need to configure a JDBC connection. Once defined, the SDK will take care of building the database and keeping it up to date for you.

To configure the database, you just need to adding the following to your application.properties where the items in ${} are environment variables that you should define.

agent.datasource.type=${DATABASE_TYPE:postgresql}
spring.datasource.url=jdbc:${agent.datasource.type}://${DATABASE_HOST:}:${DATABASE_PORT:5432}/${DATABASE_NAME:people_team_agents}
spring.datasource.username=${DATABASE_USERNAME:}
spring.datasource.password=${DATABASE_PASSWORD:}

The SDK includes the PostgreSQL JDBC drivers and the H2 drivers by default. If you would like to use another database you should include it's JDBC driver in your build.xml.