This documentation describes a release under development. Documentation for the latest release, 3.6.2, can be found here.

PostgreSQL

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

../_images/postgresql__connection.png

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://mitto:<password>@db/analytics

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

CSV to Postgres

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.