Sign in Start free
Start free Sign in Create account
Integration · ERP and databases

PostgreSQL and MySQL to CSV and SFTP

DataBridge connects to PostgreSQL, MySQL, SQL Server and SQLite. Queries run read-only, and the result is delivered as a file wherever you point it.

PostgreSQL or MySQL → CSV, TSV or JSON file

Start free All integrations
What you need

Modules. Everything bundle for a scheduled query-to-file job. Database alone covers connections, queries and Data Sync.

Edition. DataBridge Server for unattended schedules.

Pricing and what each edition includes.

Limits, stated plainly
  • Windows authentication is offered for SQL Server only.
  • SQL Server Change tracking is for SQL Server sources only. On other databases use Timestamp, Row hash or Full compare.
  • Oracle is not a supported connection type. Export a CSV from Oracle with its own tools and let DataBridge take over from the file.
Steps

How it works.

Each step names the feature as it appears in the product.

  1. Step 1

    Connection

    Choose PostgreSQL or MySQL as the database type. The default ports are 5432 and 3306, and you set the host, database name and a login that can only read.

  2. Step 2

    Saved query

    Write the SELECT in the engine's own SQL. Only read-only statements are accepted.

  3. Step 3

    Destination

    SFTP, FTP or FTPS, a folder, email, Azure Blob Storage, Amazon S3 or an HTTP endpoint.

  4. Step 4

    Scheduled job

    Chain the query and the push, pick a schedule and retries, and read each run in Job Monitor.

  5. Step 5

    Data Sync

    To copy a table between two databases instead of exporting a file, use a Data Sync profile with Full compare, Timestamp or Row hash.

Questions

Common questions.

Which databases can DataBridge connect to?

SQL Server, PostgreSQL, MySQL and SQLite. Oracle is not supported.

Can it write to PostgreSQL or MySQL?

A job's Write to database step can load an existing table on a connection an administrator has enabled for writes. On databases other than SQL Server it writes row by row.

Keep reading

Related use cases and integrations.

Nightly SQL Server to SFTP ExtractDatabase-to-Database Table SyncSQL Server to CSV export automationImport CSV into SQL Server automaticallyWhat DataBridge connects to

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.

Next step

Try the parts that are free today.

The free browser edition needs no sign-in and never uploads your files.

Start free All features