Identify your version

Heroku updates

Heroku version history

All versions for Stitch's Heroku integration, including release and deprecation dates.

Version Status Release Deprecation End of life (Sunset)
version 1 (latest) Released July 31, 2018
version 15-10-2015 Sunset October 15, 2015 September 6, 2019 December 1, 2019

Heroku changelog

The five most recent updates made to the Heroku integration. Refer to the PostgreSQL Integration Changelog for this integration's full history.

Date Type Entry title
Jul 8, 2021 New feature PostgreSQL (v2) update: Google CloudSQL PostgreSQL now available!
Jun 2, 2021 New feature PostgreSQL (v2) update: Leaving beta!
Apr 19, 2021 Removed PostgreSQL (HP) (v2) integration: Removed support for Composite, Range and OID types
Mar 30, 2021 Updated feature PostgreSQL (v2) update: Key-based Incremental Replication now available!
Mar 24, 2021 New feature New feature: Integration changelogs
View all entries in the PostgreSQL Integration Changelog

Heroku version features

In this section:

Heroku version comparison

Heroku
version 1
STITCH
Release status

Released on July 31, 2018
Supported by

Stitch
Stitch plan

Standard
Supported versions

9.3+
API availability

Available
Singer GitHub repository

singer-io/tap-postgres
CONNECTION METHODS
SSH connections

Unsupported
SSL connections

Supported
REPLICATION SETTINGS
Anchor Scheduling

Supported
Advanced Scheduling

Supported
Table-level reset

Supported
Configurable Replication Methods

Supported
REPLICATION METHODS
Log-based Replication

Unsupported
Key-based Replication

Supported
Full Table Replication

Supported
DATA SELECTION
Table selection

Supported
Column selection

Supported
View replication

Supported
Select all

Unsupported
TRANSPARENCY
Extraction Logs

Supported
Loading Reports

Supported

Data types

In the table below are the data types Heroku integrations support and the Stitch data type it will map to, depending on the version of the integration being used:

  • indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
  • indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
  • indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
  • indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.

Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.

Note: This table doesn't display info for versions that have been sunset.

Heroku
version 1
ARRAY ARRAY
BIGINT INTEGER
BIGSERIAL INTEGER
BIT BOOLEAN
BIT VARYING
BOX
BYTEA
CHAR STRING
CIDR STRING
CIRCLE
CITEXT STRING
COMPOSITE
DATE STRING , formatted as DATE-TIME
DECIMAL NUMBER
DOUBLE NUMBER
FLOAT NUMBER
HSTORE OBJECT
INET STRING
INTEGER INTEGER
INTERVAL
IP STRING
JSON STRING
JSONB STRING
LINE
LONGNVARCHAR STRING
LONGVARCHAR STRING
LSEG
MACADDR STRING
MONEY STRING
NCHAR STRING
NUMERIC NUMBER
NVARCHAR STRING
OID
PATH
PG_LSN
POINT
POLYGON
RANGE
REAL NUMBER
REGCLASS
REGCONFIG
REGDICTIONARY
REGOPER
REGOPERATOR
REGPROC
REGPROCEDURE
REGTYPE
SERIAL INTEGER
SMALLINT INTEGER
SMALLSERIAL INTEGER
TIME STRING
TIMESTAMP STRING , formatted as DATE-TIME
TINYINT INTEGER
TSQUERY
TSVECTOR
TXID_SNAPSHOT
UUID STRING
VARCHAR STRING
XML
Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.