Installation and Upgrade Guides › Directory Configuration Guide › MySQL Server › Configure a MySQL Policy Store › How to Configure the Policy Store › Configure a MySQL Data Source for SiteMinder › Create a MySQL Data Source on Windows

Create a MySQL Data Source on Windows

You create a MySQL data source for the MySQL wire protocol driver.

To create the MySQL data source

1. Log into the Policy Server host system.
2. Open the ODBC Data Source Administrator.
3. Click System DSN.

   System Data Sources lists all available data sources.

4. Click Add.

   The Create New Data Source dialog appears.

5. Scroll down and select SiteMinder MySQL Wire Protocol and click Finish.

   The ODBC MySQL Wire Protocol Driver Setup dialog appears.

6. Do the following in the General tab:
   1. Enter a data source name in the Data Source Name field.

      Example: SiteMinder MySQL Wire Data Source

   2. Enter the name of the MySQL database host system in the Host Name field.
   3. Enter the port on which the MySQL database is listening in the Port Number field.
   4. Enter the name of the MySQL database in the Database Name field.
7. Click Test Connect.

   The connection settings are tested. If the settings are valid, a prompt states that the connection is successful.

8. Click OK.

   The data source is created and appears in the System Data Sources list.

Note: You can now point the Policy Server to the SiteMinder data store.