Configuration Guides › Directory Configuration Guide › MySQL Server › Configure a MySQL Policy Store › How to Configure the Policy Store › Configure a MySQL Data Source for SOA Security Manager › 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. Do one of the following:
   • If you are using a supported 32–bit Windows operating system, click Start and select Programs, Administrative Tools, ODBC Data Sources.
   • If you are using a supported 64–bit Windows operating system:
     1. Navigate to the install_home\Windows\SysWOW64.
     2. Double–click odbcad32.exe

   The ODBC Data Source Administrator appears.

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 SOA Security Manager 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: SOA Security Manager 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 SOA Security Manager data store.