Configure a JDBC endpoint

To configure a JDBC connection as an endpoint, you must specify the JDBC URL, username and password, schema, table name, and type of entry.

Before you begin

Ensure that you create an endpoint and specify the type as JDBC. See Configure endpoints.

Procedure

1. On the JDBC endpoint configuration page, in the JDBC URL field, enter the JDBC connection URL for the database that you want to access. The following examples are some typical URLs for various JDBC providers:

   IBM DB2

   jdbc:db2://hostname:port/dbname

   Informix

   jdbc:informix-sqli://hostname:port/dbname:informixserver=Informix Server Name

   Oracle

   jdbc:oracle:thin:@hostname:1521:SID

   Microsoft SQL Server

   jdbc:sqlserver://hostname:1433;databasename=dbname;

   Sybase

   jdbc:sybase:Tds:hostname:port/

   Derby

   jdbc:derby://hostname:port/server_database_path;options

   IBM solidDB

   jdbc:solid://hostname:port

2. In the JDBC Driver field, enter the JDBC driver implementation class name. The following examples are some typical driver implementation class names for various JDBC providers:

   IBM DB2

   com.ibm.db2.jcc.DB2Driver

   Informix

   com.informix.jdbc.IfxDriver

   Oracle

   oracle.jdbc.driver.OracleDriver

   Microsoft SQL Server

   com.microsoft.sqlserver.jdbc.SQLServerDriver

   Sybase

   com.sybase.jdbc3.jdbc.SybDriver

   Derby

   org.apache.derby.jdbc.ClientDriver

   IBM solidDB

   solid.jdbc.SolidDriver

   For more information about JDBC drivers, see the SDI documentation and search for Understanding JDBC Drivers.
3. In the Username and Password fields, enter the login name and credentials to access the specified database.
4. In the Schema field, enter the schema from the table of the database that you want to use.
5. In the Table name field, enter the table or view for the operations.
6. From the Type of Entry list, select person, group, or container.
7. To verify the JDBC connection settings, click Test Connection. If the connection is successful, the attributes in the endpoint are displayed in a separate pane. You can use the Filter field to search the attributes.
8. Optional: We can also specify a custom SELECT statement to specify entries for operations. Expand the Advanced section and enter the statement in the Custom Select field.

What to do next

After configuring the endpoint, we can create a flow to define the relationship between the endpoint and the target directory server.

Parent topic:

Configure endpoints