Steps to configure Azure Active Directory credentials to login MS SQL Server Backend and Log Database in Adeptia

Requirement: How to configure Adeptia's Backend and Log Database (running on MS SQL server) login details with Azure Active Directory credentials.

Solution: Kindly, perform the following steps to configure the Azure Active Directory credential for login in Adeptia's Backend and Log Database.

A. Installation Instructions of dll file
 
1. Download the sqljdbc_auth.dll file compatible with your MS SQL Server from the below link:-
- http://www.microsoft.com/en-us/download/details.aspx?id=11774
2. Run sqljdbc_<version>_<language>.exe.
3. Enter an installation directory when prompted. We recommend that you unpack this zip file in “C:\Program Files\MSSQL_WindowsAuthentication” with the default directory.
 
B. Instructions to add and configure dll file in Adeptia
 
1. Goto the directory ".\AdeptiaInstallation\AdeptiaServer\ServerKernel\ext" and create a folder with the name "dll".
2. Now, place the downloaded dll file here.

 
3. Goto the directory ".\ServerKernel\etc" and open the launcher.properties file in edit mode.
4. Add the below line in the JVM parameters and define the path as per your build installation as shown in the image.

-Djava.library.path="AdeptiaInstallationfolder\AdeptiaServer\ServerKernel\ext\dll"

C. Instructions to download Azure Active Directory dependency JAVA libraries files.

1. Download the ADAL4J.jar for performing ActiveDirectoryPassword authentication from here.

2. On extracting the downloaded zip file and you will find a set of 13 dependency jar files as shown below.  

D. Instruction to add Azure Active Directory dependency JAVA libraries in Adeptia.

1. Copy all the 13 jar files and paste them at location "D:\Program Files\AdeptiaConnect_3_6_MsSQL_WA\AdeptiaConnect-3.6\ConnectServer\AdeptiaServer\ServerKernel\ext".

E. Instructions to connect Adeptia Databases using Windows Authentication

• Steps to configure Backend and Log Database

1. Go to the directory ".\ServerKernel\ext" and open the server-configure.properties file in edit mode. Make sure to have a backup of this file
2. Search for the "Database Configuration" section and set the properties as shown below:-

abpm.jdo.url: jdbc:sqlserver://<Host Server>:<port>:3342;database={Backend Database};Authentication=ActiveDirectoryPassword;
abpm.jdo.username: AD username
abpm.jdo.password: AD Password

 
3. Now, search for "Database appended" and set the properties as shown below:-

log4j.appender.jdbc.url: jdbc:sqlserver://<Host Server>:<port>:3342;database={Log Database};Authentication=ActiveDirectoryPassword;
log4j.appender.jdbc.username: AD username
log4j.appender.jdbc.password: AD Password

• Steps to configure Quartz Database

1. Go to the directory ".\ServerKernel\etc" and open the "quartz.properties" file in edit mode and set the following properties:-

org.quartz.dataSource.aBPM.URL=jdbc:sqlserver://<Host Server>:<port>:3342;database={Backend Database};Authentication=ActiveDirectoryPassword;
org.quartz.dataSource.aBPM.user= AD username
org.quartz.dataSource.aBPM.password= AD Password

 
4. Save the file.
5. Restart the Adeptia Services.