Connecting a PostgreSQL and MySQL database to Simpu

Connecting a PostgreSQL and MySQL database to Simpu

Welcome to Simpu's help guide on how to connect your PostgreSQL and MySQL databases. This article will provide you with step-by-step instructions on how to establish a connection between your databases and Simpu, enabling you to leverage your data within Simpu.


Before we begin, make sure you have the following prerequisites in place:

1. Access to a PostgreSQL and MySQL database.

2. Simpu account credentials.

Now, let's get started with the setup process:

Step 1: Set Up PostgreSQL Connection

  • Log in to Simpu, and go to Data

  • On the Left Navigation bar, click on Connections

  • Click on the Connect a data source button

  • Select "PostgreSQL" as the database.

    Fill in the required connection details:

- Give your connection a Unique name

-Host: Enter the hostname or IP address of your PostgreSQL server.

- Port: Specify the port number.

- Database: Provide the name of your PostgreSQL database.

- Username: Enter your PostgreSQL username.

- Password: Provide your PostgreSQL password.

  • Click "Test Connection" to ensure Simpu can connect to your PostgreSQL database successfully.

  • Once the connection is verified, click "Connect data source" to import the table from PostgreSQL.

Step 2: Set Up MySQL Connection

  • Log in to Simpu, and go to Data

  • On the Left Navigation bar, click on Connections

  • Click on the Connect a data source button

  • Select "MySQL" as the database.

    Enter the required connection details:

- Host: Specify the hostname or IP address of your MySQL server.

- Port: Provide the port number.

- Database: Enter the name of your MySQL database.

- Username: Provide your MySQL username.

- Password: Enter your MySQL password.

  • Click "Test Connection" to verify the connectivity between Simpu and your MySQL database.

  • Once the connection is successfully tested, click "Connect data source" to import the MySQL table into Simpu.

Step 3: Utilizing the Simpu Features

Now that you have connected your PostgreSQL and MySQL databases to Simpu, you can start leveraging Simpu's Marketing features with your data.

1. Navigate to the Data where you imported your tables.

2. Add a new list, customize data models, create Segments, and apply filters to organize and analyze your data.

3. Explore Simpu's integrations and automations to streamline workflows and enhance productivity.

Congratulations! You have successfully connected your PostgreSQL and MySQL databases to Simpu, empowering you to utilize Simpu's Marketing capabilities with your data.

    • Related Articles

    • Connecting an email forwarding channel in Simpu inbox

      Overview Simpu Inbox allows you to streamline your email communications by consolidating multiple email addresses into one unified platform. This guide will walk you through connecting an email forwarding channel in Simpu, enabling you to receive and ...
    • Connecting Gmail account to Simpu inbox

      Overview By linking your Gmail account to Simpu, you can seamlessly access and manage your Gmail emails directly within the Simpu platform. A Gmail account is a password-protected email account that you or your team can access. Instructions Step 1 ...
    • How to connect Messenger on Simpu

      Overview Enhance your communication experience by effortlessly connecting your Facebook Messenger account to Simpu. Streamline direct messaging in a professional manner without the need to switch between channels. Embrace the efficiency and ...
    • Simpu fundamentals

      Overview Welcome to Simpu 101! This help guide is designed to provide you with all the necessary information and guidance to start with Simpu. Whether you're new to the platform or just looking to improve your knowledge, this guide will walk you ...
    • Simpu's guide

      Overview Welcome to Simpu! Whether you're considering signing up for a Simpu trial or already have, we're here to guide you through getting started. What is Simpu? Simpu is a collaborative tool, a shared inbox solution for teams. It is designed to ...