Having trouble connecting your database or SaaS integration? Investigating a data discrepancy? Here you’ll find resources for some of the most common causes of connection troubles and data discrepancies related to integrations.
Common Integration Issues
If you’ve having having connection issues with an integration, the root cause may be an improperly configured firewall or incorrect port setting.
Occasionally, some integrations used by Stitch may encounter bugs or other issues. Whenever we’ve identified a third-party issue - meaning on the integration provider’s end - we’ll post an update here.
If you see a message that asks you to re-authorize an integration, it means that Stitch’s permissions to that service have been revoked.
From time to time, some of the applications and databases we integrate with may experience downtime. During these outages, Stitch may be unable to successfully connect to your data source and replicate your data.
Stitch periodically performs checks on the connection to your database to ensure the connection remains active and healthy. In this article are some of the most common errors you might see if Stitch has trouble performing the connection check to your database and how to resolve them.
Missing some Mongo data? The root cause may be multiple data types in the Replication Key field and how Mongo sorts data based on data type.
If you don’t see all the fields you expect to in the Replication Key field for you Mongo integration, the root cause may be insufficient permissions or a lack of field indexing.
If you’ve noticed that some MySQL
TINYINT(1) columns are displaying as
BIT in Stitch, it’s usually due to how the MySQL driver converts this data type.
When certain Postgres data types are replicated, they’ll be stored as
strings in your data warehouse.
If you’ve noticed some missing data from your Segment integration, the culprit might be the selective integration snippet on your website.
If you’ve noticed some out-of-date Salesforce data in your data warehouse, the root cause may be a formula field.