Choosing a SQL method - PingFederate

Choosing a SQL method - PingFederate - 11.3

PingFederate Server

bundle

pingfederate-113

ft:publication_title

PingFederate Server

Product_Version_ce

PingFederate 11.3

category

Administrator

Administratorguide

Audience

Capability

ContentType

DeploymentMethod

Guide

Product

Productdocumentation

SingleSignonSSO

Software

SystemAdministrator

pf-113

pingfederate

ContentType_ce

Guide > Administrator Guide

Product documentation

Guide

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,

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.

Note:

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

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