Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Sample Configuration for Oracle Database on Amazon RDS

AWS provides Amazon Relational Database Service (Amazon RDS) that you can use to set up, operate, and scale a relational database on the cloud. Amazon RDS is license-based and works on a “pay only for what you use policy.” For more information about Amazon RDS, visit the Amazon Relational Database Service (RDS) website.

Perform the following steps to configure an Oracle database instance on Amazon RDS and establish connections with iProcess Engine:

| 1. | Create a database instance on Amazon RDS running Oracle. For more information, see the User’s Guide for Amazon Relational Database Service (Amazon RDS). After you select the database engine and specify details such as the identifier, password, and so on, the final step is to configure advanced settings for the database, which in this case is Oracle.

| 2. | On the Configure Advanced settings page, add the Oracle database instance to the VPC on which iProcess Engine exists or is to be installed. On this page, you can also define accessibility levels, availability zone, and security groups. The following table lists the fields and their respective values that you must configure on this page.

Database Settings

Field | Required Value
Virtual Private Cloud (VPC) | Select the VPC on which iProcess Engine exists or needs to be installed.
Subnet group | Defines the subnets and IP range that the DB instance can use in the selected VPC. You must create a subnet group for the database instance and then select the same in this field. For more information about creating subnets, see User’s Guide for Amazon RDS.
Public accessibility | Determines whether you want EC2 instances and devices outside the VPC to connect DB instance. If yes, a public IP is assigned to the DB instance.
Availability Zone | Specifies the availability zone of your DB instance.
VPC Security Group | In this field, you can choose an existing security group or create a new one. Security groups have rules authorizing connections from all EC2 instances and devices that must connect to the database instance.

For this sample configuration, the following table lists the security group settings for sg-iPE such that iProcess Engine can connect to the Oracle database instance on Amazon RDS.

VPC Port Range

Type | Protocol | Port Range | Source | Description
All traffic | All | All | 192.0.2.0/32 | From private network
All traffic | All | All | sg-iPE | From Oracle Database Server on Amazon RDS

Note: 192.0.2.0/32 is used as an example IP address, replace this with your IP address.

The sample setup would resemble the following illustration.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.