Magento BI vs. Matillion

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Magento BI
Score 8.3 out of 10
N/A
Magento BI (formerly RJMetrics) is an ecommerce analytics solution that provides data pipeline, warehouse and visualization capabilities. It was acquired by Magento, and is now owned and supported by Adobe.N/A
Matillion
Score 6.8 out of 10
N/A
Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions. The vendor states enterprises including Cisco,N/A
Pricing
Magento BIMatillion
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Magento BIMatillion
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsBilled directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
More Pricing Information
Features
Magento BIMatillion
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Magento BI
9.0
2 Ratings
9% above category average
Matillion
-
Ratings
Pixel Perfect reports9.02 Ratings00 Ratings
Customizable dashboards9.02 Ratings00 Ratings
Report Formatting Templates9.02 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Magento BI
9.3
2 Ratings
14% above category average
Matillion
-
Ratings
Drill-down analysis9.02 Ratings00 Ratings
Formatting capabilities9.02 Ratings00 Ratings
Integration with R or other statistical packages9.01 Ratings00 Ratings
Report sharing and collaboration10.02 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Magento BI
9.0
1 Ratings
7% above category average
Matillion
-
Ratings
Publish to Web9.01 Ratings00 Ratings
Publish to PDF9.01 Ratings00 Ratings
Report Versioning9.01 Ratings00 Ratings
Report Delivery Scheduling9.01 Ratings00 Ratings
Delivery to Remote Servers9.01 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Magento BI
9.0
2 Ratings
11% above category average
Matillion
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)9.02 Ratings00 Ratings
Location Analytics / Geographic Visualization9.01 Ratings00 Ratings
Predictive Analytics9.01 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Magento BI
8.5
2 Ratings
1% below category average
Matillion
-
Ratings
Multi-User Support (named login)9.02 Ratings00 Ratings
Role-Based Security Model8.02 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.02 Ratings00 Ratings
Single Sign-On (SSO)9.01 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Magento BI
9.0
1 Ratings
12% above category average
Matillion
-
Ratings
Responsive Design for Web Access9.01 Ratings00 Ratings
Mobile Application9.01 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile9.01 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Magento BI
9.2
1 Ratings
15% above category average
Matillion
-
Ratings
REST API9.01 Ratings00 Ratings
Javascript API9.01 Ratings00 Ratings
iFrames9.01 Ratings00 Ratings
Java API9.01 Ratings00 Ratings
Themeable User Interface (UI)9.01 Ratings00 Ratings
Customizable Platform (Open Source)10.01 Ratings00 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Magento BI
-
Ratings
Matillion
7.6
123 Ratings
8% below category average
Connect to traditional data sources00 Ratings7.7122 Ratings
Connecto to Big Data and NoSQL00 Ratings7.582 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Magento BI
-
Ratings
Matillion
7.3
124 Ratings
14% below category average
Simple transformations00 Ratings8.1124 Ratings
Complex transformations00 Ratings6.4123 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Magento BI
-
Ratings
Matillion
7.2
116 Ratings
12% below category average
Data model creation00 Ratings9.133 Ratings
Metadata management00 Ratings9.140 Ratings
Business rules and workflow00 Ratings5.9108 Ratings
Collaboration00 Ratings5.5108 Ratings
Testing and debugging00 Ratings5.5109 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Magento BI
-
Ratings
Matillion
8.2
23 Ratings
0% below category average
Integration with data quality tools00 Ratings8.222 Ratings
Integration with MDM tools00 Ratings8.220 Ratings
Best Alternatives
Magento BIMatillion
Small Businesses
BrightGauge
BrightGauge
Score 8.9 out of 10
Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Magento BIMatillion
Likelihood to Recommend
9.0
(2 ratings)
6.9
(125 ratings)
Likelihood to Renew
-
(0 ratings)
8.2
(6 ratings)
Usability
9.0
(1 ratings)
6.5
(124 ratings)
Support Rating
9.0
(1 ratings)
7.4
(7 ratings)
Implementation Rating
-
(0 ratings)
8.2
(1 ratings)
Product Scalability
-
(0 ratings)
6.6
(117 ratings)
Vendor post-sale
-
(0 ratings)
9.1
(1 ratings)
Vendor pre-sale
-
(0 ratings)
9.1
(1 ratings)
User Testimonials
Magento BIMatillion
Likelihood to Recommend
Adobe
A company or organization that is in contact with the customer and wants to examine customer behavior in the purchase and selection of products and services should use this platform. It does not matter how many advertising tools and referral links or social media campaigns you use to attract customers. In any case, Magento BI integrates all the information and DB as a single platform and provides you with the best reports. Potential customers can be positioned according to location, city, country. Now we know exactly which product is most popular and where to put our advertising costs on which site or social network has the most audience.
Read full review
Matillion
It is very well suited for ETL on the cloud. Whenever there is something that can be accomplished with no code or little code, Matillion is a good tool. However, if your pipeline requires a lot of customizations, Matillion should be avoided.
Read full review
Pros
Adobe
  • It is relatively easy to manipulate the time period in which you want to see your report. This is important for our business because we are constantly analyzing sales month over month, quarter over quarter, and year over year. RJ makes it easy to toggle between these time ranges on the same report.
  • The visualizers available for reports are what you would expect out of a product like this. You have the ability to view your results in tables and a multitude of charts.
  • The ability to customize dashboards and rearrange reports quickly is great and intuitive!
Read full review
Matillion
  • We leveraged Matillion’s no-code principals to make data manipulation easy for our internal customers. People who don't know how to use SQL no longer need to. Everything in Matillion is self-explained with no or little coding.
  • We connected Matillion to our data warehouse to allow people to read raw data, transform it, then write results back to their sandbox databases. The drag and drop component design allowed customers to create complex data models at the speed of thought without any risk to production data.
  • With sharing capabilities between projects enabled, everyone was able to help each other when questions arose which instilled a strong sense of collaboration and community.
Read full review
Cons
Adobe
  • Educational videos and tutorials must be more simpler and more understandable language with subtitles
  • There should be the ability to select graphic diagrams with different shapes and graphs
  • The basic features of the Essential Paln can be increased with the current price so that startup companies can better use the features of this platform.
Read full review
Matillion
  • I think a non-CLI approach to installing and uninstalling python libraries would be nice. I mean, it isn't difficult to install a python library via Linux or CLI, but I imagine most companies don't feel comfortable allowing Matillion users to go on a virtual server and installing it themselves. Requirement.txt file for installing libraries would be simple, and maybe that could also be used to uninstall libraries as well......or maybe the library gets automatically downloaded if it is imported into a python script but the library doesn't exist.
  • Python Component is lacking very much in terms of UI. It would be unrealistic for me to suggest Matillion build its own EDI, but it would be nice if a python component could connect to a local IDE. Right now, if you want to write any decent length python code, you are going to be stuck copying and pasting your code from your local IDE.
  • It is also very difficult to debug in Matillion because you can't set breakpoints. Local IDE integration can resolve that.
  • I would like to have more templates to copy from for certain simplistic scenarios. For instance, a template for a job that fails which sends an AWS SNS with the Job name, component it failed on, and the error message. It wasn't as simple as I thought it would be to figure out and having to use a shared job for such circumstances can be painful because you have to export a bunch of variables.
  • There should be a drop down list for Global Matillion variables as it is difficult to remember at times.
Read full review
Likelihood to Renew
Adobe
No answers on this topic
Matillion
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
Read full review
Usability
Adobe
In addition to its features, it has made the Magento Commerce platform much better, more functional, and smarter, and through Magento BI dashboard they know very well what reports have been sent and all our business tools are summarized in one business platform. The ability to share report results is very popular and useful, and you can share content with anyone anywhere in the world.
Read full review
Matillion
It has been easy to train new employees who don't have previous experience with Matillion. It is quite self-explanatory. There are quite a few things that can be done with Python, however, we have not really looked into this feature much but likely will do in the future. Mostly, it is drag and drop of components and environments can be set up so easy to set up connections as well.
Read full review
Support Rating
Adobe
The very strong and knowledgeable support team and great help forums and documents, any questions and cases will be answered immediately or checked through tickets and resolved quickly. It is also possible to send comments and changes. Or our team , fast response and after-sales cooperation of the service company is always more than the product itself and its quality, and we want the service and support to support our interests.
Read full review
Matillion
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Read full review
Implementation Rating
Adobe
No answers on this topic
Matillion
We were able to control on access and built various enviroment for implementation
Read full review
Alternatives Considered
Adobe
The advantage of Magento BI is easier compatibility and adaptation with Adobe platforms and easier installation, configuration and customization with Mojto Store Builder and its various caskets, and I am very satisfied with it now and in every way I think it is a very good platform for integration in reporting.
Read full review
Matillion
Matillion ran circles around Stitch and Striim both in functionality, setup, and performance. There was no real comparison. Fivetran massively outperforms Matillion in pretty much every facet of the production from setup, maintenance, visibility, and usability. It already has the ability to connect any data source to a destination regardless of database type. Why we chose Matillion over Fivetran is that, for our current needs, Matillion provides us with the functionality that we need and a much more competitive price for a smaller company.
Read full review
Scalability
Adobe
No answers on this topic
Matillion
I have been able to connect Matillion to AWS Aurora Databases, MySQL databases, Rest APIs, Files in AWS S3, etc. Being able to load all of that disparate data into one datalake has made data mining and reporting a lot simpler. I wish everything could be implemented as easily as Matillion.
Read full review
Return on Investment
Adobe
  • Very comprehensive and complete reports that give us a lot of information about the customer
  • Easy integration and features of pulling data directly from our recorded customer database
Read full review
Matillion
  • Saving us time reduces our need for headcount
  • Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity
  • Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why
  • Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc.
Read full review
ScreenShots

Matillion Screenshots

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.