Table of Contents

Search

  1. Preface
  2. Introduction to Banking Use Case
  3. Before You Begin
  4. Alerting Customer Account Balance Details
  5. Notifying Stock Price Changes
  6. Notifying Credit Card Transactions
  7. Notifying Free Health Checkups for Account Holders
  8. Alerting the Bank Manager about Customers with a Particular Account Type in a City Overview
  9. Alerting Customer Cash Withdrawal Details
  10. Alerting Stock Prices to DMAT Account Holders
  11. Checking Customer Cash Withdrawal Details for a Specified Duration
  12. Alerting Consequent Credit Card Transaction Rejections
  13. Monitoring Balance Threshold of Customers
  14. Using the Dashboard Functions
  15. Managing Banking Users and Roles
  16. Importing and Exporting Objects
  17. Setting Up High Availability
  18. Using Custom Services
  19. Using the REST APIs
  20. Using Java Adapter for REST API

Banking Use Case Tutorial

Banking Use Case Tutorial

Step 2. Create an SQL Connection

Step 2. Create an SQL Connection

Create an SQL connection to connect to the database.
  1. On the
    Design
    tab, select
    Connections
    .
  2. From the menu in the right pane, click
    Actions
    New
    .
  3. Under
    Connection
    , configure the following properties:
    Field
    Value
    Name
    SQL Connection
    Description
    Connection to connect to the database
    Type
    SQL Connection
  4. Under
    Configurations
    , configure the following properties:
    Field
    Value
    Driver Class
    com.informatica.jdbc.oracle.OracleDriver
    Connection URL
    jdbc:informatica:oracle://infa-server:1521;databaseName=infaorcl
    User Name
    rulepoint
    Password
    rulepoint
  5. Click
    Test Connection
    to verify if the connection is successful.
  6. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!