Export your transformed files directly to MySQL, PostgreSQL, or MongoDB tables and collections.
DB Export Transform Files sends a transformed file straight into a connected database. It has three tabs-Create Export Profile, Export Data, and Export Monitoring-covering the three database types: MySQL, PostgreSQL, and MongoDB.
Before you can export, add a database connector under Data Adapters → Databases → Configure. The fields differ slightly by database type.
MySQL / PostgreSQL Export Configuration
Configure your database to export transformed files directly to tables
Host *
e.g. localhost, an IP address, or db.example.com
Port
Defaults to 3306 (MySQL) or 5432 (PostgreSQL)
Database Name *
The name of your target database
Username *
Needs write access, e.g. root or postgres
Password *
Password for the account above
Use SSL Connection
Recommended for remote servers-required by most cloud providers for PostgreSQL
MongoDB Export Configuration
Configure your MongoDB connection to export transformed files directly to collections
Connection String *
Full MongoDB URI, including credentials, e.g. mongodb+srv://user:[email protected]
Database Name *
Target MongoDB database name
You can save more than one connector per database type-for example, a MySQL export for staging and another for production-and pick between them when creating an export profile.
On the Create Export Profile tab, pair a transformed file with a saved database connector.
Table Configuration decides whether the export creates a brand-new table or writes into one that already exists.
Create New Table
Enter a New Table Name; the table is created with columns based on your field mappings.
Use Existing Table
Write into a table that already exists in the destination database.
Field Mapping pairs each source field with a destination column.
Saved profiles live under the Export Data tab, where each one can be re-run at any time.
A profile flagged Source Deleted points to a source file that no longer exists. Its Start Export button is replaced with Delete-remove the profile or recreate it against a current file.
Export Monitoring logs every export run against its file, destination, and outcome.
If a connection test is failing, or an export keeps showing as Failed, our support team is here to help.
Contact Support