How to integrate data into PostgreSQL with Windsor.ai

PostgreSQL is a powerful, open-source relational database management system used for storing, organizing, and retrieving data. Renowned for its reliability, scalability, and advanced features, PostgreSQL supports a wide range of applications, from powering e-commerce platforms to geospatial mapping with extensions like PostGIS.

By integrating PostgreSQL with Windsor.ai, you can streamline your data analytics process and enable seamless access to your database for advanced reporting and decision-making. 

Explore our video tutorial and a step-by-step guide to automatically integrate your data into PostgreSQL with the Windsor.ai no-code ELT connector.

1. Create a Windsor.ai account and log in.

2. Select the data source which you want to stream data from, e.g., Google Analytics 4 (GA4). Sign in with your associated Google account and select the next step, “Data preview.”

3. You’ll see your Google Analytics 4 data displayed in your Windsor.ai account. 

4. Scroll down to data destinations and select “PostgreSQL.”

5. Click “Add Destination Task.”

6. If you need to access the database on your cloud or hosting platform, you must add the Windsor IP address (provided in the bottom instructions section) to your firewall rules.

7. Enter all the required credentials in the destination task:

• Task name (you can provide any, based on the data integration purpose).
• User name, host, server, port, password, and database name of your PostgreSQL database.
• Table name (you can provide any, based on the data integration purpose); it will be created in your database automatically. If you already have a table for your Google Analytics data, you can enter that table name.

Click “Test Connection.” 

If the connection is set properly, you’ll see a success message at the bottom; otherwise, an error message will appear. When successful, click “Save” in the lower right corner of the form. The data stream to the PostgreSQL database has started.

8. You can now see the task running in the selected data destination section. The green ‘upload‘ button with the status ‘ok‘ indicates that the task is active and running successfully.

9. Verify that your data is being added to the PostgreSQL database by connecting to it locally using Table Plus. You should see the newly created table with the synched data. 

Congratulations, your Google Analytics 4 data is now integrated into PostgreSQL and ready for in-depth analysis.