Share
Magento Setup Guide

Magento empowers thousands of retailers and brands with the best eCommerce platform and flexible cloud solutions to rapidly innovate and grow. It offers marketing, search engine optimization, and catalog-management tools.

Magento Platform uses MySQL database as an underlying data store. Hevo connects directly to Magento’s MySQL database rather than connecting through the APIs. This approach ensures most comprehensive coverage in terms of data and more reliability.

You can replicate the Events data from your Magento account to a Destination database or Data Warehouse using Hevo Pipelines.


Schema and Primary Keys

The schema is derived based on the data in your MySQL Source tables.


Data Model

The data model depends on the data in your MySQL Source tables.


Limitations

  • Hevo does not load data from a column into the Destination table if its size exceeds 16 MB, and skips the Event if it exceeds 40 MB. If the Event contains a column larger than 16 MB, Hevo attempts to load the Event after dropping that column’s data. However, if the Event size still exceeds 40 MB, then the Event is also dropped. As a result, you may see discrepancies between your Source and Destination data. To avoid such a scenario, ensure that each Event contains less than 40 MB of data.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jul-07-2025 NA Updated the Limitations section to inform about the max record and column size in an Event.
Jan-07-2025 NA Added a limitation about Event size.
Mar-18-2024 2.21.2 Updated section, Specify Magento via MySQL Connection Settings to add information about the Load all CA certificates option.
Dec-19-2022 2.04 Updated section, Specify Magento via MySQL Connection Settings to add information that you must specify all fields to create a Pipeline.
Jan-24-2022 1.80 New document.
Last updated on Jul 03, 2025

Tell us what went wrong

Skip to the section