Setting up AWS MySQL Connection Setup in TIBCO Scribe® Online

Setting up AWS MySQL Connection Setup in TIBCO Scribe® Online

book

Article ID: KB0075706

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) 1

Description

When setting up a cloud-based MySQL Connection, make sure that TIBCO Scribe® Online has the appropriate access to gather the information from your Cloud database. This is standard for most Cloud-based products or database hosting systems.

Amazon Web Services (AWS) allows data to move back and forth through their Relational Database Service by setting up a Virtual Private Cloud (VPC) Security Group.

Issue/Introduction

How to setup an Amazon Web Service (AWS) Relational Database (RDS) connection to TIBCO Scribe® Online through the creating of a Virtual Private Cloud (VPC) Security Group.

Resolution

  1. Login into your AWS account with login credentials that allow you to make system administrative decisions.
 
kA30e000000bmA4CAI_en_US_1_0
 
  1. Select the Services drop-down menu in the top left corner of the browser.
  2. Scroll down to the Networking & Content Delivery cluster and select VPC.
 
kA30e000000bmA4CAI_en_US_1_1
 
  1. From the left menu in the Security section select Security Groups.
 
kA30e000000bmA4CAI_en_US_1_2
 
  1. If you do not have a security group, create one now. If you have a security group, either add the specific modifiers below or add this new security group to your original group.
 
kA30e000000bmA4CAI_en_US_1_3
 
  1. Select Create Security Group
  2. On the Create Security Group dialog, enter the following:
    • Name Tag - Name for this Security Group.
    • Group Name - Pre-populated field based on the Name Tag field.
    • Description - Description indicating what this security group allows. For example, “TIBCO IP Addresses for MySQL Inbound Permissions.”
    • VPC - Select the VPC instance where your RDS is running.
  3. Select the Yes, Create button.
 
kA30e000000bmA4CAI_en_US_1_4
 
  1. After the Security Group is created, select it.
  2. Navigate to the bottom of the screen and review the additional information about that group.
  3. Edit the Inbound Rules to allow TIBCO Scribe® Online to request information from your MySQL RDS instance.
 
kA30e000000bmA4CAI_en_US_1_5
 
  1. On the Inbound Rules tab, select Edit.  One row for an IP Address is added.
  2. Select the Add another rule button.
  3. When both rows are ready for input, enter the following:
  • Type - Select “Custom TCP Rule” for both rows.
  • Protocol - Do not modify for either row.
  • Port Range - Enter 3306 for both rows
  • Description - Enter SCRIBE ONLINE IP ADDR 1 and SCRIBE ONLINE IP ADDR 2 respectively.
  • Source - Enter the IP addresses that correspond to your Data Center, based on the Data Center table.  If you are not sure which Data Center is associated with your Organization, in TIBCO Scribe® Online select More > Edit Organization and check the Data Center field.
 
Data Center IP Addresses
US
52.6.65.166/32
52.21.2.156/32
Europe AWS
35.157.107.151/32
52.59.173.145/32
 
Note These are similar to the IP Addresses found within our training module. However,  AWS requires CIDR Compliant IP Addresses, which are not listed elsewhere. This specific case is for AWS VPC Security Groups Only.
 
  1. Select Save.
 
kA30e000000bmA4CAI_en_US_1_6
  1. In the top left corner select the Services drop-down menu.
  2. From the Database cluster, select RDS.
  3. Select Instances from the top left corner, under Dashboard to display your RDS instances.
  4. Select the instance of RDS where the Security Group should be added.
  5. Scroll down on the instance dashboard to the Details section and select Modify.
  6. Scroll down to the Network & Security section. 
  7. In the Choose security groups drop-down select the Security Group.
  8. Scroll to the bottom and select Continue.
 
kA30e000000bmA4CAI_en_US_1_7
 
  1. Double-check your modifications.
  2. Under Scheduling of Modifications select Apply immediately.
  3. Select Modify DB Instance.
Note that there may be a delay of several minutes before you can connect through TIBCO Scribe® Online.
  1. In TIBCO Scribe® Online, open the Connection dialog for the MySQL Connection and test the Connection.

IMPORTANT: Test the Connection using a Cloud Agent not an On-Premise Agent.