Integrations

What DataBridge connects to, and how.

DataBridge reads and writes databases, files, SFTP and FTP servers, cloud storage and APIs, and ships file layouts for accounting, CRM, EDI and ecommerce systems. This page says which connections exist and which do not. The free browser edition covers the file tools.

Start with EDI or ETL.

EDI

EDI integration for flat files

What DataBridge does with EDI today, which transaction sets have layouts, and what it does not do.

ETL

A lightweight ETL tool for SQL Server

Extract, transform, load and schedule, from files, databases and SFTP.

Support matrix

Connected, by system or format.

Modules and prices are on the pricing page. Every feature is listed on All features.

System or format	How DataBridge works with it	Needs	Guide
SQL Server	Database connection: saved queries, Data Sync, the SQL Server tools	Database	Guide for SQL Server
PostgreSQL, MySQL, SQLite	Database connection: saved queries and Data Sync	Database	Guide for PostgreSQL, MySQL, SQLite
ERPs and line-of-business systems on SQL Server	Through the database with SQL you write. No ERP-specific connector	Database	Guide for ERPs and line-of-business systems on SQL Server
Oracle	Not supported as a connection	None
CSV, TSV, Excel, custom delimiter files	File templates and mappings, read and write	Free, in every edition	Guide for CSV, TSV, Excel, custom delimiter files
Fixed-width files	Not supported	None
JSON	Output format, and what HTTP sources read from APIs	Free to download, Transfer to deliver	Guide for JSON
SFTP, FTP and FTPS	Sources and destinations	Transfer	Guide for SFTP, FTP and FTPS
Azure Blob Storage, Amazon S3 and S3-compatible stores	Sources and destinations	Transfer	Guide for Azure Blob Storage, Amazon S3 and S3-compatible stores
REST APIs over HTTP	Sources with paging, destinations with Basic, API key or OAuth2	Transfer	Guide for REST APIs over HTTP
Email	Destination through SMTP or Microsoft 365, with the file attached	Transfer
Folders and network shares	Sources and destinations	Transfer
EDI X12	Flat files from your translator, not raw X12	Marketplace	Guide for EDI X12
QuickBooks Desktop	IIF import files, not QuickBooks Online	Marketplace	Guide for QuickBooks Desktop
Sage 100	Visual Integrator CSV files	Marketplace	Guide for Sage 100
NetSuite	CSV Import Assistant files	Marketplace	Guide for NetSuite
Salesforce	Data Loader files	Marketplace	Guide for Salesforce
HubSpot	Import files	Marketplace	Guide for HubSpot
Dynamics 365	Import Wizard files	Marketplace	Guide for Dynamics 365
Shopify and Amazon	Product and order file layouts, no API calls	Marketplace	Guide for Shopify and Amazon
QuickBooks, Sage 100, NetSuite, Salesforce, HubSpot, Dynamics 365, Shopify and Amazon are trademarks of their respective owners. Names are used only to say which system a connection, layout or file is for. ExtensibilityCo is not affiliated with or endorsed by any of them.

ERP and databases

SQL Server to CSV file

SQL Server to CSV export automation

Export a SQL Server query to CSV on a schedule and deliver it to a folder, a file share, email or cloud storage, with retries and a run history.

PostgreSQL or MySQL to CSV, TSV or JSON file

PostgreSQL and MySQL to CSV and SFTP

Run read-only queries against PostgreSQL or MySQL on a schedule and deliver CSV, TSV or JSON to SFTP, email or cloud storage.

CSV on SFTP or a folder to SQL Server table

Import CSV into SQL Server automatically

Pick up a CSV from SFTP or a folder, validate every row, and load it into an existing SQL Server table with insert, update or replace.

Files and transfer

SFTP, FTP or FTPS server to SFTP server

SFTP to SFTP file transfer automation

Pick up files from an SFTP, FTP or FTPS server and deliver them to another SFTP server on a schedule, with pinned host keys and delivery records.

Azure Blob Storage or Amazon S3 to Azure Blob, S3 or any destination

Azure Blob and Amazon S3 file transfer

Read files from Azure Blob Storage or Amazon S3 and deliver files to either, including S3-compatible stores, on a schedule from your own server.

Excel (.xlsx) to CSV or TSV

Convert Excel to CSV in your browser, free

Convert an Excel workbook to CSV or TSV in your browser, with the columns, dates and whitespace cleaned. No install, no sign-in, no upload.

CSV, TSV or Excel to JSON

CSV to JSON converter, free and private

Turn a CSV, TSV or Excel file into JSON in your browser with a mapping you can save and reuse. Nothing is uploaded.

APIs

REST API (HTTP source) to CSV file or database table

REST API to CSV or database integration

Pull records from a REST API on a schedule, with paging and incremental fetches, then write CSV, push it on or load a database table.

CSV, query result or mapped file to REST API (HTTP destination)

Send CSV data to a REST API

Deliver query results or mapped files to a REST API with POST, PUT or PATCH, Basic, API key or OAuth2 authentication, and safe retries.

EDI

EDI 850 flat file (CSV) to SQL Server staging table

EDI 850 to SQL Server integration

Load EDI 850 purchase orders into SQL Server from the CSV your translator produces, validated, mapped and crosswalked to your customer numbers.

SQL Server (ERP) to EDI 810 or 856 flat file (CSV)

EDI 810 and 856 files from SQL Server

Build the invoice and ship notice CSV your EDI translator picks up from SQL Server queries, send each document once and keep a hash of every file.

Accounting

CSV, Excel or a query to QuickBooks Desktop IIF file

Import CSV into QuickBooks Desktop

Turn customer, vendor, item, invoice, bill, payment and journal data into QuickBooks Desktop IIF import files, validated before you import them.

CSV, Excel or a query to Sage 100 Visual Integrator CSV

Sage 100 Visual Integrator import files

Build Sage 100 Visual Integrator CSV files for customers, vendors, items, orders, invoices and GL accounts, with field lengths checked first.

CSV, Excel or a query to NetSuite CSV Import Assistant file

NetSuite CSV import files

Prepare NetSuite CSV Import Assistant files for customers, vendors, items, orders, invoices and journal entries from your ERP data.

CRM

Your contact, opportunity, product and case data to Salesforce Data Loader CSV

Salesforce Data Loader files from your data

Build Salesforce Data Loader files for accounts, contacts, opportunities, products, leads and cases, with parent links by External ID.

Your contact, opportunity and product data to HubSpot import files

HubSpot import files from your data

Build HubSpot import files for contacts, companies, deals, products and line items, plus the association files that link them.

Your contact, opportunity, product and case data to Dynamics 365 Import Wizard CSV

Dynamics 365 Import Wizard files

Build Dynamics 365 Import Wizard files for accounts, contacts, leads, opportunities, cases, products and price lists from your data.

Ecommerce

ERP data (query or export) to Shopify or Amazon product file

Shopify and Amazon product files

Create Shopify and Amazon product and order files from your ERP data with templates and product mappings, validated before you upload them.

Not on the list?

Tell us what you connect to.

We add packs from requests. Tell us the file format, trading partner or system and we will look at it.

Request a pack Use cases