Co-author – Srihari Ananda Kumar
Amazon Relational Database Service (RDS) is a managed SQL database by Amazon Web Services that makes it easy to set up, run, and scale a relational database on the AWS Cloud. It provides cost-efficient security, high availability and durability, resizable capacity for an industry-standard relational database, and manages common database administration tasks.
Building a flow in IBM App Connect with Amazon RDS
Use App Connect to build flows that integrate with Amazon RDS and other applications. The connector is displayed as Amazon RDS on the App Connect User Interface (UI).
To allow App Connect to connect to your Amazon RDS account, you need to fill in the connection fields that you see in the App Connect Designer Catalog page or flow editor. For more information on connection fields, see How to use IBM App Connect with Amazon RDS.
To obtain the connection values for Amazon RDS and to connect to App Connect, refer to Connecting to Amazon RDS.
Amazon RDS objects
The following are Amazon RDS action objects that can be run in App Connect.
|
Objects
|
Description
|
|
Database clusters
|
Contains the details of an Amazon Aurora DB cluster or multi-AZ DB cluster.
|
|
Database instances
|
Contains the details of an Amazon RDS DB instance.
|
|
Database snapshots
|
Contains the details of an Amazon RDS DB snapshot.
|
| Exports |
Exports RDS database data to an Amazon S3 bucket. You can export all types of database data such as database snapshots, clusters,
and instances.
|
|
Tags
|
A metadata assigned to an Amazon RDS resource consisting of a key-value pair.
|
Scenario 1: Stop or start or reboot the Amazon RDS instance whenever a Zendesk Service ticket gets created
Consider this scenario; you are an IT personnel with permission to manage Amazon RDS instances. You can start, stop, or reboot the instances whenever a Zendesk Service ticket gets created.
In this example, the flow checks the Zendesk Service ticket’s subject to whether to start, stop, or reboot the Amazon RDS instance based on the instance ID from the Zendesk Service ticket.
In this flow:
- The event-driven flow is triggered whenever a new ticket gets created in Zendesk Service.
- If the Zendesk Service ticket Subject is equal to START, Amazon RDS starts the instance based on the Zendesk Service instance ID.
- If the Zendesk Service ticket Subject is equal to STOP, Amazon RDS stops the instance based on the Zendesk Service instance ID.
- Else, Amazon RDS reboots the instance based on the Zendesk Service instance ID.
Resources
Try out our templates
You can view the following use cases in the Templates gallery in your App Connect Designer instance.
- Stop or start or reboot the Amazon RDS instance whenever a Zendesk Service ticket gets created
Template URL: https://<your-instance-id>/templates/Stop%20or%20start%20or%20reboot%20the%20Amazon%20RDS%20instance%20whenever%20a%20Zendesk%20Service%20ticket%20gets%20created
Template URL: https://<your-instance-id>/templates/ Create%20a%20database%20instance%20in%20Amazon%20RDS%20when%20a%20new%20company%20is%20created%20in%20IBM%20Maximo
You must enable the Designer AI features in your containerized environment in order to access the App Connect templates. For more information, see The preloaded IBM App Connect templates.
You can also import these use cases directly into your App Connect Designer. These templates are added to a public GitHub repository at https://github.com/ot4i/app-connect-templates/tree/cp4i-templates/resources. For more information about the supported connectors, see App Connect Connectors.
For any inquiries on this blog or connector, contact Srihari at srihakum@in.ibm.com.