Configure the Data Source Using Oracle WebLogic Server Administration Console

These steps enable you to configure the data source using Oracle WebLogic Server Administration Console.

1. Log in to Oracle WebLogic Server Administration Console, and click Lock & Edit in the Change Center.
2. Click Services, and click Data Sources.
3. In Summary of Data Sources, click New, and select Generic Data Source.
4. In JDBC Data Sources Properties , enter or select values for the following properties:

   • Name, for example, enter BIDatabaseGroupDS.

     The name used in the config.xml configuration file and throughout the Oracle WebLogic Server Administration Console whenever referring to this data source.

     JNDI Name , for example, enter jdbc/BIDatabaseGroupDS.

     The JNDI path to where the JDBC data source is bound.

     Database Type, for example, select Oracle.

     The DBMS of the database that you want to connect to.

5. Click Next.
6. Select a database driver from the Database Driver list.

   Note:

   If using an Oracle database, select Oracle's Driver (Thin) for Service Connections; Releases:9.0.1 and later.

7. Click Next.
8. Click Next.
9. On the Connection Properties page, enter values for the following properties:

   • Database Name - The name of the database that you want to connect to.

     Host Name - for example, enter: mymachine.example.com.

     The DNS name or IP address of the server that hosts the database.

     Note:

     Do not use local host if you intend to use a cluster.

     Port - For example, enter: 1521.

     The port on which the database server listens for connections requests.

     Database User Name

     Typically the schema owner of the tables defined in Create a Sample Schema for Groups and Group Members.

     For example, enter MYUSER.

   • Password/Confirm Password

     The password for the Database User Name.

     For example, enter password.

10. Click Next.
11. Check the details on the page are correct, and click Test Configuration.
12. Click Next.
13. In Select Targets, choose the servers or clusters as deployment targets for your data source.

    You should select the Administration Server and managed servers as your targets, for example:

    • In the Servers pane

      Select the AdminServer option.

    • In the Clusters pane

      Select the bi_server1 check box to deploy to the cluster.

14. Click Finish.
15. In the Change Center, click Activate Changes.

Note:

In this example, the data source is called BIDatabaseGroupDS.