Database prerequisites

• When you connect to a Microsoft SQL Server database server, Identity Director uses SQL Server authentication by default. You can also use Windows authentication.
• You can use protocol encryption to secure communication between the Datastore and the components that connect to it.
• You can configure Microsoft SQL Server to listen on a different port than the default one.

See also

• Configure SQL Server authentication
• Configure Windows authentication
• Configure protocol encryption
• Specify alternative ports for Microsoft SQL Server and IBM DB2

Prerequisites Microsoft Azure SQL Database

• Microsoft Azure account

Configuration

Before you can create a Datastore in Identity Director, you first need to create a database server on Microsoft Azure SQL Database:

1. Log in to your Microsoft Azure Management Portal.
2. Click New in the lower left corner.
3. In the wizard, select Data Services > SQL Database > Quick Create.
4. In the Database Name field, specify the name of a temporary database.
5. In the Server field, select New SQL database server.
6. In the Region field, select your region (e.g. East US when located in New York, North Europe when located in London).
7. Specify a login name and its password.
   • The first login that you create is assigned as the Administrator account of the SQL database server.
   • The password is case-sensitive and must meet the Azure password complexity rules. The default Azure password complexity rules: minimum length of 8 characters, minimum of 1 uppercase character, minimum of 1 lowercase character, minimum of 1 number.
8. Click Create SQL Database.
9. When the database has been created, open the database dashboard.
10. Write down the SQL Database server name (i.e. <servername>.database.windows.net). You need this server name to specify the connections settings in Identity Director.
11. Click the link Manage allowed IP addresses to allow the current machine to talk to AZURE SQL SERVER.
12. Click ADD TO THE ALLOWED IP ADDRESS.
13. Click SAVE.
14. Log in to the Setup and Sync Tool.
15. At Setup > Datastore, click Create.
16. In the wizard, specify the name and credentials of the SQL Database server that you just created on Microsoft Azure SQL Database.
17. Complete the remaining steps of the wizard. Any credentials that you create must meed the Azure password complexity rules.

Prerequisites

Database

• MySQL DBA credentials

Setup and Sync Tool and Management Portal

• MYSQL ODBC Driver

Prerequisites

Database

• Oracle DBA credentials

Setup and Sync Tool and Management Portal

• Oracle OLEDB provider

Prerequisites

Database

• An existing database and database user.
• The database user must be able to access a table space with a page size of at least 8k.
• The database must be created with the “Code Set” UTF-8 instead of the default IBM-1252.

Setup and Sync Tool and Management Portal

• IBM DB2 OLEDB provider (x64/x86)

Configuration

You cannot create a Datastore on IBM DB2 with the Datastore Wizard: you need to create a database on the database server first and then connect to it from the Setup and Sync Tool and the Management Portal:

1. Create a local user on the DB2 Server, for example: IID-LU. This account is used to connect to the Datastore.
2. Manually create a database on the DB2 Server, for example: IID-DB.
3. Create a table space for the user IID-LU in the IID-DB database. Specify a buffer pool of at least 8KB.
4. Create a schema in the IID-DB database, for example: identitydirector.
5. Add the user you created in step 1 to the database IID-DB.
6. Assign the applicable authorities, and add the schema and table space you created in steps 3 and 4 to this user. Make sure to assign the correct privileges.

You can configure IBM DB2 database servers to listen on a different port than the default port 50000.

See also

• Specify alternative ports for Microsoft SQL Server and IBM DB2