Choosing a SQL method

PingFederate allows you to map attributes directly to a single database table, the default, or to SQL stored-procedure parameters for Java Database Connectivity (JDBC) datastores,

About this task

Choose and configure the preferred method on the SQL Method tab.

Screen capture of the SQL Method tab showing the Table and Stored Procedure options.

This tab appears only when you specify Microsoft SQL Server datastore on the User Repository tab.

Steps

Make a selection as needed and click Next.

Depending on the selection, different steps appear under the JIT Provisioning task. See the sections indicated for more information.
If mapping attributes directly to a table, see the topics sections immediately following:
- Specifying a database user-record location
- Specifying a unique ID database column
If using a stored procedure, skip to Specifying a stored procedure location