Data Integrations

Connect to the tools you already use

Your data lives in databases, SaaS apps, spreadsheets, and APIs. OpenLakes brings it all together so you can analyze everything in one place.

500+ data sources available

Real-time sync Live

Changes in your source database appear in OpenLakes within seconds. Perfect for operational dashboards, fraud detection, and keeping analytics fresh.

Powered by Debezium CDC

Scheduled imports Batch

Pull data from 500+ sources on a schedule that works for you. Ideal for SaaS apps, APIs, and historical data loads.

Powered by Meltano + Singer

PostgreSQLCDC

Database

MySQLCDC

Database

MariaDBCDC

Database

MongoDBCDC

Database

SQL ServerCDC

Database

OracleCDC

Database

IBM Db2CDC

Database

VitessCDC

Database

CassandraCDC

Database

Cloud SpannerCDC

Database

IBM InformixCDC

Database

JDBC (Any SQL)CDC

Database

SnowflakeBatch

Databasetap-snowflake

BigQueryBatch

Databasetap-bigquery

RedshiftBatch

Databasetap-redshift

ClickHouseBatch

Databasetap-clickhouse

DuckDBBatch

Databasetap-duckdb

DynamoDBBatch

Databasetap-dynamodb

ElasticsearchBatch

Databasetap-elasticsearch

CockroachDBBatch

Databasetap-cockroachdb

TiDBBatch

Databasetap-tidb

AirtableBatch

Databasetap-airtable

FaunaBatch

Databasetap-fauna

SybaseBatch

Databasetap-sybase

YugabyteDBBatch

Databasevia tap-postgres

NeonBatch

Databasevia tap-postgres

SupabaseBatch

Databasevia tap-postgres

TimescaleDBBatch

Databasevia tap-postgres

GreenplumBatch

Databasevia tap-postgres

SingleStoreBatch

Databasevia tap-mysql

PlanetScaleBatch

Databasevia tap-mysql

DatabricksBatch

Databasevia JDBC

VerticaBatch

Databasevia JDBC

TeradataBatch

Databasevia JDBC

ExasolBatch

Databasevia JDBC

SAP HANABatch

Databasevia JDBC

FirebirdBatch

Databasevia JDBC

Apache DruidBatch

Databasevia JDBC

Apache PinotBatch

Databasevia JDBC

QuestDBBatch

Databasevia tap-postgres

OpenSearchBatch

Databasevia REST API

CouchbaseBatch

Databasevia REST API

CouchDBBatch

Databasevia REST API

FirebaseBatch

Databasevia REST API

InfluxDBBatch

Databasevia REST API

Neo4jBatch

Databasevia REST API

RedisBatch

Databasevia REST API

SalesforceBatch

CRM

HubSpotBatch

CRM

PipedriveBatch

CRM

Zoho CRMBatch

CRM

Dynamics 365Batch

CRM

CloseBatch

CRM

CopperBatch

CRM

FreshsalesBatch

CRM

InsightlyBatch

CRM

NimbleBatch

CRM

NutshellBatch

CRM

StreakBatch

CRM

Agile CRMBatch

CRM

CapsuleBatch

CRM

SalesflareBatch

CRM

OutreachBatch

Sales

SalesLoftBatch

Sales

ApolloBatch

Sales

ZoomInfoBatch

Sales

ClearbitBatch

Sales

GongBatch

Sales

ChorusBatch

Sales

ClariBatch

Sales

LinkedIn Sales NavBatch

Sales

ZendeskBatch

Support

IntercomBatch

Support

FreshdeskBatch

Support

Help ScoutBatch

Support

FrontBatch

Support

KustomerBatch

Support

FreshchatBatch

Support

DriftBatch

Support

CrispBatch

Support

TidioBatch

Support

LiveChatBatch

Support

Tawk.toBatch

Support

ServiceNowBatch

Support

Jira Service MgmtBatch

Support

FreshserviceBatch

Support

DelightedBatch

Feedback

TypeformBatch

Feedback

SurveyMonkeyBatch

Feedback

StripeBatch

Payments

ShopifyBatch

E-commerce

WooCommerceBatch

E-commerce

BigCommerceBatch

E-commerce

MagentoBatch

E-commerce

PrestaShopBatch

E-commerce

SquareBatch

Payments

PayPalBatch

Payments

BraintreeBatch

Payments

AdyenBatch

Payments

KlarnaBatch

Payments

AfterpayBatch

Payments

ChargebeeBatch

Billing

RecurlyBatch

Billing

ChargifyBatch

Billing

ZuoraBatch

Billing

PaddleBatch

Billing

Lemon SqueezyBatch

Billing

RechargeBatch

Billing

Amazon SellerBatch

E-commerce

eBayBatch

E-commerce

EtsyBatch

E-commerce

WalmartBatch

E-commerce

QuickBooksBatch

Accounting

XeroBatch

Accounting

FreshBooksBatch

Accounting

WaveBatch

Accounting

SageBatch

Accounting

NetSuiteBatch

ERP

SAPBatch

ERP

Bill.comBatch

Finance

ExpensifyBatch

Finance

BrexBatch

Finance

RampBatch

Finance

PlaidBatch

Finance

HarvestBatch

Finance

TogglBatch

Finance

Google AnalyticsBatch

Analytics

Google AdsBatch

Ads

Search ConsoleBatch

SEO

Facebook AdsBatch

Ads

InstagramBatch

Social

LinkedIn AdsBatch

Ads

Twitter/X AdsBatch

Ads

TikTok AdsBatch

Ads

Pinterest AdsBatch

Ads

Snapchat AdsBatch

Ads

Reddit AdsBatch

Ads

Bing AdsBatch

Ads

Amazon AdsBatch

Ads

CriteoBatch

Ads

MailchimpBatch

Email

SendGridBatch

Email

KlaviyoBatch

Email

BrazeBatch

Engagement

IterableBatch

Email

Customer.ioBatch

Email

ActiveCampaignBatch

Email

ConvertKitBatch

Email

DripBatch

Email

MailerLiteBatch

Email

BrevoBatch

Email

Constant ContactBatch

Email

MixpanelBatch

Analytics

AmplitudeBatch

Analytics

HeapBatch

Analytics

PendoBatch

Analytics

FullStoryBatch

Analytics

HotjarBatch

Analytics

PostHogBatch

Analytics

SegmentBatch

CDP

RudderStackBatch

CDP

mParticleBatch

CDP

AppsFlyerBatch

Mobile

AdjustBatch

Mobile

BranchBatch

Mobile

SingularBatch

Mobile

GitHubBatch

Engineering

GitLabBatch

Engineering

BitbucketBatch

Engineering

JiraBatch

Project Mgmt

LinearBatch

Project Mgmt

ShortcutBatch

Project Mgmt

AsanaBatch

Project Mgmt

TrelloBatch

Project Mgmt

Monday.comBatch

Project Mgmt

ClickUpBatch

Project Mgmt

BasecampBatch

Project Mgmt

WrikeBatch

Project Mgmt

SmartsheetBatch

Project Mgmt

NotionBatch

Workspace

ConfluenceBatch

Workspace

CodaBatch

Workspace

SlackBatch

Communication

MS TeamsBatch

Communication

DiscordBatch

Communication

ZoomBatch

Communication

CalendlyBatch

Communication

SentryBatch

DevOps

DatadogBatch

DevOps

New RelicBatch

DevOps

SplunkBatch

DevOps

PagerDutyBatch

DevOps

OpsgenieBatch

DevOps

StatuspageBatch

DevOps

CircleCIBatch

DevOps

JenkinsBatch

DevOps

BuildkiteBatch

DevOps

GitHub ActionsBatch

DevOps

LaunchDarklyBatch

DevOps

LeverBatch

HR

GreenhouseBatch

HR

WorkdayBatch

HR

BambooHRBatch

HR

GustoBatch

HR

RipplingBatch

HR

DeelBatch

HR

RemoteBatch

HR

JustworksBatch

HR

NamelyBatch

HR

PaychexBatch

HR

ADPBatch

HR

AshbyBatch

HR

WorkableBatch

HR

Breezy HRBatch

HR

PersonioBatch

HR

LatticeBatch

HR

15FiveBatch

HR

Culture AmpBatch

HR

TwilioBatch

Communications

VonageBatch

Communications

MessageBirdBatch

Communications

PlivoBatch

Communications

BandwidthBatch

Communications

AircallBatch

Communications

DialpadBatch

Communications

RingCentralBatch

Communications

CSV FilesBatch

Files

ExcelBatch

Files

JSONBatch

Files

JSONLBatch

Files

ParquetBatch

Files

AvroBatch

Files

ORCBatch

Files

XMLBatch

Files

YAMLBatch

Files

TSVBatch

Files

PDFBatch

Files

Amazon S3Batch

Storage

Google Cloud StorageBatch

Storage

Azure BlobBatch

Storage

MinIOBatch

Storage

WasabiBatch

Storage

Backblaze B2Batch

Storage

DigitalOcean SpacesBatch

Storage

Cloudflare R2Batch

Storage

SFTP / FTPBatch

Transfer

Google DriveBatch

Storage

Google SheetsBatch

Spreadsheets

DropboxBatch

Storage

BoxBatch

Storage

OneDriveBatch

Storage

SharePointBatch

Storage

HDFSBatch

Storage

Local FilesBatch

Files

REST APIsBatch

Generic

GraphQLBatch

Generic

SOAP APIsBatch

Generic

gRPCBatch

Generic

ODataBatch

Generic

WebhooksBatch

Events

Apache KafkaStreaming

Streaming

Confluent CloudStreaming

Streaming

Amazon KinesisStreaming

Streaming

Google Pub/SubStreaming

Streaming

Azure Event HubsStreaming

Streaming

RabbitMQStreaming

Streaming

Apache PulsarStreaming

Streaming

NATSStreaming

Streaming

RedpandaStreaming

Streaming

Amazon SQSBatch

Queue

MQTTStreaming

IoT

DocuSignBatch

Legal

PandaDocBatch

Legal

HelloSignBatch

Legal

ProductboardBatch

Product

Aha!Batch

Product

FigmaBatch

Design

MiroBatch

Design

LoomBatch

Video

YouTubeBatch

Video

VimeoBatch

Video

WistiaBatch

Video

ChargePointBatch

IoT

Weather APIBatch

Data

OpenWeatherBatch

Data

Exchange RatesBatch

Data

Alpha VantageBatch

Finance

Polygon.ioBatch

Finance

CoinbaseBatch

Crypto

BinanceBatch

Crypto

CoinGeckoBatch

Crypto

Twitter/XBatch

Social

FacebookBatch

Social

LinkedInBatch

Social

SpotifyBatch

Media

Apple MusicBatch

Media

StravaBatch

Fitness

FitbitBatch

Fitness

OuraBatch

Fitness

ContentfulBatch

CMS

SanityBatch

CMS

StrapiBatch

CMS

WordPressBatch

CMS

GhostBatch

CMS

WebflowBatch

CMS

SquarespaceBatch

CMS

WixBatch

CMS

Auth0Batch

Security

OktaBatch

Security

OneLoginBatch

Security

1PasswordBatch

Security

AWS CloudWatchBatch

Cloud

AWS Cost ExplorerBatch

Cloud

GCPBatch

Cloud

AzureBatch

Cloud

HerokuBatch

Cloud

VercelBatch

Cloud

NetlifyBatch

Cloud

RenderBatch

Cloud

RailwayBatch

Cloud

Fly.ioBatch

Cloud

Don't see your data source? We support any REST API, GraphQL endpoint, or custom connector.

Request a new integration →

How it works

Get your data flowing in minutes, not months.

1. Choose your source

Search our catalog of 500+ data sources. Whether it's a production database, a SaaS app, or files in cloud storage, we've got you covered.

2. Enter credentials

Provide read-only access to your data source. OpenLakes never modifies your source systems. All credentials are encrypted at rest.

3. Set your schedule

Choose real-time sync for databases or set a schedule that works for batch sources. Daily, hourly, or custom cron expressions.

4. Query in SQL

Your data lands in Apache Iceberg tables. Query it with Trino, transform it with Spark, or visualize it in Superset. All from one platform.

Start connecting your data

Try OpenLakes Harbor free for 30 days. No credit card required. Set up your first data pipeline in under 10 minutes.

Start free trial Read the docs