Using an External MySQL Database
If you need to use an external MySQL database instead of the embedded H2 database, make the following changes to the Integration Manager application.properties file, located here:
C:\ProgramData\Actian\IntegrationManager\conf
Replace host:port with your hostname and port number. For example, 127.0.0.1:3306.
Replace test_db in the URL connection string with the actual schema name you want to use.
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://host:port/test_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.