Setting up an Oracle Database¶
Follow the steps given below to set up the required Oracle databases for your Micro Integrator (MI) Dashboard.
Creating the databases¶
The required Oracle script is stored in the
<MI_DASHBOARD_HOME>/dbscripts/oracle directory of your Micro Integrator
Create the database and then create the DB tables by pointing to the Oracle script in the
In SqlPlus terminal run following command to source the script @/home/oracle/oracle.sql
Setting up the JDBC driver¶
- Download the Oracle JDBC driver.
- Add the downloaded Oracle driver and copy the JAR (ojdbc8.jar) to the
<MI_DASHBOARD_HOME>/lib/directory of your Micro Integrator (MI) Dashboard.
Connecting the database to the server¶
deployment.toml file in the
<MI_DASHBOARD_HOME>/conf directory and add the following sections to create the connection between the Micro Integrator (MI) Dashboard and the database.
[datasource] jdbcUrl = "jdbc:oracle:thin:@localhost:1521/ORCLPDB1" username = "SYSTEM" password = "oracle" driverClassName = "oracle.jdbc.OracleDriver" maximumPoolSize = "100" poolName = "dashboard-1" connectionTimeout = "400000" maxLifetime = "2000000"
For more information, see the descriptions of database connection parameters.Top