Choosing a SQL method - PingFederate

Choosing a SQL method - PingFederate - 11.0

PingFederate Server

bundle

pingfederate-110

ft:publication_title

PingFederate Server

Product_Version_ce

PingFederate 11.0

category

Product

pf-110

pingfederate

ContentType_ce

Page created: 16 Jul 2021 |

Page updated: 19 Jan 2022

| 1 min read

Product PingFederate 11.0 Configuration User task Software Deployment Method Product documentation Content Type Single Sign-on (SSO) Capability Administrator Audience

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