MSSQL Datasource in wildfly for IDM

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Risk Analytics
• CA Secure Cloud SaaS - Arcot A-OK (WebFort)
• CLOUDMINDER ADVANCED AUTHENTICATION
• CA Secure Cloud SaaS - Advanced Authentication
• CA Secure Cloud SaaS - Identity Management
• CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

Introduction:
Need to create a datasource for MSSQL to allow creation of MSSQL corporate user store. 

Instructions:

1) Visit http://localhost:9990/console login with your management console username for wildfly.

2) Create deployment 

<Please see attached file for image>

3) Add > Browse and select the .jar file in this location
[WILDFLY_HOME]\modules\com\ca\iam\jdbc\microsoft\main and choose sqljdbc.jar

<Please see attached file for image>

 

4) Hit next and then you can name the deployment and hit enable.

5) We need to create a datasource for the new driver. Click on the configuration tab, then choose connector > datasources on the left side and choose add.

<Please see attached file for image>

6) Choose a name and JNDI Name - The JNDI name must be unique and also must include java:/

<Please see attached file for image>

 

7) Hit next and then choose the JDBC Driver that we previously deployed. This should be "sqljdbc.jar" and hit next.

8) You will need your connection URL which should look something like this.
Jdbc:sqlserver://[SQLSERVERNAME];databaseName=[DATABASE];
Enter the remaining information on this screen as needed. Which include Username, password, and security domain.

9) Click test connection, once this is verified select done and the datasource has been successfully added.

You can now create a MS SQL corp store directory from the IM Management Console. 

 

Environment

Release: CAIDMB99000-12.6.7-Identity Manager-B to B
Component: