🥳 Introducing our new Flex Connector! 👉 Learn more Introducing our new Flex Connector!

Sync, store and access your Magento data

Panoply makes it easier than ever to access your Magento data. Consolidate Magento, plus all other business data, in a secure data warehouse for a single source of truth. Explore your Magento data with our SQL workbench, in-product graphs and charts, or connect your favorite BI tools for advanced reporting and analysis.

See how to connect Panoply with Magento.
Get started
Panoply can connect with nearly any data source, via our Flex Connector or any 3rd party ETL tool. Our team will help you explore your options.

Sync Magento data

Some of the available tables Panoply can collect from Magento include:
Catalog Product Entity
Describes specific categories and can be combined with the `catalog_category_entity_varchar` table and `catalog_category_product` mapping table to get category info for each product.
Catalog Category Product
A combination of product and category info. Products can be listed multiple times with different categories and vice versa. This table indexes the `catalog_category_entity` table (which has category details) and the `catalog_product_entity` table (which has product details).
Catalog Product Entity
Information about specific products, including the SKU and when they were added in Magento.
Customer Entity
Information about users that are registered on your website. Includes basic customer-level details like email address and registration date.
Quote
Information about carts created during checking, including whether or not the cart was converted to an order. Note: Due to the potential size of this table, Magento recommends periodically deleting records if certain criteria are met, such as unconverted carts more than 60 days old.
Quote Item
Data about items added to a cart, whether or not they were actually purchased. Note: Due to the potential size of this table, Magento recommends periodically deleting records if certain criteria are met, such as items in unconverted carts more than 60 days old.
Sales Order
Data about orders placed on your site, including order date, the customer who placed the order, the order total, and any discount or coupon codes used.
Sales Order Address
Shipping and billing information associated with specific orders.
Sales Order Item
Information about specific items from specific orders, such as details about the order, the product, and the quantity purchased.

Sync Magento data with multiple sources in Panoply, then access it via your BI tool

Magento + AdRoll
AdRoll
Ads
Magento + AfterShip
AfterShip
Retail
Magento + Alteryx
Alteryx
ETL
Magento + Amazon Ads
Amazon Ads
Ads
Magento + Amazon Aurora PostgreSQL
Amazon Aurora PostgreSQL
Databases
Magento + Amazon Cloudfront
Amazon Cloudfront
Services
Magento + Amazon DynamoDB
Amazon DynamoDB
Databases
Magento + Amazon Kinesis Firehose
Amazon Kinesis Firehose
Services
Magento + Amazon Marketplace
Amazon Marketplace
E-commerce
Magento + Amazon QuickSight
Amazon QuickSight
BI Tools
Magento + Amazon S3
Amazon S3
Services
Magento + Amazon Seller
Amazon Seller
Retail
Magento + Apache Superset
Apache Superset
BI Tools
Magento + Apache Zeppelin
Apache Zeppelin
BI Tools
Magento + Apple App Store
Apple App Store
Mobile
Magento + Apple Search Ads
Apple Search Ads
Ads
Magento + AppsFlyer
AppsFlyer
Mobile
Magento + Asana
Asana
Project Management
Magento + Attunity
Attunity
ETL
Magento + Autopilot
Autopilot
Marketing Automation
Magento + Azure Blob Storage
Azure Blob Storage
Cloud Storage
Magento + BigCommerce
BigCommerce
E-commerce
Magento + BigQuery
BigQuery
Data Warehouses
Magento + Bing Ads
Bing Ads
Ads
Magento + Birst
Birst
BI Tools
Magento + Braintree Payments
Braintree Payments
Payment Processing
Magento + Branch
Branch
Analytics
Magento + BranchTrack
BranchTrack
Sales
Magento + Campaign Monitor
Campaign Monitor
Marketing Automation
Magento + CaptivateIQ
CaptivateIQ
Sales
Magento + CARTO
CARTO
BI Tools
Magento + Chargebee
Chargebee
Accounting
Magento + Clari
Clari
Sales
Magento + Close
Close
Sales
Magento + Codat
Codat
Accounting
Magento + Contact Pigeon
Contact Pigeon
Marketing Automation
Magento + Contentful
Contentful
Services
Magento + Count
Count
BI Tools
Magento + Crashlytics
Crashlytics
Developer Tools
Magento + Criteo
Criteo
Retail
Magento + CSV
CSV
Files
Magento + Customer.io
Customer.io
Marketing Automation
Magento + Databricks
Databricks
BI Tools
Magento + Delighted
Delighted
Customer Support
Magento + Desk
Desk
Sales
Magento + Domo
Domo
BI Tools
Magento + Draxlr
Draxlr
BI Tools
Magento + Drip
Drip
E-commerce
Magento + Dropbox
Dropbox
Files
Magento + EasyPayDirect
EasyPayDirect
Payment Processing
Magento + Elasticsearch
Elasticsearch
Databases
Magento + Eloqua
Eloqua
Marketing Automation
Magento + Enchant
Enchant
Customer Support
Magento + etleap
etleap
ETL
Magento + Facebook Ads
Facebook Ads
Ads
Magento + Facebook Pages
Facebook Pages
Social
Magento + Facebook Posts
Facebook Posts
Social
Magento + Fivetran
Fivetran
ETL
Magento + FormKeep
FormKeep
Marketing Automation
Magento + Freshdesk
Freshdesk
Customer Support
Magento + Front
Front
Project Management
Magento + GitHub
GitHub
Developer Tools
Magento + GitLab
GitLab
Developer Tools
Magento + GoodData
GoodData
BI Tools
Magento + Google Ads
Google Ads
Ads
Magento + Google Analytics
Google Analytics
Analytics
Magento + Google Analytics Ecommerce
Google Analytics Ecommerce
E-commerce
Magento + Google Cloud SQL MySQL
Google Cloud SQL MySQL
Databases
Magento + Google Cloud SQL Postgres
Google Cloud SQL Postgres
Cloud Storage
Magento + Google Cloud Storage
Google Cloud Storage
Cloud Storage
Magento + Google Drive
Google Drive
Files
Magento + Google Search Console
Google Search Console
Analytics
Magento + Google Sheets
Google Sheets
Files
Magento + Grafana
Grafana
BI Tools
Magento + Grin
Grin
Services
Magento + Harvest
Harvest
Project Management
Magento + Harvest Forecast
Harvest Forecast
Project Management
Magento + Help Scout
Help Scout
Customer Support
Magento + Heroku Postgres
Heroku Postgres
Databases
Magento + Holistics
Holistics
BI Tools
Magento + HubSpot
HubSpot
CRM
Magento + IBM Cognos
IBM Cognos
BI Tools
Magento + IBM DB2
IBM DB2
Developer Tools
Magento + Informatica PowerCenter
Informatica PowerCenter
ETL
Magento + Instagram for Business
Instagram for Business
Social
Magento + Intercom
Intercom
Sales
Magento + Invoiced
Invoiced
Services
Magento + Iterable
Iterable
Marketing Automation
Magento + Jira
Jira
Project Management
Magento + JSON
JSON
Files
Magento + Julia
Julia
BI Tools
Magento + Jupyter
Jupyter
BI Tools
Magento + Kandji
Kandji
Security
Magento + Klaviyo
Klaviyo
E-commerce
Magento + Klipfolio
Klipfolio
BI Tools
Magento + KNIME
KNIME
BI Tools
Magento + LeafLink
LeafLink
Retail
Magento + Lever
Lever
CRM
Magento + LinkedIn Ads
LinkedIn Ads
Ads
Magento + Looker
Looker
BI Tools
Magento + Looker Studio
Looker Studio
BI Tools
Magento + Luzmo
Luzmo
BI Tools
Magento + MailChimp
MailChimp
Marketing Automation
Magento + Mailjet
Mailjet
Marketing Automation
Magento + MariaDB
MariaDB
Databases
Magento + Marketo
Marketo
Marketing Automation
Magento + Matillion
Matillion
ETL
Magento + Mavenlink
Mavenlink
Project Management
Magento + Maverick Payments
Maverick Payments
Payment Processing
Magento + Maxio
Maxio
Accounting
Magento + Metabase
Metabase
BI Tools
Magento + Microsoft Excel
Microsoft Excel
Files
Magento + Microsoft OneDrive
Microsoft OneDrive
Cloud Storage
Magento + Microsoft SQL Server
Microsoft SQL Server
Databases
Magento + MicroStrategy
MicroStrategy
BI Tools
Magento + Mode Analytics
Mode Analytics
BI Tools
Magento + MongoDB
MongoDB
Databases
Magento + MySQL
MySQL
Databases
Magento + NetSuite
NetSuite
Accounting
Magento + Optimizely
Optimizely
Marketing Automation
Magento + Oracle Database
Oracle Database
Databases
Magento + Pandas
Pandas
BI Tools
Magento + Panintelligence
Panintelligence
BI Tools
Magento + Pardot
Pardot
CRM
Magento + Particle
Particle
Services
Magento + Payline
Payline
E-commerce
Magento + PayPal
PayPal
E-commerce
Magento + Pentaho
Pentaho
BI Tools
Magento + Pinterest
Pinterest
Social
Magento + Pipedrive
Pipedrive
Sales
Magento + Pivotal Tracker
Pivotal Tracker
Project Management
Magento + Plotly
Plotly
BI Tools
Magento + PopSQL
PopSQL
BI Tools
Magento + PostgreSQL
PostgreSQL
Databases
Magento + Power BI
Power BI
BI Tools
Magento + Python
Python
BI Tools
Magento + Qlik
Qlik
BI Tools
Magento + QuickBase
QuickBase
Developer Tools
Magento + Quickbooks
Quickbooks
Accounting
Magento + R
R
BI Tools
Magento + Rakuten
Rakuten
Services
Magento + Recharge
Recharge
Payment Processing
Magento + Recurly
Recurly
Payment Processing
Magento + Redash
Redash
BI Tools
Magento + Reddit
Reddit
Social
Magento + Redshift
Redshift
Data Warehouses
Magento + Referral SaasQuatch
Referral SaasQuatch
Marketing Automation
Magento + RingCentral
RingCentral
Magento + Rivery
Rivery
ETL
Magento + Sailthru
Sailthru
Marketing Automation
Magento + Salesforce
Salesforce
CRM
Magento + Salesforce Marketing Cloud
Salesforce Marketing Cloud
Marketing Automation
Magento + SeekWell
SeekWell
BI Tools
Magento + Segment
Segment
Analytics
Magento + Selligent
Selligent
Marketing Automation
Magento + SendGrid
SendGrid
Marketing Automation
Magento + Sendwithus
Sendwithus
Marketing Automation
Magento + SentinelOne
SentinelOne
Security
Magento + SFTP
SFTP
Services
Magento + Shiny
Shiny
BI Tools
Magento + Shippo
Shippo
E-commerce
Magento + Shopify
Shopify
E-commerce
Magento + Singer
Singer
ETL
Magento + Skyvia
Skyvia
ETL
Magento + SnapLogic
SnapLogic
ETL
Magento + Sparkpost
Sparkpost
Marketing Automation
Magento + SphereWMS
SphereWMS
Services
Magento + Spree Commerce
Spree Commerce
E-commerce
Magento + SQL
SQL
BI Tools
Magento + Square
Square
Payment Processing
Magento + Stitch
Stitch
ETL
Magento + Stripe
Stripe
Payment Processing
Magento + Sybase
Sybase
ETL
Magento + Tableau
Tableau
BI Tools
Magento + Taboola
Taboola
Ads
Magento + Talend
Talend
ETL
Magento + Teachable
Teachable
Services
Magento + ThoughtSpot
ThoughtSpot
BI Tools
Magento + TIBCO Spotfire X
TIBCO Spotfire X
BI Tools
Magento + TikTok
TikTok
Social
Magento + Tray.io
Tray.io
Services
Magento + Trello
Trello
Project Management
Magento + Trevor.io
Trevor.io
BI Tools
Magento + Twilio
Twilio
Developer Tools
Magento + Twitter
Twitter
Social
Magento + Twitter Ads
Twitter Ads
Ads
Magento + Typeform
Typeform
Services
Magento + Upload Data
Upload Data
Files
Magento + Urban Airship
Urban Airship
Services
Magento + Vero
Vero
Social
Magento + Webhooks
Webhooks
Developer Tools
Magento + WeInfuse
WeInfuse
Services
Magento + WooCommerce
WooCommerce
E-commerce
Magento + Wordpress
Wordpress
Databases
Magento + Xero
Xero
Accounting
Magento + Xplenty
Xplenty
ETL
Magento + Yellowfin
Yellowfin
BI Tools
Magento + Zapier
Zapier
Services
Magento + Zendesk
Zendesk
Customer Support
Magento + Zendesk Chat
Zendesk Chat
Customer Support
Magento + Zendesk Sell
Zendesk Sell
CRM
Magento + Zoho Analytics
Zoho Analytics
BI Tools
Magento + Zoho CRM
Zoho CRM
CRM
Magento + Zoom
Zoom
Services
Magento + Zuora
Zuora
Services
“ Panoply has given us drastic improvements in query speed and brought all our data in one place. Our visualizations are much more fast and efficient.
Andrew Zeck - CTO and Co-founder, Saucey