2.4 Creating Data Source

The following section details the steps to create data source.
  1. Login to WebLogic Server 14c em (http://hostname:port/em).

    Figure 2-37 Create Data Source 1


    Description of Figure 2-37 follows
    Description of "Figure 2-37 Create Data Source 1"

  2. The following window is displayed.

    Figure 2-38 Create Data Source 2


    Description of Figure 2-38 follows
    Description of "Figure 2-38 Create Data Source 2"

  3. Click WebLogic Domain > Data Sources.
    The following window is displayed.

    Figure 2-39 Create Data Source 3


    Description of Figure 2-39 follows
    Description of "Figure 2-39 Create Data Source 3"

  4. Click Lock & Edit on the left panel. Click Create on right panel and select Generic Data Source.
    The following window is displayed.

    Figure 2-40 Create Data Source 4


    Description of Figure 2-40 follows
    Description of "Figure 2-40 Create Data Source 4"

  5. Enter Data source Name, JNDI Name as jdbc/ofsllDBConnDS, select Oracle as Database Type and Select the Database Driver Oracle's Driver(Thin) for Instance connections; Versions:Any.
  6. Click Next.
    The following window is displayed.

    Figure 2-41 Create Data Source 5


    Description of Figure 2-41 follows
    Description of "Figure 2-41 Create Data Source 5"

  7. Enter Database details Click Generate URL and Properties.
    • Click Ok.
    The following window is displayed.

    Figure 2-42 Create Data Source 6


    Description of Figure 2-42 follows
    Description of "Figure 2-42 Create Data Source 6"

  8. Enter OFSLL DB schema.
    The following window is displayed.

    Figure 2-43 Create Data Source 7


    Description of Figure 2-43 follows
    Description of "Figure 2-43 Create Data Source 7"

  9. Enter Password and Confirm Password.
    • Click Test Database Connection. On completion, displays a confirmation message as Connection test succeeded.
    The following window is displayed.

    Figure 2-44 Create Data Source 8


    Description of Figure 2-44 follows
    Description of "Figure 2-44 Create Data Source 8"

  10. Initial capacity and maximum capacity are defaulted to 15, if the number of concurrent users are more this needs to be increased.
    The following window is displayed.

    Figure 2-45 Create Data Source 9


    Description of Figure 2-45 follows
    Description of "Figure 2-45 Create Data Source 9"

  11. Click Advanced and update the following:
    • Inactive Connection Timeout : 900
    • Uncheck the Wrap Data Types parameter
    • Click Save
    • Click Next
    The following window is displayed.

    Figure 2-46 Create Data Source 10


    Description of Figure 2-46 follows
    Description of "Figure 2-46 Create Data Source 10"

  12. Click Next.
    The following window is displayed.

    Figure 2-47 Create Data Source 11


    Description of Figure 2-47 follows
    Description of "Figure 2-47 Create Data Source 11"

  13. Select AdminServer, OFSLL_ManagedServer and click Next.
    The following window is displayed.
    Description of datasource11.png follows
    Description of the illustration datasource11.png

  14. Click Create.
    The following window is displayed.
    Description of datasource12.png follows
    Description of the illustration datasource12.png

  15. Click Activate Changes on the left panel.
    The following window is displayed.
    Description of datasource13.png follows
    Description of the illustration datasource13.png

    Note:

    User Authentication and Management is outside of Oracle Financial Services Lending and Leasing application. Organizations can use an LDAP implementation for authentication. For Development and Testing purpose, the following sections can be configured for authentication:

Parent topic: Create Domains, Repositories, Data Sources