---
title: Choosing a SQL method
description: 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,
component: pingfederate
version: 13.1
page_id: pingfederate:administrators_reference_guide:help_userprovisioningtasklet_userprovisioningsqlmethodstate
canonical_url: https://docs.pingidentity.com/pingfederate/13.1/administrators_reference_guide/help_userprovisioningtasklet_userprovisioningsqlmethodstate.html
llms_txt: https://docs.pingidentity.com/pingfederate/llms.txt
docs_for_agents: https://developer.pingidentity.com/build-with-ai/docs-for-agents.md
revdate: July 5, 2022
section_ids:
  about-this-task: About this task
  steps: Steps
---

# 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.](_images/nbx1564003515373.jpg)

|   |                                                                                                       |
| - | ----------------------------------------------------------------------------------------------------- |
|   | 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](help_userprovisioningtasklet_selectdatabasetableandcolumnsstate.html)

  * [Specifying a unique ID database column](help_userprovisioningtasklet_userprovisioningjdbcuniqueidstate.html)

* If using a stored procedure, skip to [Specifying a stored procedure location](help_userprovisioningtasklet_selectdatabaseschemaandstoredprocstate.html)