Using an External Database
For production and other critical environments, you should use an enterprise external database instead of the embedded H2 database.
Database connection changes to Integration Manager are made to the application.properties file, typically located here on Windows:
C:\ProgramData\Actian\IntegrationManager\conf\application.properties
MySQL (Windows or Linux)
Create a new database using MySQL workbench, for example, "datacloud_db".
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ datacloud_db?useSSL=false&createDatabaseIfNotExist=true
spring.datasource.username=user
spring.datasource.password=password
spring.datasource.initialize=false
spring.datasource.continue-on-error=false
To establish the new database connection and initialize the Integration Manager tables in MySQL, restart the Integration Manager service.
SQL Server 2016 (Windows only)
Create a new database using SQL Server Management Studio, for example, "datacloud_db". Note that Windows Authentication is used for database credentials.
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://localhost;databaseName=datacloud_db;integratedSecurity=true
spring.datasource.initialize=false
spring.datasource.continue-on-error=false
Configure the Integration Manager Windows service to log on as the domain user with read/write privileges to this database:
To establish the new database connection and initialize the Integration Manager tables in SQL Server, restart the Integration Manager service.
