Connect Amazon RDS

Amazon Relational Database Services (RDS) is a managed database service that runs on database engines that you are probably already familiar with:

The steps for connecting your RDS instance vary, depending on the type of database you are using and whether you are using an encrypted connection (like an SSH tunnel for MySQL), but here are the basics.

Authorize Commerce Intelligence to access your database

On the credentials page (Manage Data > Integrations) for each database, you see a box containing the IP addresses you must authorize to connect RRDS to Commerce Intelligence: and Here is a look at the MySQL credentials page, where you highlighted the IP address box:

For Commerce Intelligence to successfully connect with your RDS instance, you must add these IP addresses to the appropriate database security group via the AWS management console. These IP addresses can be added to an existing group or you can create a one - the important thing is that the group is authorized to access the instance you want to connect to Commerce Intelligence.

When adding the Commerce Intelligence IP addresses, make sure you add a /32 to the end of the address to indicate to Amazon that it is an exact IP address. Do not worry; the AWS interface makes it clear that this is required.

Create a Linux user for Commerce Intelligence linux

This step is only required if you are using an encrypted connection. For instructions on how to do this, refer to the setup topic for the database you are using (ex: MySQL). The Linux user allows us to create an SSH tunnel, which is the safest method of sending data over the internet.

Create a database user for Commerce Intelligence

This is the part of the process where, depending on the database you are using, the steps vary. The idea is the same, though, you create a user for Commerce Intelligence which is used to access your database. Instructions for creating a database Commerce Intelligence user can be found in the setup topic for the database you are using.

Enter connection info into Commerce Intelligence

After you have granted Commerce Intelligence access to your instance and created a user for us, the last thing you need to do is enter the connection info into Commerce Intelligence.

The credential pages for MySQL, Microsoft SQL, and PostgreSQL are accessed via the Integrations page (Manage Data > Integrations) by clicking Add Integration. When the list of integrations displays, click the icon for the database you are using to go to the credentials page. If you do not currently have access to the integration you need, contact your Adobe Account Team.

To finish creating the connection, you need the following info:

  • The public address of your RDS instance: This can be found in the AWS management console.
  • The port your database instance uses: Some databases have a default port, which automatically populates the Port field. This info can also be found in the setup documentation for the database.
  • The username and password of the user you created for Commerce Intelligence.

If you are using an encrypted connection, change the Encrypted toggle on the database credentials page to Yes. This displays an extra form for setting up the encryption: