Description:
This document will provide you with a technical overview and discuss the key points in connecting Policy Express to MS SQL Server database to retrieve data or execute SQL procedures.
Solution:
Policy Express is a CA utility that's part of Identity Manager. This utility allows you to develop business rules and apply them to the accurate business or technical circumstances in order to achieve many provisioning goals. The Policy Express consists of a number of elements each with a different purpose. This will concentrate on the Data element of the Policy Express. The Data element is allowing you to connect Policy Express to numerous data sources in order to retrieve information that is necessary for the policy that's being developed. Among these data sources you are able to connect to a MS SQL server to retrieve information in a form of a query, a function or a stored procedure.
Below you see a screen shot of the Data Tab on the policy that's being developed. To connect to a database select:
In the lower section you must enter a Data Source and a Query.
<datasources> <no-tx-datasource> <jndi-name>userstore</jndi-name>...Here you will specify you connection string to the database for this jndi name resource.
... </no-tx-datasource></datasources>Note: The Data Source field must contain a jndi name for a resource that contains a descriptor in your application server. You cannot use it to connect to databases not defined in your application server. If you require to connect to a new database you'll need to create such a descriptor file as mentioned above and then use its jndi name.
<Please see attached file for image>