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.
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:
22.214.171.124. 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.
Linuxuser for Commerce Intelligence
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.
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.
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
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:
Portfield. This info can also be found in the setup documentation for the database.
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: