This is not the latest version of Identity Director documentation.
View available documentation.

Create a new Reporting Datastore

You can create a new Reporting Datastore in the Reporting tab of the Setup and Sync Tool, or at Setup > Datastore > Reporting in the Management Portal.

Before proceeding, please review the database prerequisites.

  1. Click Create to open the Datastore Wizard, which helps you create a new Datastore.
    Click Next to start the Wizard.
  2. Select the Database type: Microsoft SQL Server, Microsoft Azure SQL Database or MySQL.
  3. Specify the Database server. You can use the IP address, hostname or FQDN of the server
  4. Select the desired settings for Protocol encryption and authentication (Microsoft SQL Server and Microsoft Azure SQL Database only).
    See also Configure SQL Server Authentication and Configure Windows Authentication.
  5. Specify a User name and Password.
    • On Microsoft SQL Server and Microsoft Azure SQL Database, Identity Director uses the specified credentials to create a Datastore. The account must have the dbcreator role on the database server.
    • On MySQL, Identity Director creates a Datastore (or schema) and a database user with the names specified in the Datastore Wizard.
    Click Next to continue.
  6. In the remaining steps, specify the name and other details for the new Datastore.
See also