For database provisioning to a table, indicate where PingFederate should write new user records or update existing ones.

Location
Note:

This screen appears only when a Microsoft SQL Server datastore is chosen on the User Repository screen and the Table option is selected on the SQL Method screen.

  • Select the database schema and the table.
    Field Description
    Schema Select the table structures that store information within the database.
    Table Select the name of the database table that contains user records.
    Columns to fulfill For the selected table, all attributes and their data types are displayed.

    If the list of columns is not or might not be current (due to any recent changes), click Refresh.

    Later on the Attribute Fulfillment screen, all attributes must be mapped for the database insertion to succeed, although a null entry may be used for optional attributes.
    Tip:

    Click the link near the lower-left corner of the screen to see a list of available attributes from the SSO token.