Smarter Data Exports in Automated Flows: FTP, MySQL, and Google BigQuery
We’ve expanded Automated Flow export capabilities with three powerful new options:
• FTP Export for Incremental Logs: Send incremental data directly to an external FTP server
• MySQL Export via ODBC: Seamlessly connect and export data to MySQL databases using the ODBC driver
• Google BigQuery Export: Push segments or tables directly into BigQuery for advanced analytics
These enhancements make it easier to deliver data securely, integrate with your existing systems, and run analysis in the tools you already use.
Why it matters
Data becomes more valuable when it flows to the right place at the right time. With these export options, marketers and data teams can:
• Automate reporting and archiving by exporting logs via FTP
• Keep customer data aligned across platforms by pushing it directly into MySQL
• Run scalable analysis and visualization by syncing D·engage segments and tables into BigQuery
This flexibility ensures your data strategy scales with your business needs 🌍
How to get started
FTP Export for Incremental Logs
• Go to Data Space > Data Management > Automated Flows
• Create a new Automated Flow, add a trigger, and place the Data Export node
• Select Incremental Logs as the data type
• Choose FTP Export as the Remote Target
• Review your configuration and save
Learn more in the FTP Export Help Guide
MySQL Export via ODBC
• Configure MySQL as an ODBC Remote Target in Settings > Integrations > Remote Targets (using the MySQL ODBC driver)
• In Automated Flows, create a new flow and add a Data Export node
• Select your ODBC target configured for MySQL
• Complete setup and save
Learn more in the MySQL ODBC Export Help Guide
Google BigQuery Export
• Go to Automated Flows and create a new flow
• Add a trigger and a Data Export node
• Select a Segment or Table as the data source
• Choose Google BigQuery as the Remote Target
• Finalize and save
Learn more in the BigQuery Export Help Guide