Search

Welcome to Datagrid
Welcome to Datagrid
Azure PostgreSQL Database

Azure PostgreSQL Database

Azure Database for PostgreSQL is a fully managed database service that allows you to set up, manage, and scale PostgreSQL databases in the cloud. By connecting Azure PostgreSQL Database to Datagrid, you can seamlessly integrate your database information with other business-critical data, enabling enhanced reporting, analytics, and decision-making.

1. How-to

1. Prerequisites

To configure the Azure PostgreSQL Database connector, follow these steps:

  • An active Azure account with the necessary permissions to access Azure PostgreSQL Database.
  • Azure PostgreSQL Database server details, including server name, database name, username, and password.
  • Ensure that your Azure PostgreSQL Database server allows connections from Datagrid's IP addresses. You may need to configure the firewall rules accordingly.
  • Select the data you want to import into Datagrid

2. Connect

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

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

3. Set Up a Schedule:

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

  1. Navigate to Azure PostgreSQL Database Dataset: a. Go to the left side panel and locate and click on the Azure PostgreSQL Database 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.

4. Data Access

  • Object
    • Server
    • Configuration
    • Database
    • Firewall Rules
    • Log Files
    • Operations

5. Use Cases

  • AI-Powered Applications: Leverage the in-database AI integration with native vector search and the Azure AI extension to build generative AI applications.
  • Enterprise Performance: Utilize a fully managed PostgreSQL database with up to 99.99% uptime and high availability for application innovation.
  • Open-Source Database Development: Build applications using your favorite PostgreSQL extensions, popular frameworks, and languages, with support for the latest versions.
  • Cost Optimization: Reduce total cost of ownership through simplified infrastructure, management, deployment, and operations.
  • Web and Mobile Applications: Build engaging, performant, and scalable cross-platform and native apps for iOS, Android, Windows, or Mac.
  • Geospatial Data Analytics: Explore a manageable solution for making large volumes of geospatial data available for analytics.

6. FAQ

Q: What is the service-level agreement (SLA)? A: Read the Azure SLA.

Q: How does Microsoft contribute to the PostgreSQL cloud open-source community? A: Microsoft works with and directly contributes extensions to the open-source community. Read the Microsoft Open Source blog.

Q: Where is Azure Database for PostgreSQL available? A: Azure Database for PostgreSQL is available in more than 30 Azure regions in the Americas, Europe, and Asia Pacific.

7. Support & Additional Resources