Heroku PostgreSQL

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 integration you want to check.
3. Click the Extraction Logs tab:
• If you see a list of extraction logs, the integration's version is v1.0.
• If you see No logs available for this integration yet., the integration's version is v15-10-2015.

• version 1.0 (latest)
  Setup | Replication
• version 15-10-2015
  Setup | Replication

---

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.

• Overview
• Changelog

---

Heroku version features

In this section:

• Supported features

• Data types

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
Advanced 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

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.

	Heroku version 1.0 (latest)	Heroku version 15-10-2015
ARRAY	ARRAY	STRING
BIGINT	INTEGER	INTEGER
BIT	BOOLEAN	BOOLEAN
CHAR	STRING	STRING
CIDR	STRING	UNSUPPORTED
CITEXT	STRING	UNSUPPORTED
DATE	STRING , formatted as DATE-TIME	STRING , formatted as DATE-TIME
DECIMAL	NUMBER	NUMBER
DOUBLE	NUMBER	NUMBER
FLOAT	NUMBER	NUMBER
HSTORE	OBJECT	STRING
INET	STRING	STRING
INTEGER	INTEGER	INTEGER
IP	STRING	UNSUPPORTED
JSON	ARRAY	STRING
JSONB	ARRAY	STRING
LONGNVARCHAR	STRING	STRING
LONGVARCHAR	STRING	STRING
MACADDR	STRING	UNSUPPORTED
MONEY	STRING	UNSUPPORTED
NCHAR	STRING	STRING
NUMERIC	NUMBER	NUMBER
NVARCHAR	STRING	STRING
REAL	NUMBER	NUMBER
SMALLINT	INTEGER	INTEGER
TIME	STRING , formatted as DATE-TIME	STRING , formatted as DATE-TIME
TIMESTAMP	STRING , formatted as DATE-TIME	STRING , formatted as DATE-TIME
TINYINT	INTEGER	INTEGER
UUID	STRING	STRING
VARCHAR	STRING	STRING

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Replication Methods Replication Keys	PostgreSQL Data Types Stored as Strings PostgreSQL Read Replicas and Slow Replication Database Connection Errors Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues

---

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.