The connection to the ConnectALL database can be configured using this section. This page will load the existing database configuration and you can select the database type and configure the details. By clicking on the Change Password checkbox, the password will be enabled for editing.

*The modified database configuration will be effective after the restart of the Tomcat and ConnectALL core services.

Configuring Databases

ConnectALL supports database servers such as MySql, Microsoft SQL Server, or Oracle. The DB servers are configured/upgraded during the installation/upgrade and are used to persist the metadata information. The passwords are encrypted by ConnectALL and are saved in the $MULE_HOME/conf/DB.properties. They should be updated only during an installation/upgrade, and should not be edited manually. Once the database configuration is done, the connection parameters will be similar to what is shown below.

The following file SHOULD NOT be modified with a text editor. Change it only by using the ConnectALL GUI.

Procedure

Microsoft SQL Server

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://{database_server_ip};DatabaseName=muledb
jdbc.user={user_name}
jdbc.pwd={encrypted password}
CODE

MySQL

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://{database_server_ip}/muledb
jdbc.user={user_name}
jdbc.pwd={encrypted password}
CODE

Oracle

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@{database_server_ip}:connectalldb
jdbc.user={user_name}
jdbc.pwd={encrypted password} 
CODE

Important Info

From version 2.10.4, ConnectALL supports Oracle database version 19C. If you are using Oracle Database version 11G (or lower versions), and if you plan to upgrade to Oracle DB version 19C, the OJDBC jar files also have to be upgraded to JDBC 8 from JDBC 7. (Or) if you are installing oracle 19C directly, select OJDBC 8 and install. For more information, click here.
Note that the path for oracle Database driver is — C:\Connectall\mulesoft\mule-standalone-3.9.0\lib\user

PostgreSQL

jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://{database_server_ip}/connectalldb
jdbc.user={user_name}
jdbc.pwd={encrypted password} 
CODE

Note: These properties must be set using the DB Configuration link on the ConnectALL-GUI.

Microsoft Azure SQL 

jdbc.driver= com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://{database_server_ip};DatabaseName=muledb
jdbc.user={user_name}
jdbc.pwd={encrypted password}
CODE

Driver Locations