RDS

Connect your database with Humanic

Looking to link your segment data with Humanic? You can have it up and running in a few minutes!

Humanic supports only MySQL and PostgreSQL databases for Amazon RDS integration.

Prerequisites

Before starting the integration, ensure you have the following database credentials ready:

• Database Engine: Choose either Postgres or MySQL.

• Database Host: The endpoint address of your RDS instance.

• Database Port: The port number (default is 5432 for Postgres and 3306 for MySQL).

• Database Name: The name of your database.

• Database User: The username with access privileges.

• Database Password: The corresponding password.

You can follow the Amazon RDS Documentation to obtain these details.

Access Data Integrations

1. In the Humanic Dashboard, click on the left sidebar link labeled Data Management to open the Data Integrations page

Select Amazon RDS from Supported Integrations

1. On the Data Integrations page, you'll see various data integrations supported by Humanic

2. Look for the "User Activity" category and click on it

3. From the list of supported data warehouses, select "Amazon RDS" by clicking on its card

Provide Connection Details:

After clicking the BigQuery card, you'll be prompted to enter the following information:

• Database Engine: Select either Postgres or MySQL.

• Database Host: Enter the endpoint address of your RDS instance.

• Database Port: Enter the port number (default is 5432 for Postgres and 3306 for MySQL).

• Database Name: Enter the name of your database.

• Database User: Enter the username.

• Database Password: Enter the password.

Ensure that your database is publicly accessible or at least accessible from Humanic's servers at IP 44.241.14.240. If you need step-by-step guidance for configuring your Amazon RDS for external access, Click here for detailed instructions.

Complete the Integration

1. Double-check that all the provided details are correct

2. Click on the CONNECT button to initiate the integration process

Hovering over each connected integration's card will show you the last time the data was synced.

Next Steps

Humanic will notify you via email once the initial data sync is complete.

Once the connection is established:

• Access Data: You can view and manage your synced Amazon RDS data via Humanic Data Management.

• Create Milestones: Use the synced data to create and track milestones and cohorts.

• Regular Syncing: Humanic ensures your data is always up-to-date through regular syncing.