MSSQL Datasource in wildfly for IDM

book

Article ID: 39787

calendar_today

Updated On:

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>

pic1.png

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>

pic2.png

 

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>

pic3.png

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

<Please see attached file for image>

pic4.png

 

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:

Attachments

1558715306182000039787_sktwi1f5rjvs16tra.png get_app
1558715304220000039787_sktwi1f5rjvs16tr9.png get_app
1558715302257000039787_sktwi1f5rjvs16tr8.png get_app
1558715300151000039787_sktwi1f5rjvs16tr7.png get_app