1. Application Installation Guide
  2. Create Domains, Repositories, Data Sources
  3. Creating Data Source

2.4 Creating Data Source

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

    Figure 2-39 Create Data Source 1


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

  2. The following window is displayed.

    Figure 2-40 Create Data Source 2


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

  3. Click Domain Name > Services > Data Sources.
  4. The following window is displayed.

    Figure 2-41 Create Data Source 3


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

  5. Click Lock & Edit button on the left panel. Click New on right panel and select Generic Data Source.

    Figure 2-42 Create Data Source 4


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

  6. Enter Data source Name, JNDI Name as jdbc/ofsllDBConnDS and select Oracle as Database Type.
  7. Click Next.
    The following window is displayed.

    Figure 2-43 Create Data Source 5


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

  8. Select the Database Driver Oracle's Driver(Thin) for Instance connections; Versions:Any as shown above.
  9. Click Next.
    The following window is displayed.

    Figure 2-44 Create Data Source 6


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

  10. Click Next.
    The following window is displayed.

    Figure 2-45 Create Data Source 7


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

  11. Enter Database details click Next.
    The following window is displayed.

    Figure 2-46 Create Data Source 8


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

  12. Click Test Configuration.
    The following window is displayed.

    Figure 2-47 Create Data Source 9


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

  13. Displays confirmation message as Connection test succeeded. Click Next.
    The following window is displayed.

    Figure 2-48 Create Data Source 10


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

  14. Select target Servers AdminServer and OFSLL_ManagedServer and click Finish.
    The following window is displayed.

    Figure 2-49 Create Data Source 11


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

  15. Click Activate Changes on the left panel.

Update the following parameters in JDBC data source connection pool:

1. Select Services > Data Sources > select the OFSLL data source > Connection Pool.

2. Initial capacity and Maximum capacity is defaulted to 15, if the number of concurrent users are more this needs to be increased.

3. Click Advanced button and update the following:
  • Inactive Connection Timeout=900
  • Uncheck the ‘Wrap Data Types’ parameter for better performance.

4. Click Save.

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 au­thentication:

3.5 Creating SQL Authentication Provider

3.6 Creating User Groups and Users

3.7 Implementing JMX Policy for Change Password

4.1 Configuring Password Policy for SQL Authenticator

4.2 Configuring User Lockout Policy

Parent topic: Create Domains, Repositories, Data Sources