Choosing a SQL method - PingFederate

Choosing a SQL method - PingFederate - 11.2

PingFederate Server

bundle

pingfederate-112

ft:publication_title

PingFederate Server

Product_Version_ce

PingFederate 11.2 (Latest)

category

Administrator

Administratorguide

Audience

Capability

ContentType

DeploymentMethod

Guide

Product

Productdocumentation

SingleSignonSSO

Software

SystemAdministrator

pf-112

pingfederate

ContentType_ce

Guide > Administrator Guide

Guide

Product documentation

Page created: 5 Jul 2022 |

Page updated: 5 Jul 2022

| 1 min read

Guide Administrator Guide Content Type Product documentation 11.2 Capability Single Sign-on (SSO) Deployment Method Software Audience Administrator System Administrator Product PingFederate

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