Search

Welcome to Datagrid
Welcome to Datagrid
PostgreSQL

PostgreSQL

The PostgreSQL connector allows you to seamlessly pull data from your PostgreSQL database into Datagrid. This integration enables you to leverage Datagrid's powerful data analysis and visualization tools with your PostgreSQL data, providing enhanced insights and reporting capabilities.

1. How-to

1. Prerequisites

To configure the PostgreSQL connector, follow these steps:

  • An active PostgreSQL database with the necessary permissions to access the tables and data you want to import into Datagrid.
  • Ensure you have the connection details for your PostgreSQL database, including the host, port, database name, username, and password.
  • Select the data you want to import into Datagrid.

2. Connect

Creating a dataset from the PostgreSQL connector involves selecting the specific data you want to import via PostgreSQL:

  1. Connect PostgreSQL App: a. Click on the "+ Create” Button on the top left of the screen. b. Select the "Connect Apps" item. c. Search for the PostgreSQL connector from the list. d. Enter your PostgreSQL database connection details, including the host, port, database name, username, and password. e. Click on the “Next” button.
  2. Pick your Data: a. Pick the PostgreSQL data you want to include in your dataset (e.g., tables, views, or custom queries). b. Click the “Start First Import” Button to start syncing your PostgreSQL dataset.

3. Set Up a Schedule

Scheduling regular data pulls ensures your Datagrid datasets remain up-to-date with the latest information from PostgreSQL:

  1. Navigate to PostgreSQL Dataset: a. Go to the left side panel and locate and click on the PostgreSQL dataset you created.
  2. Schedule Settings: a. Click on the “...” on the top right of the dataset. b. Click on “Edit Pipeline” to edit your connector's name. c. Click the “Schedule” button on the right, beside the “Import Configuration” button.
  3. Configure Schedule: a. Set the desired frequency for data pulls (e.g., daily, weekly, monthly). b. Specify the time of day for the data pull to occur. c. Specify downtime if needed – when the sync should not happen. d. Click the “Update” button to update the new configuration.

2. Data Access

  • Tables
  • Views
  • Custom Queries
  • Stored Procedures
  • Functions
  • Materialized Views
  • Sequences
  • Data Types
  • Schemas
  • Extensions

3. Use Cases

  • Business Intelligence: Connect PostgreSQL to Datagrid to create interactive dashboards and reports for monitoring key performance indicators (KPIs) and business metrics.
  • Data Warehousing: Use Datagrid to build a data warehouse by extracting, transforming, and loading (ETL) data from PostgreSQL into a centralized repository for analysis and reporting.
  • Real-time Analytics: Stream data from PostgreSQL into Datagrid for real-time analytics and monitoring of critical systems and applications.
  • Data Integration: Integrate PostgreSQL data with other data sources in Datagrid to create a unified view of your business data for analysis and decision-making.
  • Predictive Analytics: Use Datagrid's machine learning capabilities to build predictive models based on PostgreSQL data for forecasting, anomaly detection, and other advanced analytics use cases.

4. FAQ

Q: What types of data can I import from PostgreSQL into Datagrid?

  • A: You can import a wide range of data, including tables, views, custom queries, stored procedures, functions, materialized views, sequences, data types, schemas, and extensions.

Q: How often can I schedule data pulls from PostgreSQL?

  • A: You can schedule data pulls daily, weekly, or monthly, depending on your needs.

Q: What permissions are required to connect PostgreSQL to Datagrid?

  • A: You need an active PostgreSQL database with the necessary permissions to access the tables and data you want to import into Datagrid. Ensure you have the correct username, password, and connection details.

5. Support & Additional Resources