Identify your version

To identify the version of the Heroku integration you're using:

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard, click the Heroku you want to check.
  3. Click the Extraction Logs tab:
    • If you see a list of extraction logs, the integration's version is 1.0.
    • If you see No logs available for this integration yet., the integration's version is 15-10-2015.

Heroku version history

In this section:

  • Overview - All versions for Stitch's Heroku integration, including release and deprecation dates.
  • Changelog - Details about updates to Stitch's Heroku integration, including new/deprecated versions, schema changes, new data availability, etc.
Version Release date Deprecation date
version 1.0 (latest) July 31, 2018 n/a
version 15-10-2015 October 15, 2015 To be determined
Date Version Release notes
July 31, 2018 1.0

New integration version (1.0)

Version 1.0 of Singer's PostgreSQL tap, which backs Stitch's Heroku integration, has been released.

Highlights include:

  • Additional data type support
  • Support for logical replication
  • Support for Extraction Logs, Loading Reports, and Anchor Scheduling

Heroku version features

In this section:

Heroku supported features

Heroku
version 1.0 (latest) 		Heroku
version 15-10-2015
CONNECTION METHODS
SSH Connections Unsupported Unsupported
SSL Connections Supported Supported
REPLICATION SETTINGS
Anchor Scheduling Supported Unsupported
Table-level Reset Supported Supported
Configurable Replication Methods Supported Supported
REPLICATION METHODS
Log-based Replication Unsupported Unsupported
Key-based Replication Supported Supported
Full Table Replication Supported Supported
DATA SELECTION
Table Selection Supported Supported
Column Selection Supported Supported
View Replication Supported Supported
TRANSPARENCY
Extraction Logs Supported Unsupported
Loading Reports Supported Supported

Heroku supported data types

Heroku integrations support the data types in the table below, in addition to the common data types.

In the table are the data types and how they'll be stored in your destination, depending on the version of the integration being used:

  • marks supported data types. Following the icon is how Stitch will store the data type in the destination. For example: ARRAY data types will be stored as strings.
  • marks unsupported data types. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.
Heroku
version 1.0 (latest) 		Heroku
version 15-10-2015
COMMON DATA TYPES Supported Supported
ARRAY STRING STRING
CIDR STRING Unsupported
CITEXT STRING Unsupported
HSTORE Nested maps STRING
INET STRING Unsupported
IP STRING Unsupported
JSON STRING STRING
JSONB STRING STRING
MACADDR STRING Unsupported
MONEY STRING Unsupported
UUID STRING STRING
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.

Tags: database integrations