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.
  2. Select the Database type: Microsoft SQL Server, Microsoft Azure SQL Database or MySQL.
    Click Next arrow to continue.
  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 arrow to continue.
  6. In the remaining steps, specify the name and other details for the new Datastore.
See also