Flo-Database
Query a MySQL database and return data to your lead
Flo-Database brings the power of your MySQL database directly into Marketo Smart Campaigns. Without writing a single line of code, you can execute any SQL query (that returns exactly one row) and have the results mapped to your lead fields or captured as a JSON string for use in advanced workflows.
Table of Contents
-
Why Flo-Database Matters
Flo-Database removes the gap between your marketing automation and your transactional data. Imagine instantly enriching a lead’s record with lifetime value, subscription tier, or loyalty points-without exporting CSVs or building middleware.
How It Works
- Configure once. In the Marketo Admin UI, install Flo-Database and set your global connection.
- Build your query. In any Smart Campaign, drop the Flo-Database step, paste your SQL (including tokens placeholders), and-if you prefer-choose a single field to receive the full returned data.
- Execute at runtime. When the campaign runs, our service opens a secure tunnel, runs your query (must return one row), and returns success/failure plus either individual columns (aliased to your Marketo field API names).
- Act instantly. Use the returned data for segmentation, personalization, scoring, or real-time decisioning right inside your flows.
Four Common Use Cases
- Customer Profile Enrichment: Automatically populate custom lead fields from your database whenever a lead is created or updated.
- Real-Time Personalization: Fetch product recommendations or loyalty points during a “Send Email” flow action and inject them into your email templates via merge tokens.
- Account-Based Marketing: Lookup firmographic details (industry, region, deal stage) by company ID to trigger high-value nurture streams for target accounts.
- Data Quality & Validation: Cross-check incoming form submissions against your CRM or ERP to flag duplicate or inactive accounts on the fly.
Get Started in Minutes
- Activate your Otowui API key
- Import the service
- Drag & drop “Flo-Database” into any Smart Campaign flow, configure and publish.
Unlock the full potential of your MySQL data-right from within Marketo. Install Flo-Database today and see your lead records come to life.
