Enterprise Administration Guide › Planning Your SAM Implementation › Implementation Considerations › Connector Servers › Connector Xpress Overview › Connector Xpress Example: Configure a JDBC Endpoint

Connector Xpress Example: Configure a JDBC Endpoint

In this example, the system administrator Steve creates a JDBC endpoint type in Connector Xpress to connect to a Microsoft SQL Server.

Steve has installed Connector Xpress on the Enterprise Management Server host. Steve does the following:

1. From the Start menu, selects Programs, CA, Identity Manager, Connector Xpress.

   The Identity Manager Connector Xpress main menu appears.

2. Clicks Setup Data Sources.

   The Setup Data Sources window opens.

3. Clicks Add.

   The Source Types window opens, displaying the available sources.

4. Selects JDBC and clicks OK.

   The Edit Source window opens.

5. Enters the following details:
   • Data source name—SQL Server
   • Database type—Microsoft SQL Server
   • Username—sa
   • Server Name—mysql
   • Port—1433
   • Database—users
6. Clicks Test to verify the connection settings.

   The Enter password for data source window opens.

7. Enters the sa user account password and clicks OK.

   A confirmation message appears, if no errors were discovered. The new data source is created. Steve now configures the new endpoint type.

8. Returns to the Identity Manager Connector Xpress main menu, and selects New Project.

   The Select Data Source for New Project window appears.

9. Selects the data source he created and clicks OK.

   The Endpoint Type Details window opens.

10. Enters the endpoint name and description, double clicks the Classes icon and selects the User Details option.

    The Map Class and Attributes window opens.

11. In the Select Schema and Table section, selects the following:
    • For Schema, selects dbo
    • For Table, selects sqlConnector table.

    The mapped columns are displayed.

12. In the Map Columns section, enters the following values in the Name columns:
    • In the uname row,enters Account ID
    • In the upassword row, enters Password
13. Selects Project, Save to save the endpoint type definitions.

Steve has configured a new JDBC endpoint type in Connector Xpress. Steve now registers the endpoint type with the Java Connector Server.