Preface
Introduction
Create a Service Connector and a Connection
Create a Process
Invoke the Process
- Step 1: Invoke the Process with the Integers 10 and 5
  - View the Process Instance on the Application Integration Console
- Step 2: Invoke the Process with the Integers 8 and 0
  - View the Faulted Process Instance on the Application Integration Console
Update the Process to Enable Fault Handling
- Step 1: Enable Fault Handling
- Step 2: Modify the Output Configuration
Invoke the Updated Process with Integers 8 and 0
- View the Updated Process Instance on the Application Integration Console
Optional: Archive Results
- Create a JDBC Connection
- Archive Results

Tutorial: Calculator

Back Next

Create a JDBC Connection

Enter connection properties to create a JDBC connection.

Prerequisite:
To create a JDBC connection, you must have a working Secure Agent and write access to a JDBC database.

Use the following code to create a schema in your JDBC database:

CREATE TABLE `calculatorArchive` (
  `sum` int(11) DEFAULT NULL,
  `difference` int(11) DEFAULT NULL,
  `product` int(11) DEFAULT NULL,
  `quotient` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Keep the following JDBC properties handy:

Connection URL

User name

Password

JDBC JAR Directory

on the machine where you installed the Secure Agent. For example:

C:\JDBC

is a valid

JDBC JAR Directory

because the Secure Agent is on the same machine at

C:\Program Files\InformaticaCloudSecureAgent

You do not need to create a JDBC service connector because a generic JDBC connector is built in the

Application Integration

service.

Application Integration

, click

New

In the

New Asset

dialog box, select

App Connections

App Connection

, and then click

Create

as shown in the following image:

Process Designer opens with a connection template.

Enter the following information on the

Properties

tab:

In the

Name

field, enter

JDBCConn

Next to the

Location

field, click

Browse

, and then browse to and select the

Tutorials

Calculator

folder.

In the

Description

field, enter the following text:

JDBC connection to archive Calculator process results.

From the

Type

list, select

JDBC Generic Cloud Adaptor

From the

Runtime Environment

list, select your Secure Agent.

Configure the

JDBC Connection URL

JDBC Jar Directory

Username

, and

Password

fields:

Click

Test

The connection tests successfully.

Click

Save

Click

Actions

Publish

For more information about JDBC connections, see

JDBC Connector Guide

Optional: Archive Results

Download Guide

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Tutorial: Calculator

Tutorial: Calculator

Create a JDBC Connection

Create a JDBC Connection