Skip to main content

​
Connector Overview

Mangrove offers pre-built data connectors for common database systems. Once activated, connectors automatically sync data from your external systems into your project.
  • The connectors authenticate and fetch data from the database on a scheduled cadence. This is set to a daily schedule of 11:59pm ET; we plan on making the cadence configurable soon.
  • Data is fetched from a set cursor value - this allows only the latest data to be pulled into Mangrove
  • SQL queries are run to fetch the data in CSV format

​
Available Connectors

  • Microsoft SQL Server
  • Snowflake
  • Snowflake (Secure Share)
Don’t see your database? Contact the Mangrove team to discuss additional connector options.

​
Activate a Connector

Before you begin You will need:
  • Database connection details (host, port, database name)
  • Database credentials (username and password)
  • The event type(s) you want to transform the database data into in Mangrove

​
Adding a new Data Feed

1

Add connector credentials

In your project, go to Data Inputs > Input Settings. Click Add Data Feed and select your database type.

Enter your database connection details (host, port, database name, username, password), then click Test Connection to verify access.
Mangrove connects directly to your database. Check that your firewall allows connections from Mangrove’s IPs. Contact support for the current allowlist.
2

Add the SQL pre-query and query

Add the SQL query, and test it to preview the results. You can also add a pre-query to retrieve the right tables for selecting data.

Ensure you have set:
  • the cursor field
  • a starting cursor value if available

​
Troubleshooting

ErrorPossible CauseSolution
Connection refusedFirewall blocking MangroveAdd Mangrove IPs to your allowlist
Authentication failedInvalid credentialsVerify username and password
Database not foundIncorrect database nameCheck the database name spelling
TimeoutNetwork latency or database overloadCheck database performance
  • Verify the source table contains data
  • Check that field mappings are correctly configured
  • Ensure the database user has SELECT permissions on the mapped tables
  • Check if multiple connectors are pointing to the same table
  • Verify the sync schedule isn’t running too frequently

​
Managing Connectors

You can update the credentials for the connector in the Input Settings > Data Feed, then click Edit beside the SQL source to modify connection details.