Configuration Guide › Relational Database Management › How To Create a JDBC Data Source › WebSphere Data Sources › Create an Oracle Data Source for WebSphere

Create an Oracle Data Source for WebSphere

Follow these steps:

1. In the WebSphere Administrative Console, navigate to the JDBC provider that you created when you configured the JDBC driver.
2. Create a data source with the following properties and click Apply:

   Name: User Store Data Source

   JNDI Name: userstore

   URL: jdbc:oracle:thin:@db_systemname:1521:oracle_sid

3. Configure a new J2C Authentication Data Entry for the User Store Data Source:
   1. Enter the following properties:

      Alias: User Store

      User ID: username

      password: password

      where username and password are the username and password for the account you specified when you created the database.

   2. Click OK, then use the navigation links at the top of the screen to return to the data source you are creating.
4. Select the User Store J2C Authentication Data Entry that you have created from the list box in the following fields:
   • Component-managed Authentication Alias
   • Container-managed Authentication Alias
5. Click OK, then save the configuration.

   Note: To verify that the data source is configured correctly, click Test Connection in the configuration screen for the data source. If the test connection fails, restart WebSphere and test the connection again.