Overview

PostgreSQL can either be used as a data source or a data destination in Mitto. Mitto's own internal database is PostgreSQL.

Source plugin example: Query

Destination plugin examples: CSV, Salesforce, SQL

PostgreSQL as a data destination

  • Mitto automatically creates the PostgreSQL database schema if it doesn't exist
  • Mitto automatically creates the PostgreSQL database tables if they don't exist
  • Mitto automatically determines data types for PostgreSQL columns
  • Mitto automatically adds new columns to PostgreSQL tables based on new fields in source systems
  • Mitto automatically adjusts PostgreSQL tables based on changes in source data

PostgreSQL specific setup

Below is the database url structure for connecting to a PostgreSQL database:

postgresql://<username>:<password>@<hostname>/<database>

When using Mitto's internal PostgreSQL database as a destination, the database url structure is:

postgresql://localhost/analytics

Here's an example of using a PostgreSQL database as a destination in a CSV job:

NOTE: When outputting to a PostgreSQL database, leaving the "Schema" blank will create a table in the public schema.

SQL

Mitto can send SQL statements to a PostgreSQL database. Use PostgreSQL syntax in these Mitto SQL jobs.