MS SQL Database for Adeptia Backend, Log and Quartz

Requirement: How to configure MS SQL Database for Adeptia Backend, Log, and Quartz.

Solution: In order to configure MS SQL Database, kindly, perform the following steps:-

• Configure the Backend & Log Database

1. Go to etc folder in Adeptia installation directory: …AdeptiaServer/ServerKernel/etc
2. Take back-up of your server-configure.properties file.
3. Open server-configure.properties in edit mode.
4. To change driver for Backend Database, go to the Database Configuration group.
5. Change JDO Database Driver Url in the abpm.jdo.driver, and paste com.microsoft.sqlserver.jdbc.SQLServerDriver
6. Change the JDO Database Connection URL by setting the JDBC connection URL in the abpm.jdo.url in the following format:-
   
   jdbc:sqlserver://<databaseServerName>:<port>;DatabaseName=<name of the database>
   

   Example,  jdbc:sqlserver://127.0.0.1:1433;DatabaseName=backend

    

   For the Named Instance, abpm.jdo.url will be in the following format: 
   
   jdbc:sqlserver://<databaseServerName>:<port>;databaseName=<name of the database>;instanceName=<name of the instance>

   Example,  jdbc:sqlserver://127.0.0.1:1433;databaseName=backend;instanceName=production 

7. To change driver for Log Database, go to the Database Appender group.
8. Change JDBC Driver Class in the log4j.appender.jdbc.dbclass and paste com.microsoft.sqlserver.jdbc.SQLServerDriver
9. Change the JDBC URL by setting the JDBC connection URL in the log4j.appender.jdbc.url in the following format: 
   
   jdbc:sqlserver://<databaseServerName>:<port>;DatabaseName=<name of the database>
   

   Example, jdbc:sqlserver://127.0.0.1:1433;DatabaseName=backend

   
   For Named Instance, log4j.appender.jdbc.url will be in the following format: 
   

   jdbc:sqlserver://<databaseServerName>:<port>;databaseName=<name of the database>;instanceName=<name of the instance>

    

   Example, jdbc:sqlserver://127.0.0.1:1433;databaseName=log;instanceName=production
   
   

10. Save and exit the file.

• Configure Quartz Database

1. Go to etc folder in Adeptia installation directory: …AdeptiaServer/ServerKernel/etc
2. Take back-up of quartz.properties file.
3. Open quartz.properties file in edit mode.
4. Go to Configure Datasources group, set the value of org.quartz.dataSource.aBPM.driver as com.microsoft.sqlserver.jdbc.SQLServerDriver.
5. Set the JDBC connection URL in the org.quartz.dataSource.aBPM.URL in this format:
   
   jdbc:sqlserver://<<Database Server>>:<<port>>;databaseName=<<name of the database>>
   

   Example,  jdbc:sqlserver://127.0.0.1:1433;DatabaseName=backend

   
   For Named Instance, set the JDBC connection URL in the org.quartz.dataSource.aBPM.URL in the following format: 
   
   jdbc:sqlserver://<databaseServerName>:<port>;databaseName=<name of the database>;instanceName=<name of the instance>
   

    

   Example, jdbc:sqlserver://127.0.0.1:1433;databaseName=backend;instanceName=production

6. Save and exit the file.