TrustRadius
https://media.trustradius.com/product-logos/UP/UY/12EPOH2MSVII.pngExcellent Entry-Level ETL/ELT ResourceWe used Matillion on a small, 3-person team to manage ingestion and transformation for our data warehouse, pulling from numerous datastores and vendors to a common warehouse schema.,Shallow learning curve - Matillion is powerful, but only as complicated as you need at a given time. Superb helpdesk and documentation. Jobs are translated directly to SQL which makes them easy to debug.,Parsing of flat files is inconsistent depending on the source The product is constantly evolving (good!) but that means relearning parts of the interface every few months Support for a larger set of APIs and database engines would be helpful,9,Permitted our existing staff to take on ETL, rather than hiring an SME,9,With the help of the support team, we had a proof of concept up and running in an afternoon. Since Matillion comes as an AWS package, there was no configuration needed to get the instance spun up, which was fantastic. Connecting to data sources that require their own JDBC drivers took as much as an hour, but settings are portable, so this was a one-off process for each new source.,7Matillion is a powerful and easy-to-use, completely cloud-capable ETL/ELT solution.We are currently using Matillion as our primary ETL/ELT tool both in our department and supporting others in the organization as well as introducing it to other Business units under the Cimpress brand. For us and others it primarily solves the need of loading and manipulating raw data from multiple sources and making it available in both Redshift and Snowflake. Additionally, the flexibility of the tool and its seamless integration with the complete AWS Services library allows us to perform many operational tasks that are completely unrelated to the ETL/ELT workload.,Integrates very well with most, if not, all AWS services - Easy to get data from anywhere inside your AWS account into Redshift or Snowflake databases. It has many available integrations and datasource connectivity outside of AWS and other cloud service providers - Makes it easy to get data from many sources and systems in more traditional on or off premise technologies as well as vendor-specific data and application interfaces. Very intuitive, easy-to-learn-and-use interface with a large collection online tutorial articles and videos - makes for an extremely easy onboarding of users who may or may not have past experience with other similar tools.,Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users. Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies. Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.,10,Reliable source for ETL/ELT,9,I was able to get my very first proof-of-concept instance up and running in under 10 minutes and get started building and executing my first basic ETL job in the Redshift product right away. And within about an hour, I had a basic prototype version of an SQL Server Integration Services(SSIS) job converted to run in Matillion for Redshift that was loading flat files from a Windows file share directly into our Redshift cluster via AWS S3.,7,FivetranMatillion ReviewiQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.,Supports a wide variety of digital platform connectors, which could be helpful for any industry working to automate any of their reporting needs. Support for AWS technologies adds to greater advantage. Takes up unique functionality provided by the database into account which is very helpful. Also provides direct SQL query feed-in option for any migration of existing solution.,With the added functionality available in Matillion, the understanding to use complex features becomes challenging for a new development team. Updates are regularly provided by Matillion support team but then they fail to specify the release document, new features or updates carried out in each update. Validation failure in scheduled jobs is sometimes encountered without any reason or proper RCA. Complex user management flow.,8,Our organization focuses on Data-Driven Digital Marketing Strategies, so not investing time and resources on getting the data, we ensured the time utilized much more in analyzing the data and for this purpose, Matillion was our solution and was right on a positive track. Matillion has been performing positive since it's consumption in our organization in terms of investment. With increasing functionality and stability in Matillion system, we could look for greater return than just replacements.,9,Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing. Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running with-in a week time after acquiring a license but for the development team to work efficiently it took a couple of weeks.,6,Talend Cloud Integration and Informatica Cloud,Fivetran, Snowflake, Stitch,10,8,Digital Platform Connectors Automating & scheduling Jobs Interacting with wide sources of systems,Automating the reporting Monitoring & tracking the scheduled jobs with automated variables option Making Grid variables as an alternative to For loop,End-to-End Tracking of all the Jobs Additional Connectors and Custom connectors building option User Management Policy,9,Not Sure,Price Product Features Product Usability Third-party Reviews,There are a couple of times when Matillion support team provided its extraordinary brilliance. I would like to point out an instance when we were trying to implement tracking & monitoring in place for scheduled jobs and Kalyan (from the Support team) helped us to implement tracking which is still very helpful for our team without manually going to individual job to check the success. Team provided the idea of "Task History Export" and another instance of using automated variable "Matillion ID" for tracking needs.,92 Years with MatillionMatillion is used in our Data Analytics and Data Engineering department. At the time we purchased it, we had no dedicated data engineers. We needed something powerful enough to handle more complex jobs, but simple enough that a semi-technical analyst could use. We were using a lot of different tools at the time and were evaluating a lot of different ETL solutions in the space. Matillion provided a solution that was simple, easy to connect, and also provided Internet connectors to some of our most crucial systems, such as Salesforce and Jira. It has allowed us to consolidate much of our processes onto a single system that is easily understood.,Cloud connectivity: It makes pulling data from cloud services like Salesforce super simple and easy to bring into a data warehouse ETL Orchestration: The drag and drop interface makes it easy to compose new orchestration layers in our ETL. It's something that does not require a Data Engineer to complete. Enterprise integration: It was really easy to configure into our LDAP system, and that makes administering the box really easy. Variety of Data sources: It is pretty easy to bring data into Matillion to process into the data warehouse. The Gui provides other non-functional visual elements to mark up the job. This is great for team members to communicate complicated parts of the ETL or to otherwise label parts of their ETL.,Matillion has no clustering ability. For particularly large jobs or large data sources, processing can take a long time and it does not have the ability to map-reduce, like Spark. The output is limited to Redshift. Often times we would want to drop a Parquet or Avro file into s3 as the output of our ETL. We often get OOM errors and other server related constraints. We need to be very careful about how our jobs are scheduled in order to make everything work well. It is not clear from the documentation how to organize work in Matillion. Between environments, projects, and jobs in a project, we've had to organize in a way to accommodate for Matillion's limitations, which doesn't allow us to organize our jobs in a way that makes sense for us.,8,Matillion had had a positive impact on our ability to scale up our ETL process without increasing our headcount. We've been able to double the number of jobs we have in the last year. A positive impact on the amount of time we need to investigate failures. Coming from other tools that had high rates of failures (say 2 jobs failing a week), we have not seen as many technical failures from Matillion. This reduces the number of resources we focus on tracking down failures, fixing, and re-running jobs by 25%.,8,We were able to get up and running with Matillion within a week. When we spun it up, we started putting together our first jobs, and they were super simple to set up. Though the jobs were on the simpler side, it was pretty easy to get started.,3,Alooma and Fivetran,Amazon Redshift, AWS Lambda, Tableau ServerEase of Use and Reusability for Excellent ROIWe use Matillion to bring together data from multiple sources - our application, Salesforce, Qualtrics, etc. - into a central data warehouse for use throughout the business in reporting, both internally and externally. Matillion performs the ETL that transforms this raw data into a structure in Redshift useful for reporting.,It integrates well with Amazon Web Services, like S3 and Redshift It makes good use of Redshift to perform ETL quickly The ability to parameterize ETL jobs with variables makes it possible to get a lot of reuse from ETL jobs,Integration with source control is a challenge; we had to roll our own solution to pull our Matillion jobs via its API into files we could add to source control It can be a challenge to avoid conflicts when multiple people are developing jobs in the same project It's only available on Redhat flavors of Linux (e.g. Amazon Linux, Redhat, CentOS),9,Matillion has dramatically decreased the time it takes to create new ETL Matillion has reduced the amount of time it takes to execute our daily ETL processing (by 50% or more) Matillion has increased the number of people who can develop ETL by making ETL development easier Matillion has increased the variety of data sources we can bring into our data warehouse Matillion has made it a little harder to manage source control and deployment,10,We were able to get up and running with Matillion within a month. With no real training in the tool, we were able to develop useful jobs and an entire job framework on Matillion within that month. As we got more familiar with it, within three months, we were able to take advantage of additional features to create a framework where bringing new data in from our application is as simple as adding an entry to a table.,9,SQL Server Integration Services and Pentaho,Amazon Redshift, PostgreSQL, Amazon Elastic Compute Cloud (EC2)Matillion ETL for Amazon RedshiftI met with Matillion team at AWS Summit 2018 at Sydney, Australia. At that time we were using legacy ETL for our Redshift Data Warehouse.We were trying to adopt Continuous Integration/Continuous Delivery framework for our ETL and found it to be challenging for our environment. It was time to look for something new and say goodbye to our bellowed legacy ETL. So we had a conversation with Matillion team and quickly decided to do a POC. We've evaluated couple of other tools in the past but nothing came close to Matillion.First of all, setup was a breeze. The migration was quick and painless, the system is very easy to work with. Almost more importantly, the Matillion team is very friendly and always willing to help, their support is outstanding! Matillion has dozens of native connectors out of the box, so we had no problem with integrations at all. In fact, migration to Matillion allowed us to drop couple of third party legacy ETL components required for AWS infrastructure.Python scripts component allows to use Boto3 and hundreds of other libraries, so practically there is no limit of where you can use Matillion.We were finally able to build full scale CI/CD pipeline. Our setup uses combination of JIRA, Bitbucket and Bamboo build server and it works like a charm, thanks to Matillion'™s REST API.,Works very well with Redshift and integrates with other AWS Services, such as S3, SNS or SQS for example Has scripting components like Python using Boto and any other libraries. Additional libraries need s to be installed on Matillion EC2 instance Plenty of data sources out of the box, the rest can be pulled via API Automatic validation of database objects and components Easy to install Excellent integration with CI/CD,Minor: Changes to the ETL can only be reviewed in Matillion GUI rather than true source code diff, i.e. Bitbucket,10,Direct savings from actual running cost Indirect savings as a result of increased productivity,10,Very quickly. We did a POC in a couple of weeks and then migrated production ETL to Matillion in about three weeks. Support from Matillion was outstanding during the transition and post implementation period.,9,,Amazon Redshift, Microsoft Power BIMatillion: Fast ELT with a whole lot moreWe use Matillion to load millions of rows of data each and every day. We got our warehouse up and running using Matillion in just a few months. We use it for all our reporting and have built out our commissions processes using this tool. We are able to connect data from multiple sources into one coherent location that makes our reporting so much easier.,Matillion is an ELT tool rather than an ETL tool. This means that it's using the database engine to manipulate data. Much faster than a traditional ETL tool where speed is lost in the movement of data. Building Transformation Jobs. The flow-chart style developer interface makes it simple and easy to build jobs. But underlying that is the ability to create complex SQL and/or Python components which make just about anything you can think of possible. AWS integration. The integration with AWS allows a multitude of possibilities such as automatically kicking off jobs when a file is loaded in S3 or sending a notification of job success or failure via SNS.,Matillion has some limited capabilities when interacting with other databases outside of Redshift and RDS. Getting data from other databases is pretty easy. Putting data back into databases other than Redshift and RDS is more limited. That said, it's specifically built to load Redshift and that it does well. There are times when I get disconnected from the server. This may happen once or twice a day. Nothing is lost and it's a simple matter of logging back in. It's not my internet either as my coworkers in different areas of the country experience the same thing. I have seen some improvement in some of the later releases.,10,I was able to build a complete commissions processing system for over 3500 employees using Matillion in just over a month. This included gathering data from 5 different sources, combining them together appropriately and building in the business rules. I was awarded one of the top awards our company gives for this project. Our big three Business Intelligence tools: Matillion, Redshift and DOMO allow us to give our employees the right data at the right time. Our productivity has increased as 75%+ of our employees look at their data every day they work.,10,Matillion is VERY easy to set up. I configured an instance of Matillion for a client of mine in about 10 minutes. I had a working automated load combining multiple data s in about an hour. Once configured, it's simple to add addition data sources and additional environments. I love how easy it is to load a csv file from S3 into Redshift.,8,,Toad Data Point, FileZilla, AWS LambdaVery user-friendly product that fills a niche for AWS Integration.We use Matillion as the new ETL tool for building Data infrastructure for the company. Our Data team is limited to 2 Matillion users but the Data infrastructure will be used by the BI team to help all areas of the business. So far, we've used it for various data loading tasks but are starting to use for the new Data Warehouse processes we'll be building.,Data Mapping - it is really good at recognizing the source and destination data types and does a great job at converting data types. User-Friendly Interface - development is very easy within the tool and very intuitive for Data experts. Troubleshooting - for the most part, it gives informative messages when errors occur and it is extremely useful to see data transformation 'in-flight' through data sampling.,Deployment to other Environment - this is not a smooth process and needs improvements. Better integration with code repository and smooth deployment of changes is needed (for example, just exporting variable default values is very clunky). Documentation - for the version of Matillion we are using, we can't export documentation for our jobs. Since this is the level of functionality we need, it sounds unreasonable that to get a couple of more features (one of them being Documentation), we would need to upgrade to a higher level of license that would cost twice as much). Running queries on other databases - although we primarily want to load data into Redshift, we sometimes need to run quick queries as part of the process against non-Redshift databases (that are not straight loads from the DB to Redshift). Although we can do this through Python, it would be a lot more helpful to be able to do this within Matillion components.,8,Too early in the process to tell but it has made a lot of development easier and faster compared to other tools used in this company.,8,We started testing and developing the initial jobs right after standing Matillion up. We are continuously developing new jobs as we keep moving through the data projects.,7,,Talend Data Integration, Microsoft Power BI, AtomMatillion makes ETL pipeline creation and management easy and extensibleMatillion is a fundamental part of our ETL pipeline creation and management. It is the solution we have chosen that enables myriad external data sources (APIs, CSVs, data lakes etc.) to be ingested into our data warehouse. As a tool for its specific purpose, it is primarily used by the Data Science team, but the resulting data is disseminated to multiple departments via dashboards and reports across the whole company.,It provides a simple and intuitive visual interface for ETL creation and management that is also highly flexible and extensible i.e. integrating custom Python scripts It makes complex, advanced workflows, e.g. updating, scheduling, error handling & reporting, simple with pre-existing drag-n-drop "feature blocks" It makes the creation of a clear, hierarchical architecture across all pipelines simple and easily replicable by all members of the team Matillion's support team is highly responsive and always do their best to address issues as quickly as possible,Whilst the pre-existing "feature blocks" do make creating new API integrations simple, fine tuning the integration or ironing out minor bugs requires conversations with Matillion support (however, they are always very quick to respond and have always fixed our issues) Minor feature request: It would be nice to have a way to pass the output of a Python script directly to a subsequent SQL "block",10,We don't have ROI data to share at this stage.,10,We took on Matillion at the very beginning of a new data warehouse project, so it was a longer set up than if we were just swapping out an existing ETL solution. However, we were able to create an end-to-end POC within a few weeks.,8,,Amazon Redshift, Periscope DataMatillion has made complex ETL of massive quantities of variably structured data approachable for us.Our company, Clutch, ingests, transforms and otherwise manipulates massive quantities of retail customer data every day. Because even retailers in the same verticals each bear different processes, structures and even attributes within their data, we needed a tool to help us rapidly develop ETL and we needed one tailored to working with advanced columnar data and storage, such as Amazon's Redshift column store database and S3 cloud data storage. While we're cost sensitive, we also didn't want to reinvent the wheel. More importantly, we wanted to avoid a cloud-based product that tried to act like traditional enterprise ETL tools like Informatica or SSIS, only to find ourselves using clunky, complicated and undiscoverable browser-based tools. Finally, we are a shop that often 'fixes tires on a moving car', and so the tool we chose needed to be intuitive, the support behind it responsive and amazing. Matillion has served these needs and more, quickly becoming a go-to part of most of our data solutions, and becoming increasingly visible in other areas as well, such as reporting on cloud-based systems like Salesforce and JIRA.,Matillion (for Redshift) understands working with Redshift, and it's components adapt well to changing aspects of extraction, transformation, and loading. Because Matillion is pay for actual use, we only pay for the uptime of our instance. This is way more powerful than we expected, as we're able to maintain task-specific Matillion instances that are brought online to handle workloads, then taken down when not in use. Matillion's support is probably the best there is, for any software. You're never asked the proverbial 'is the machine on' type questions, they always get back to you faster than expected, and the people conducting the support are definitely not reading scripts. They know what you're trying to do because they've probably done it. Matillion often surprises us with it's flexibility and adaptability to tasks, even some you'd normally consider being outside the purview of traditional ETL.,While ETL usually involves fetching, moving, changing and loading/unloading data, sometimes destroying it is required, but Matillion is understandably light in these capabilities. For example, when we process data arriving via SFTP, once we're done, we like to move the files in question to somewhere indicating so, like a processed area, or even a failed area. It would be great if Matillion offered a way to do things like this, even if not a 'delete file', perhaps a 'move file' where you must provide a source/destination. A way to flush queued tasks without rebooting. Better task logging/communication features e.g. alerts, etc.,8,At first, we thought Matillion was too expensive until we realized and implemented the platforms ability to be deployed and used when needed. This has not only delivered solid ROI, but it's allowed us to start understanding ETL processes and heavy lifting as cost centers that can be attached to a project. Much of our ETL was previously being addressed by custom code, which limited our agility. Matillion has turned that around considerably. Because of its tight integration with Redshift and AWS, we can now explore, understand and ingest data from our customers much faster than before.,9,We were able to get Matillion up and running within days, and this was important because I needed to be able to sell the notion of this tool internally. To do this, I needed to emulate Matillion playing the role of a complex incumbent process in such a way that I could communicate and demonstrate it to key stakeholders in less than a month. In less than a week, our DevOps team provisioned the instance, and we hammered out a few basic processes to fetch data, transform it and load it. Over the course of the next couple weeks, we took the time to really explore the components and naturally we had questions. Matillion support had answers, often the same day. Finally, as the POC with the internal stakeholders approached, we generated fantastic looking (though very large in size ) documentation about our newly developed processes that we shared. Ultimately it was a pretty easy sell.,9,Amazon Redshift, PostgreSQL, Amazon KinesisMatillion: the last puzzle piece in modern analytical solutionsWithin the Business Analytics team, Matillion was introduced as a new ELT tool after team extension. In that time, we had four active BI developers and the main need was a centralized project repository that will make the daily workload easier. We are using Matillion for development and maintenance of the data warehouse and integration of more than 20 data sources.,Tailor-made for Redshift, including most of the features like Spectrum. Cloud-based solution with centralized project repository, easy team collaboration. Built-in scheduling and monitoring, everything in one place. Awesome support, the short time from raising a question to the solution providing.,Documentation is not always updated in time when new stuff is implemented. Some connectors already implemented still have some bugs which make them useless for our use case. Small fine tuning still missing, in terms of covering all use cases of some connectors.,10,Shorter time to market. Development from a month decreased to two weeks including testing. Developers are more focused (>80% of the time) on a specific topic instead of searching for different technical solutions.,9,After just two months we had complex processes running on a production environment. And now after six months, we became really proficient users of Matillion which are also taking care of optimization improvements and not just a development.,8,Talend Open Studio and IBM InfoSphere DataStage,Amazon Redshift, Microsoft Power BIEasy to use and priced right, but scaling with a team is difficultIt is being used across all of our internal data to bring data together for reporting. This includes Sales, Marketing, Billing, Support and ustomer activity. We have processes that run every minute as well as batch processes that run every day.,Quick access to Google Sheets data. Utilizes SQL well. Supports custom API data sources. Pricing is by server size not # of data sources or volume.,Source control integration is archaic and not implemented with teams in mind. Has some performance issues related to memory issues. Documentation is lacking and there is no real training available.,5,Big positive on price. Lack of documentation and training makes ramping up difficult. Source control integration makes team development risky.,8,I was up and running with Matillion in less than a week for the initial data sources. I pulled data from using pre-built components.,5,Pentaho, Databricks Unified Analytics Platform, Fivetran and Stitch,Looker, Amazon Redshift, Notepad++Matillion for Snowflake is a solid batch ETL toolMatillion for Snowflake is used by our Data Engineering team for developing data flows for extracting and transforming data into our Snowflake data lake. The data lake is available to the entire organization for analysis and decision support. We needed an ETL tool for batch processing for replacement of Airflow.,Ease of use. Suitable for developers from junior to senior. Connects to a variety of data sources and platforms. Matillion has many tools available for transforming data.,Does not integrate easily into the source code control system. The small instance needs more concurrent user connections. Two is too few, and moving to the next instance size does not make sense in our development environment. Matillion for Snowflake does not have a Dynamo DB connector.,8,The development to production flow for Matillion is straightforward.,7,We used the trial period for a proof of concept. Soon after that, we developed packages and moved them to production.,7,Snowflake, Google BigQuery, Google Analytics, Tableau Online, Google Data StudioMatillion has met the needs of our data warehousing and ETL better than we had exptectedMatillion is being used by Xyngular to ETL data from multiple environments into an AWS Redshift database. We also use it to pull data files from FTP and load them into the database. It also allows us to be very flexible on the scheduling of the jobs.,Loading an FTP file into the database. Transforming data before loading it into the database. Flexible scheduling of jobs. Straight data copy from one database to another.,When I make changes to a job and add fields to what is being pulled, I have to drop the entire list and repopulate it. Honestly, the first thing is the one part I have had issues with.,10,Matillion has provided a way for us to have near real-time viewing of metrics. Matillion has provided a way for us to do complex transformations on our data in a pipeline.,9,We were able to get up and running with Matillion very quickly. It took no more than a day or two.,9,,GitHubGreat product and great customer supportWe currently use Matillion for Redshift as our ELT tool for data retrieval, aggregation, and management. It is currently being used by multiple departments in our organization, including our data team and operations team. Having used Apache AirFlow, Matillion is a breath of fresh air. It is easy to use, easy to implement with a variety of technologies, and the support system is quick and convenient.,Easy to setup and provision Expert customer support,Can take some getting used to Inability to update/install Python libraries,8,Positive ROI, we used to have an in-house system that required 4 people to maintain and update. Matillion has done away with that.,8,Once we got our devops communicating with their devops it was up and running in less than week.,10,PostgreSQL, Amazon Simple Notification Service (SNS), AWS LambdaThe go to ELT solution for Redshift datawarehousesCurrently driving the ETL /ELT processes to load a Redshift Data warehouse. We have 5+ data sources that include on-premise/cloud databases, CRM and marketing tools that are feeding the data warehouse. Matillion is also used to automate various marketing processes.,Cloud-based solution Seamless integration with Redshift Minimum scripting required Good feature documentation Easy to learn/good tech support and tutorials,Installation/setup Better out of the box support for CRM tools like Zendesk would be helpful.,10,Limited the number of resources to invest in ETL work. Less technically inclined users could be involved.,10,I was possible to setup the tool within an hour from Amazon Marketplace and start the ETL/ELT processes.,9,Talend Data Integration and SQL Server Integration Services,Stitch, Periscope Data, ZapierMatillion For AllMatillion is being used in our company as an ELT tool. We load data into it from various sources, such as Salesforce, NetSuite, etc. We are exploring more such options, from there we can pull the data into matillion. Once in matillion, we transform this data using various components provided by the matillion tool to modify the data as we need. Then, once all the modification are in place we load the data into Snowflake which is our data warehouse,Data extraction is really quick and hassle-free. Transformation is very easy to perform as it provides an elaborate list of components that can be used to create and optimize your query. Scheduling is very manageable and easy to monitor and review. UI is very user-friendly, every component and sub-component can be understood by the help option provided as a hyperlink.,There can definitely be some improvements w.r.t the NetSuite orchestration component. We have had lots of trouble connecting it to Matillion during POC. Although the UI is quite user-friendly there is room for much improvement. There should be requirement specific customized training before a company starts working with Matillion. We got general training which definitely benefited us, I just think a more project-specific training would have been more useful,9,So far it is hard to tell whether Matillion has had a negative impact on our business objectives since we have been using Matillion for less than a year,8,Well, we worked on Matillion for roughly three months before actually acquiring the product. It was essential to first get training because you tend to miss out certain basic functionalities without a matillion expert guiding you. Also, once we had a little hands-on with the product it wasn't very difficult to get the whole transformation process started.,9,Teradata Database, Informatica Data Explorer, IBM InfoSphere DataStage and MySQL,Snowflake, Microsoft Access, Tableau DesktopFeedback on Matillion ELTWe're exploring Matillion as an ELT tool when we migrate our workloads to the cloud. This software is not in production yet as we're still exploring. Once accepted, this software will be used in our Information Management department. This business problem that is addressed by this software is ELT.,Drag n Drop to build orchestration and transformation jobs Simplicity Pay as you Go Ability to scale up and down Minimal code compared to the competition Cloud based,Ability to migrate jobs created for one platform to other easily (for e.g. from Redshift to Snowflake). There is a scope of improving developer productivity by enhancing the user interface. Sometimes the UI is confusing. Some times the orchestration and transformation job diagrams become very complex. Need to come up with design patterns for proper diagram preparation.,7,Pay as you model for ELT processing is appealing. Easy and quick to build simple orchestration and transformation jobs. Need more education material for greater adoption by the user community.,7,Simple transformation jobs are easy to build and run. We're able to build and run jobs within a week.,3,,Amazon Redshift, Amazon DynamoDB, Amazon Relational Database ServiceMatillion: ELT vs ETLWe are using Matillion within the Analytics department. We had a core need to be able to move data from multiple single-tenant client database sources into a proper data warehouse (AWS Redshift) for analytical reporting.,Easy drag and drop logic/control functions. Ability to script (in Python) when out of the box components are not enough. ELT vs ETL allows for super fast transformations done directly in Redshift.,We have had issues with out-of-memory errors when Matillion is up and running for a long time. For this reason, we've implemented an automated monthly restart job which works around this issue. We do a lot of "reverse ETL" processing. For certain use cases we need to run extracts out of the analytical data warehouse, massage the data, then move it back to our transactional databases for certain operational tasks. Although it is possible with certain components in Matillion, there could be more enhancements to those components to make life easier for some tasks.,9,Matillion was the key to be able to build on customer analytics feature About a year ago we had to upgrade to a more expensive instance/license of Matillion due to performance issues. We wish that we had the ability to just run our Matillion on bigger EC2 boxes that have more memory capacity, as that was our primary constraint, not concurrency of multiple users using Matillion. They only have a few license levels and the ROI is not completely there for moving up to higher level licenses.,9,We were able to get up and running with initial ELTs within a couple of days.,6,Fivetran,LookerMatillion ReviewWe are using it as the backbone for various projects we do for clients who possess large amounts of semi-structured data that they currently cannot use effectively. We ingest and transform their data using Matillion, storing it in Snowflake and building reports on it using Tableau. These projects are what we primarily use Matillion for. We're looking into using it across our organization to help manage data like our financials and other organizational metadata that we use to make business decisions.,Very intuitive/easy to learn and teach Great documentation Easy to spin up and get going,Version control is minimal. Tough to form a process for collaborative development around it. More thorough documentation around best practices specifically would be good. Sometimes the tool freezes up when a large number of processes are running.,8,Quite positive. It's much easier to train new hires on the system. Less maintenance required than running a DIY setup like Kylo (open source).,8,During our evaluation of different products on the market, I was able to spin up an instance, connect it to Snowflake, and create jobs that accomplished a specific business need in one day. Once we formally adopted it, it's taken us several weeks/a couple of months to convert our existing ETL processes into a Matillion workflow, simply because of how many existing processes we had. It is very easy to get running with it and start being productive.,9,Google BigQuery, Fivetran, Alooma, Amazon Redshift and Talend Open Studio,Snowflake, PostgreSQL, ElasticsearchMatillion, simple but powerfulMatillion is used by the Data Engineering team to load data into Amazon Redshift and to implement data transformations that produce the reporting layer of the data warehouse. The reporting layer is used across the organisation from everything from customer analytics to financial reporting.,Loading data into Redshift using bulk load utilities. ELT makes use of Redshift's MPP architecture. Very good UI, and intuitive to use. Choice of Python for custom code is good as it's an easy language.,Connectors to streaming solutions like Kafka would be a good addition. Some legacy component connectors are not available.,10,Reduced setup, and software update costs. Reduced training costs due to intuitive UI and lots of good documentation and how to videos.,10,Set up was done in less than an hour. This is a huge saving. We ingested about 130 data sets and about developed about 60 transformation steps in 5 months with a team of 4.,8,Talend Data Integration and Informatica Enterprise Data Integration,Talend Data Integration, Amazon Redshift, MySQLMatillion is an excellent modern cloud data orchestration choiceWe've deployed Matillion at several customers across many business units to orchestrate data movement and transformation from source systems to Redshift and Snowflake. It is a great solution for a customer looking for a cloud-based application to handle enterprise-scale data engineering tasks.,Push-down ELT design. Simple purchasing, pricing, setup, and usage. Powerful design patterns, and connectors.,Additional connectors to source systems are always needed. HA product engineering could be better.,10,Our customers who utilize Matillion achieve quicker data warehouse development project cycles and reduced spend.,9,Implementation with Matillion is very quick because of its ability to purchase it on-demand in the AWS Marketplace and get a trial instance running immediately. Converting that instance to production once the trial has expired is painless as well.,9,Informatica Enterprise Data Integration, SQL Server Integration Services, IBM InfoSphere DataStage, Oracle Data Integration Platform Cloud and Talend Cloud Integration,Tableau Desktop, Snowflake, Alteryx AnalyticsBuild your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needsWe are using Matillion to centralize our data to a new data warehouse. Our primary use case is pulling data from a relational database (MySQL). I've been able to implement three different flavors of data sourcing, the two primary types being a full table load and incremental data loading of changed data into Slowly Changing Dimension and Fact tables in the DW. The performance of Matillion combined with Snowflake is astoundingly fast. We are also able to hit APIs to Zendesk and Hubspot easily to round out our integration with other SaaS vendors in our stack.,Push down query performance with Snowflake. The ability to hit any API using Python. A robust offering of pre-built connectors to databases, APIs, and other SaaS vendors.,No user community site for experienced developers to share their patterns and help grow the dev community Documentation can get stale or be changed without notice. Several aspects of the product are not user-friendly, and if implemented by an experienced product/UX person it would make the product easily 2x to 3x better. No ability to vote on what features are in the pipeline.,9,Able to react to changing data quality issues caused upstream Ability to handle massive scaling issues with ease Ability to connect to more SaaS vendors as our business needs change,9,My learning curve was long. Matillion is simply not like any other ETL / ELT tool out there, because Snowflake isn't like other cloud databases out there. I had to first learn a different pattern of data movement and error checking. Next, I had to learn which components to use and when. There aren't any good in-depth how-to guides out there. There aren't really detailed instructions on how to implement a specific pattern and what challenges you are going to face and how to handle them. There isn't a site for users and developers to hang out and ask questions, there is only the support ticket queue and some very knowledgeable and helpful Matillion engineers to answer your questions.,10,Fivetran, Stitch, Talend Data Integration, Trifacta and Alooma,Looker, Snowflake, JIRA Software, Atlassian Confluence, Amazon Elastic Compute Cloud (EC2)MatillionMatillion is used by the BI team as our ELT tool. It's not used by the rest of the organization, but they get the benefits. It helps us keep logic all in one place, and is a foundation piece of our data pipeline. It also allows us to quickly work with data and get it into the format required for data purposes.,Speed to connect to data sources; the power of ELT tools is in pre-built integrations. Support services are excellent and very quick to respond My devs enjoy using it. It has an easy simple GUI and allows for repeatable processes.,It's very hard to version control out of your system. If I connect to Git it's impossible to tell the changes that we have made. It's the same for most GUI tools, but I would love to solve that. Documentation is sometimes slow to keep pace with the changes in the tool, meaning confusion or lost time. It's not clear what integrations are coming next. Changing things across multiple workflows is quite involved and doesn't easily allow us to make changes across our entire ELT section. We had to build all logging ourselves. Matillion tells us easily that a job failed, but it's hard to extract in an automated way why it failed.,7,Increased speed to insight reduced amount of time spent on managing logic Add robustness and repeatability into data pipeline,7,Fairly quick, Matillion was not our bottleneck. The learning curve was still a point that our developers had to overcome so anything more you can do ere to help that would be best. Also would have been brilliant for someone to share best practice, talk-through the set-up and how to leverage it. What things to avoid etc!,5,Alteryx Analytics and AWS Lambda,Snowflake, Tableau Desktop, Google AnalyticsMatillion brings the power of data to the people!We use Matillion to consume our SaaS data organization-wide. From this data, we build dashboards to operate the business including finance, employee productivity, and sales. By leveraging our data sources in real time, it allows us to make better data-driven decisions, and prevent operating by the seat of our pants.,Connect to third-party data sources using a generic API interface Wide support for a number of databases and data platforms Pay as you go model brings extreme power in a cost-effective package,Oauth2 support for refresh tokens needs some work,10,Matillion provides immediate ROI due to its powerful interface and pay by the hour model.,10,We were up and running in a number of days. Matillion provided great onboarding, training, and online resources to get started.,10,Fivetran,Looker, Asana, G Suite
  3. Matillion Reviews
Unspecified
Matillion
95 Ratings
Score 7.9 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Matillion Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Matillion
95 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Filter 95 vetted Matillion reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Show All Filters
More Filters 
Less Filters 

Reviews (1-25 of 60)

Do you use this product? Write a Review
Adam Labay profile photo
June 28, 2019

Excellent Entry-Level ETL/ELT Resource

Adam Labay
Score 9 out of 10
Vetted Review
Verified User
Review Source
We used Matillion on a small, 3-person team to manage ingestion and transformation for our data warehouse, pulling from numerous datastores and vendors to a common warehouse schema.
  • Shallow learning curve - Matillion is powerful, but only as complicated as you need at a given time.
  • Superb helpdesk and documentation.
  • Jobs are translated directly to SQL which makes them easy to debug.
  • Parsing of flat files is inconsistent depending on the source
  • The product is constantly evolving (good!) but that means relearning parts of the interface every few months
  • Support for a larger set of APIs and database engines would be helpful
Matillion is great for a team's first foray into ETL. It holds your hand exactly as much as is needed, and scales brilliantly within the scope of a small team. It becomes less ideal as you add more data sources and processing. It interacts well with Python, but any other scripting is harder to integrate.
Read Adam Labay's full review
Patrick Hildreth profile photo
June 17, 2019

Matillion is a powerful and easy-to-use, completely cloud-capable ETL/ELT solution.

Patrick Hildreth
Score 10 out of 10
Vetted Review
Verified User
Review Source
We are currently using Matillion as our primary ETL/ELT tool both in our department and supporting others in the organization as well as introducing it to other Business units under the Cimpress brand. For us and others it primarily solves the need of loading and manipulating raw data from multiple sources and making it available in both Redshift and Snowflake. Additionally, the flexibility of the tool and its seamless integration with the complete AWS Services library allows us to perform many operational tasks that are completely unrelated to the ETL/ELT workload.
  • Integrates very well with most, if not, all AWS services - Easy to get data from anywhere inside your AWS account into Redshift or Snowflake databases.
  • It has many available integrations and datasource connectivity outside of AWS and other cloud service providers - Makes it easy to get data from many sources and systems in more traditional on or off premise technologies as well as vendor-specific data and application interfaces.
  • Very intuitive, easy-to-learn-and-use interface with a large collection online tutorial articles and videos - makes for an extremely easy onboarding of users who may or may not have past experience with other similar tools.
  • Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
  • Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
  • Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
It is very easy to set up and get working on right away, anyone with access to an AWS account and the Marketplace can have a fully capable ETL server up and running in under 10 minutes and the 14-day free period allows an adequate amount of time to decide whether the tools works for your use-case. It has a direct hourly billing option that bills through your monthly AWS bill and the option to pay-as-you-go or pay up front and reserve an instance at nicely discounted rate. Overall it's the usability, flexibility, and capability that made Matillion the choice for me.
Read Patrick Hildreth's full review
Sudarshan Kothari profile photo
June 11, 2019

Matillion Review

Sudarshan Kothari
Score 8 out of 10
Vetted Review
Verified User
Review Source
iQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.
  • Supports a wide variety of digital platform connectors, which could be helpful for any industry working to automate any of their reporting needs.
  • Support for AWS technologies adds to greater advantage.
  • Takes up unique functionality provided by the database into account which is very helpful.
  • Also provides direct SQL query feed-in option for any migration of existing solution.
  • With the added functionality available in Matillion, the understanding to use complex features becomes challenging for a new development team.
  • Updates are regularly provided by Matillion support team but then they fail to specify the release document, new features or updates carried out in each update.
  • Validation failure in scheduled jobs is sometimes encountered without any reason or proper RCA.
  • Complex user management flow.
Matillion works best when automating the workflow from the various digital platforms. It provides the best use-case for automation of any dashboarding/reporting requirement where data is stored in one of the databases and updated regularly. Matillion might not be the best use-case for core ETL operation as it lacks stability for enterprise (but is improving to high standards with every update).
Read Sudarshan Kothari's full review
Kris Shinn profile photo
May 27, 2019

2 Years with Matillion

Kris Shinn
Score 8 out of 10
Vetted Review
Verified User
Review Source
Matillion is used in our Data Analytics and Data Engineering department. At the time we purchased it, we had no dedicated data engineers. We needed something powerful enough to handle more complex jobs, but simple enough that a semi-technical analyst could use. We were using a lot of different tools at the time and were evaluating a lot of different ETL solutions in the space.
Matillion provided a solution that was simple, easy to connect, and also provided Internet connectors to some of our most crucial systems, such as Salesforce and Jira. It has allowed us to consolidate much of our processes onto a single system that is easily understood.
  • Cloud connectivity: It makes pulling data from cloud services like Salesforce super simple and easy to bring into a data warehouse
  • ETL Orchestration: The drag and drop interface makes it easy to compose new orchestration layers in our ETL. It's something that does not require a Data Engineer to complete.
  • Enterprise integration: It was really easy to configure into our LDAP system, and that makes administering the box really easy.
  • Variety of Data sources: It is pretty easy to bring data into Matillion to process into the data warehouse.
  • The Gui provides other non-functional visual elements to mark up the job. This is great for team members to communicate complicated parts of the ETL or to otherwise label parts of their ETL.
  • Matillion has no clustering ability. For particularly large jobs or large data sources, processing can take a long time and it does not have the ability to map-reduce, like Spark.
  • The output is limited to Redshift. Often times we would want to drop a Parquet or Avro file into s3 as the output of our ETL.
  • We often get OOM errors and other server related constraints. We need to be very careful about how our jobs are scheduled in order to make everything work well.
  • It is not clear from the documentation how to organize work in Matillion. Between environments, projects, and jobs in a project, we've had to organize in a way to accommodate for Matillion's limitations, which doesn't allow us to organize our jobs in a way that makes sense for us.
Matillion is great at processing an ETL for cloud-based systems (Jira, Salesforce, Google Analytics, etc). It reduces (or in some cases eliminates) the need to put together a custom software interface into these systems. It is also great for non-technical users who want to put together some ETL processes for analytics, but do not want to invest into a Data Engineering team. It's also great for landing data for consumption into end datastores like Snowflake or Redshift.
Matillion is not great for large datasets or prepping for data science. As a single vertically scaled solution, it does not have the power of a cluster oriented ETL technology like Spark. Additionally, to prepare datasets for data science where you would want to bring in a processed dataset in Parquet or Avro formats, it requires you to land the data into Redshift and then dump it back out, then format it, in order to get it into a portable format for something like RStudio.
Read Kris Shinn's full review
Matthew Burr profile photo
May 23, 2019

Ease of Use and Reusability for Excellent ROI

Matthew Burr
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Matillion to bring together data from multiple sources - our application, Salesforce, Qualtrics, etc. - into a central data warehouse for use throughout the business in reporting, both internally and externally. Matillion performs the ETL that transforms this raw data into a structure in Redshift useful for reporting.
  • It integrates well with Amazon Web Services, like S3 and Redshift
  • It makes good use of Redshift to perform ETL quickly
  • The ability to parameterize ETL jobs with variables makes it possible to get a lot of reuse from ETL jobs
  • Integration with source control is a challenge; we had to roll our own solution to pull our Matillion jobs via its API into files we could add to source control
  • It can be a challenge to avoid conflicts when multiple people are developing jobs in the same project
  • It's only available on Redhat flavors of Linux (e.g. Amazon Linux, Redhat, CentOS)
Matillion is really well suited to environments using Redshift or Snowflake, and that rely on Amazon Web Services. It is also well suited to scenarios where you need to perform a lot of similar ETL tasks with small variations that could be parameterized. It's great if you want to get up-and-running quickly, and don't want to spend a ton of time in configuration and setup; you can get going very quickly out-of-the-box. It would be less appropriate in on-premise scenarios, where all of your data is stored on-premise. If you don't use AWS, you won't get as much value out of it. Also, in environments with large teams and lots of developers modifying jobs simultaneously, it can be a challenge to coordinate work and manage changes.
Read Matthew Burr's full review
Oleg Ivashov profile photo
May 10, 2019

Matillion ETL for Amazon Redshift

Oleg Ivashov
Score 10 out of 10
Vetted Review
Verified User
Review Source
I met with Matillion team at AWS Summit 2018 at Sydney, Australia. At that time we were using legacy ETL for our Redshift Data Warehouse.
We were trying to adopt Continuous Integration/Continuous Delivery framework for our ETL and found it to be challenging for our environment. It was time to look for something new and say goodbye to our bellowed legacy ETL. So we had a conversation with Matillion team and quickly decided to do a POC. We've evaluated couple of other tools in the past but nothing came close to Matillion.
First of all, setup was a breeze. The migration was quick and painless, the system is very easy to work with. Almost more importantly, the Matillion team is very friendly and always willing to help, their support is outstanding! Matillion has dozens of native connectors out of the box, so we had no problem with integrations at all. In fact, migration to Matillion allowed us to drop couple of third party legacy ETL components required for AWS infrastructure.
Python scripts component allows to use Boto3 and hundreds of other libraries, so practically there is no limit of where you can use Matillion.
We were finally able to build full scale CI/CD pipeline. Our setup uses combination of JIRA, Bitbucket and Bamboo build server and it works like a charm, thanks to Matillion'™s REST API.
  • Works very well with Redshift and integrates with other AWS Services, such as S3, SNS or SQS for example
  • Has scripting components like Python using Boto and any other libraries. Additional libraries need s to be installed on Matillion EC2 instance
  • Plenty of data sources out of the box, the rest can be pulled via API
  • Automatic validation of database objects and components
  • Easy to install
  • Excellent integration with CI/CD
  • Minor: Changes to the ETL can only be reviewed in Matillion GUI rather than true source code diff, i.e. Bitbucket
Fast and easy way to bring all of company's data into Redshift data warehouse. We haven't come across anything which Matillion cannot handle yet. We even control Redshift workload management (WLM) parameters from Matillion, that is we give ETL more Redshift resources during the actual ETL running time earlier morning and then take them back and give to analysts.
Read Oleg Ivashov's full review
Gary Pope profile photo
May 08, 2019

Matillion: Fast ELT with a whole lot more

Gary Pope
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Matillion to load millions of rows of data each and every day. We got our warehouse up and running using Matillion in just a few months. We use it for all our reporting and have built out our commissions processes using this tool. We are able to connect data from multiple sources into one coherent location that makes our reporting so much easier.
  • Matillion is an ELT tool rather than an ETL tool. This means that it's using the database engine to manipulate data. Much faster than a traditional ETL tool where speed is lost in the movement of data.
  • Building Transformation Jobs. The flow-chart style developer interface makes it simple and easy to build jobs. But underlying that is the ability to create complex SQL and/or Python components which make just about anything you can think of possible.
  • AWS integration. The integration with AWS allows a multitude of possibilities such as automatically kicking off jobs when a file is loaded in S3 or sending a notification of job success or failure via SNS.
  • Matillion has some limited capabilities when interacting with other databases outside of Redshift and RDS. Getting data from other databases is pretty easy. Putting data back into databases other than Redshift and RDS is more limited. That said, it's specifically built to load Redshift and that it does well.
  • There are times when I get disconnected from the server. This may happen once or twice a day. Nothing is lost and it's a simple matter of logging back in. It's not my internet either as my coworkers in different areas of the country experience the same thing. I have seen some improvement in some of the later releases.
If you have a Redshift database this tool is specifically built for you. It allows you to automate the loading of the data warehouse easily. It's scheduling ability allows you to time the load when you want and it's notification ability allows you to make sure it has loaded successfully. It translates your jobs into SQL that is run within the Redshift environment which makes it very fast. Tracking of the jobs and logging is quite helpful when tracing any issues that might have come up.
Read Gary Pope's full review
Polina Moore profile photo
April 19, 2019

Very user-friendly product that fills a niche for AWS Integration.

Polina Moore
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Matillion as the new ETL tool for building Data infrastructure for the company. Our Data team is limited to 2 Matillion users but the Data infrastructure will be used by the BI team to help all areas of the business. So far, we've used it for various data loading tasks but are starting to use for the new Data Warehouse processes we'll be building.
  • Data Mapping - it is really good at recognizing the source and destination data types and does a great job at converting data types.
  • User-Friendly Interface - development is very easy within the tool and very intuitive for Data experts.
  • Troubleshooting - for the most part, it gives informative messages when errors occur and it is extremely useful to see data transformation 'in-flight' through data sampling.
  • Deployment to other Environment - this is not a smooth process and needs improvements. Better integration with code repository and smooth deployment of changes is needed (for example, just exporting variable default values is very clunky).
  • Documentation - for the version of Matillion we are using, we can't export documentation for our jobs. Since this is the level of functionality we need, it sounds unreasonable that to get a couple of more features (one of them being Documentation), we would need to upgrade to a higher level of license that would cost twice as much).
  • Running queries on other databases - although we primarily want to load data into Redshift, we sometimes need to run quick queries as part of the process against non-Redshift databases (that are not straight loads from the DB to Redshift). Although we can do this through Python, it would be a lot more helpful to be able to do this within Matillion components.
For a more comprehensive tool that is designed to work with Redshift, Matillion currently fills a niche with no good alternatives out there. If we were going to use a different database, there are other ETL tools that would perform that job and have a wider range of functionality. We have use cases to parse XML data and load it and although we have only started testing that functionality, we are not convinced Matillion has the most user-friendly interface for that (or that it will work in the end for huge XML files). For most of our processes of consolidating data (loading it from various sources and files), Matillion works really well.
Read Polina Moore's full review
Nick Wardle profile photo
April 17, 2019

Matillion makes ETL pipeline creation and management easy and extensible

Nick Wardle
Score 10 out of 10
Vetted Review
Verified User
Review Source
Matillion is a fundamental part of our ETL pipeline creation and management. It is the solution we have chosen that enables myriad external data sources (APIs, CSVs, data lakes etc.) to be ingested into our data warehouse. As a tool for its specific purpose, it is primarily used by the Data Science team, but the resulting data is disseminated to multiple departments via dashboards and reports across the whole company.
  • It provides a simple and intuitive visual interface for ETL creation and management that is also highly flexible and extensible i.e. integrating custom Python scripts
  • It makes complex, advanced workflows, e.g. updating, scheduling, error handling & reporting, simple with pre-existing drag-n-drop "feature blocks"
  • It makes the creation of a clear, hierarchical architecture across all pipelines simple and easily replicable by all members of the team
  • Matillion's support team is highly responsive and always do their best to address issues as quickly as possible
  • Whilst the pre-existing "feature blocks" do make creating new API integrations simple, fine tuning the integration or ironing out minor bugs requires conversations with Matillion support (however, they are always very quick to respond and have always fixed our issues)
  • Minor feature request: It would be nice to have a way to pass the output of a Python script directly to a subsequent SQL "block"
Matillion is an excellent solution for teams wanting to create and manage ETL pipelines for integration of external data sources into, for example, a data warehouse. There are many pre-existing "feature blocks" for most of the major data providers (Facebook, Google Analytics, Big Query, Twitter and many more) which makes setting up pipelines for those APIs trivial. For data sources that do not have a pre-existing "block", Python can be integrated directly with SQL in the pipelines allowing for custom integrations.
Read Nick Wardle's full review
Edward Hunter profile photo
April 17, 2019

Matillion has made complex ETL of massive quantities of variably structured data approachable for us.

Edward Hunter
Score 8 out of 10
Vetted Review
Verified User
Review Source
Our company, Clutch, ingests, transforms and otherwise manipulates massive quantities of retail customer data every day. Because even retailers in the same verticals each bear different processes, structures and even attributes within their data, we needed a tool to help us rapidly develop ETL and we needed one tailored to working with advanced columnar data and storage, such as Amazon's Redshift column store database and S3 cloud data storage. While we're cost sensitive, we also didn't want to reinvent the wheel.

More importantly, we wanted to avoid a cloud-based product that tried to act like traditional enterprise ETL tools like Informatica or SSIS, only to find ourselves using clunky, complicated and undiscoverable browser-based tools.

Finally, we are a shop that often 'fixes tires on a moving car', and so the tool we chose needed to be intuitive, the support behind it responsive and amazing. Matillion has served these needs and more, quickly becoming a go-to part of most of our data solutions, and becoming increasingly visible in other areas as well, such as reporting on cloud-based systems like Salesforce and JIRA.
  • Matillion (for Redshift) understands working with Redshift, and it's components adapt well to changing aspects of extraction, transformation, and loading.
  • Because Matillion is pay for actual use, we only pay for the uptime of our instance. This is way more powerful than we expected, as we're able to maintain task-specific Matillion instances that are brought online to handle workloads, then taken down when not in use.
  • Matillion's support is probably the best there is, for any software. You're never asked the proverbial 'is the machine on' type questions, they always get back to you faster than expected, and the people conducting the support are definitely not reading scripts. They know what you're trying to do because they've probably done it.
  • Matillion often surprises us with it's flexibility and adaptability to tasks, even some you'd normally consider being outside the purview of traditional ETL.
  • While ETL usually involves fetching, moving, changing and loading/unloading data, sometimes destroying it is required, but Matillion is understandably light in these capabilities. For example, when we process data arriving via SFTP, once we're done, we like to move the files in question to somewhere indicating so, like a processed area, or even a failed area. It would be great if Matillion offered a way to do things like this, even if not a 'delete file', perhaps a 'move file' where you must provide a source/destination.
  • A way to flush queued tasks without rebooting.
  • Better task logging/communication features e.g. alerts, etc.
Matillion is great for quickly hammering out ETL processes and getting them up and running. It could be better at 'productionalizing' though, perhaps by bundling alerts and communication into its scheduling capabilities. While Matillion works well with AWS resources like Redshift, S3, and SQS, being able to integrate things like S3 triggers and Lambda functions would allow less development of custom processes that occur outside the platform.

Matillion being a pay-while-using platform makes it ideal for compartmentalizing processes. If you want to create cost centers around the heavy lifting involved in a particular project, you can have a specific Matillion instance address the needs by spinning instances up and down when needed. This tasking and scheduling however, must largely be driven by utilities outside Matillion. But, while Matillion support and blogs are super informative and ready to deliver solutions to implementing things like this, it would be great if the platform itself integrated with things like Cloudwatch events to help schedule and manage its uptime, downtime and operating costs.
Read Edward Hunter's full review
Aleksa Topalović profile photo
June 10, 2019

Matillion: the last puzzle piece in modern analytical solutions

Aleksa Topalović
Score 10 out of 10
Vetted Review
Verified User
Review Source
Within the Business Analytics team, Matillion was introduced as a new ELT tool after team extension. In that time, we had four active BI developers and the main need was a centralized project repository that will make the daily workload easier. We are using Matillion for development and maintenance of the data warehouse and integration of more than 20 data sources.
  • Tailor-made for Redshift, including most of the features like Spectrum.
  • Cloud-based solution with centralized project repository, easy team collaboration.
  • Built-in scheduling and monitoring, everything in one place.
  • Awesome support, the short time from raising a question to the solution providing.
  • Documentation is not always updated in time when new stuff is implemented.
  • Some connectors already implemented still have some bugs which make them useless for our use case.
  • Small fine tuning still missing, in terms of covering all use cases of some connectors.
If you are in a situation that includes Redshift, a whole AWS platform and developing modern analytical solutions, Matillion is the tool that could improve your whole platform. Instead of writing complex scripts you have possibilities to design the whole process that is also understandable for business users also at the first look - implementing business logic is faster. Using the power of the Redshift you have an impression of instantly doing a job. Matillion also covers some other use cases like processing and integrating unstructured data so that all business needs could be satisfied. At the end synchronization with other tools also works fine so the whole BI process from data to insights is shorter.
Read Aleksa Topalović's full review
Bryan Boutwell profile photo
June 05, 2019

Easy to use and priced right, but scaling with a team is difficult

Bryan Boutwell
Score 5 out of 10
Vetted Review
Verified User
Review Source
It is being used across all of our internal data to bring data together for reporting. This includes
Sales, Marketing, Billing, Support and ustomer activity. We have processes that run every minute as well as batch processes that run every day.
  • Quick access to Google Sheets data.
  • Utilizes SQL well.
  • Supports custom API data sources.
  • Pricing is by server size not # of data sources or volume.
  • Source control integration is archaic and not implemented with teams in mind.
  • Has some performance issues related to memory issues.
  • Documentation is lacking and there is no real training available.
Matillion is well suited for people with SQL skills and makes it simple to get data into a database quickly without much dev time required.

Source control is not well thought out and is basically unusable.
Read Bryan Boutwell's full review
Bianca Levy profile photo
May 25, 2019

Matillion for Snowflake is a solid batch ETL tool

Bianca Levy
Score 8 out of 10
Vetted Review
Verified User
Review Source
Matillion for Snowflake is used by our Data Engineering team for developing data flows for extracting and transforming data into our Snowflake data lake. The data lake is available to the entire organization for analysis and decision support. We needed an ETL tool for batch processing for replacement of Airflow.
  • Ease of use.
  • Suitable for developers from junior to senior.
  • Connects to a variety of data sources and platforms.
  • Matillion has many tools available for transforming data.
  • Does not integrate easily into the source code control system.
  • The small instance needs more concurrent user connections. Two is too few, and moving to the next instance size does not make sense in our development environment.
  • Matillion for Snowflake does not have a Dynamo DB connector.
Matillion is great for scheduled batch processing, but not so great for stream processing.
Read Bianca Levy's full review
Travis Schaugaard profile photo
May 24, 2019

Matillion has met the needs of our data warehousing and ETL better than we had exptected

Travis Schaugaard
Score 10 out of 10
Vetted Review
Verified User
Review Source
Matillion is being used by Xyngular to ETL data from multiple environments into an AWS Redshift database. We also use it to pull data files from FTP and load them into the database. It also allows us to be very flexible on the scheduling of the jobs.
  • Loading an FTP file into the database.
  • Transforming data before loading it into the database.
  • Flexible scheduling of jobs.
  • Straight data copy from one database to another.
  • When I make changes to a job and add fields to what is being pulled, I have to drop the entire list and repopulate it.
  • Honestly, the first thing is the one part I have had issues with.
We also use AWS pipelines to pull data from one environment to another. It works great for a straight data copy. However, it doesn't allow much transforming of the data. Matillion provides a much better way to make transformations on the data prior to loading it into the database.
Read Travis Schaugaard's full review
Joshua Stewart profile photo
May 23, 2019

Great product and great customer support

Joshua Stewart
Score 8 out of 10
Vetted Review
Verified User
Review Source
We currently use Matillion for Redshift as our ELT tool for data retrieval, aggregation, and management. It is currently being used by multiple departments in our organization, including our data team and operations team. Having used Apache AirFlow, Matillion is a breath of fresh air. It is easy to use, easy to implement with a variety of technologies, and the support system is quick and convenient.
  • Easy to setup and provision
  • Expert customer support
  • Can take some getting used to
  • Inability to update/install Python libraries
For our organization Matillion has been a great tool for us and allows easy compartmentalization of processes that allows for easy debugging and extending capabilities.
Read Joshua Stewart's full review
Arnob Bordoloi profile photo
May 22, 2019

The go to ELT solution for Redshift datawarehouses

Arnob Bordoloi
Score 10 out of 10
Vetted Review
Verified User
Review Source
Currently driving the ETL /ELT processes to load a Redshift Data warehouse. We have 5+ data sources that include on-premise/cloud databases, CRM and marketing tools that are feeding the data warehouse. Matillion is also used to automate various marketing processes.
  • Cloud-based solution
  • Seamless integration with Redshift
  • Minimum scripting required
  • Good feature documentation
  • Easy to learn/good tech support and tutorials
  • Installation/setup
  • Better out of the box support for CRM tools like Zendesk would be helpful.
Suited for:
1. People looking for cloud-based ETL/ELT solutions.
2. Works great with Amazon Redshift data warehouses.
3. Large transformation jobs, as it leverages the power of redshift to run transformations.
4. Great UI for users to create, maintain and document jobs.
Read Arnob Bordoloi's full review
Tanishka Tikoo profile photo
May 22, 2019

Matillion For All

Tanishka Tikoo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion is being used in our company as an ELT tool. We load data into it from various sources, such as Salesforce, NetSuite, etc. We are exploring more such options, from there we can pull the data into matillion. Once in matillion, we transform this data using various components provided by the matillion tool to modify the data as we need. Then, once all the modification are in place we load the data into Snowflake which is our data warehouse
  • Data extraction is really quick and hassle-free.
  • Transformation is very easy to perform as it provides an elaborate list of components that can be used to create and optimize your query.
  • Scheduling is very manageable and easy to monitor and review.
  • UI is very user-friendly, every component and sub-component can be understood by the help option provided as a hyperlink.
  • There can definitely be some improvements w.r.t the NetSuite orchestration component. We have had lots of trouble connecting it to Matillion during POC.
  • Although the UI is quite user-friendly there is room for much improvement.
  • There should be requirement specific customized training before a company starts working with Matillion. We got general training which definitely benefited us, I just think a more project-specific training would have been more useful
Matillion is well suited for all such projects where there is a need for extraction transformation and loading made easy. You can avoid the long cumbersome SQLs by using the various components provided by matillion. It is a fresh new tool which has a lot of potential and a lot of exploring is still required.
Read Tanishka Tikoo's full review
Srinivas Velamuri profile photo
May 22, 2019

Feedback on Matillion ELT

Srinivas Velamuri
Score 7 out of 10
Vetted Review
Verified User
Review Source
We're exploring Matillion as an ELT tool when we migrate our workloads to the cloud. This software is not in production yet as we're still exploring. Once accepted, this software will be used in our Information Management department. This business problem that is addressed by this software is ELT.
  • Drag n Drop to build orchestration and transformation jobs
  • Simplicity
  • Pay as you Go
  • Ability to scale up and down
  • Minimal code compared to the competition
  • Cloud based
  • Ability to migrate jobs created for one platform to other easily (for e.g. from Redshift to Snowflake).
  • There is a scope of improving developer productivity by enhancing the user interface. Sometimes the UI is confusing.
  • Some times the orchestration and transformation job diagrams become very complex. Need to come up with design patterns for proper diagram preparation.
For simple business logic, Matillion seems to fit the bill. As the business logic becomes more and more complex, Matillion has to show customers how can they build transformation jobs with complex logic.
Read Srinivas Velamuri's full review
Clark Huang profile photo
May 18, 2019

Matillion: ELT vs ETL

Clark Huang
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using Matillion within the Analytics department. We had a core need to be able to move data from multiple single-tenant client database sources into a proper data warehouse (AWS Redshift) for analytical reporting.
  • Easy drag and drop logic/control functions.
  • Ability to script (in Python) when out of the box components are not enough.
  • ELT vs ETL allows for super fast transformations done directly in Redshift.
  • We have had issues with out-of-memory errors when Matillion is up and running for a long time. For this reason, we've implemented an automated monthly restart job which works around this issue.
  • We do a lot of "reverse ETL" processing. For certain use cases we need to run extracts out of the analytical data warehouse, massage the data, then move it back to our transactional databases for certain operational tasks. Although it is possible with certain components in Matillion, there could be more enhancements to those components to make life easier for some tasks.
If you have lots of data from multiple transactional data sources and schemas that you need to iterate through and combine into a data warehouse, then Matillion was the easiest solution we found when we were in our proof of concept phase 3 years ago. We had some performance issues initially, but Matillion support and account management were able to help us through those, and now it has been running very smoothly for the last year.
Read Clark Huang's full review
Caleb Dinsmore profile photo
May 08, 2019

Matillion Review

Caleb Dinsmore
Score 8 out of 10
Vetted Review
Verified User
Review Source
We are using it as the backbone for various projects we do for clients who possess large amounts of semi-structured data that they currently cannot use effectively. We ingest and transform their data using Matillion, storing it in Snowflake and building reports on it using Tableau. These projects are what we primarily use Matillion for. We're looking into using it across our organization to help manage data like our financials and other organizational metadata that we use to make business decisions.
  • Very intuitive/easy to learn and teach
  • Great documentation
  • Easy to spin up and get going
  • Version control is minimal. Tough to form a process for collaborative development around it.
  • More thorough documentation around best practices specifically would be good.
  • Sometimes the tool freezes up when a large number of processes are running.
Well Suited For:
  • If you are wanting to use a data warehouse solution like Snowflake but need more flexibility/power for getting data into Snowflake (and manipulating it when it's there).
  • If your data scientists/analysts aren't especially tech-savvy. Its interface is easier for less technically-inclined users to understand.
Less Appropriate When:
  • You aren't using Snowflake, BigQuery, Redshift, etc.
  • The quantity/complexity of the data you're working with is minimal/not very difficult to manage.
  • You want to transform your data before loading (ETL vs ELT).
Read Caleb Dinsmore's full review
Krishna Naidu profile photo
May 03, 2019

Matillion, simple but powerful

Krishna Naidu
Score 10 out of 10
Vetted Review
Verified User
Review Source
Matillion is used by the Data Engineering team to load data into Amazon Redshift and to implement data transformations that produce the reporting layer of the data warehouse. The reporting layer is used across the organisation from everything from customer analytics to financial reporting.
  • Loading data into Redshift using bulk load utilities.
  • ELT makes use of Redshift's MPP architecture.
  • Very good UI, and intuitive to use.
  • Choice of Python for custom code is good as it's an easy language.
  • Connectors to streaming solutions like Kafka would be a good addition.
  • Some legacy component connectors are not available.
Matillion is great for cloud data warehouses. It's easy to get set up and use straight away. It's easy to purchase and comes through in AWS billing.

Direct integration with Kafka would complete the solution for us.
Read Krishna Naidu's full review
Brian Bickell profile photo
April 27, 2019

Matillion is an excellent modern cloud data orchestration choice

Brian Bickell
Score 10 out of 10
Vetted Review
Reseller
Review Source
We've deployed Matillion at several customers across many business units to orchestrate data movement and transformation from source systems to Redshift and Snowflake. It is a great solution for a customer looking for a cloud-based application to handle enterprise-scale data engineering tasks.
  • Push-down ELT design.
  • Simple purchasing, pricing, setup, and usage.
  • Powerful design patterns, and connectors.
  • Additional connectors to source systems are always needed.
  • HA product engineering could be better.
Matillion is an excellent choice as a modern cloud data orchestration solution to pair with modern cloud data warehouse options like Snowflake, Redshift or BigQuery.
Read Brian Bickell's full review
Jay Archer profile photo
April 19, 2019

Build your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needs

Jay Archer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using Matillion to centralize our data to a new data warehouse. Our primary use case is pulling data from a relational database (MySQL). I've been able to implement three different flavors of data sourcing, the two primary types being a full table load and incremental data loading of changed data into Slowly Changing Dimension and Fact tables in the DW. The performance of Matillion combined with Snowflake is astoundingly fast. We are also able to hit APIs to Zendesk and Hubspot easily to round out our integration with other SaaS vendors in our stack.
  • Push down query performance with Snowflake.
  • The ability to hit any API using Python.
  • A robust offering of pre-built connectors to databases, APIs, and other SaaS vendors.
  • No user community site for experienced developers to share their patterns and help grow the dev community
  • Documentation can get stale or be changed without notice.
  • Several aspects of the product are not user-friendly, and if implemented by an experienced product/UX person it would make the product easily 2x to 3x better.
  • No ability to vote on what features are in the pipeline.
Great if you need a visual, customized, powerful data engineering and data integration platform that can do pretty much anything. I have yet to hit a situation that I can't solve one way or another.
Not great if you only have time for a plug-and-play solution. This is not Stitch or Fivetran, but if you invest the time to learn and use Matillion you can end up with a vastly better solution to your data needs.
Read Jay Archer's full review
Mark Grace profile photo
April 19, 2019

Matillion

Mark Grace
Score 7 out of 10
Vetted Review
Verified User
Review Source
Matillion is used by the BI team as our ELT tool. It's not used by the rest of the organization, but they get the benefits.
It helps us keep logic all in one place, and is a foundation piece of our data pipeline. It also allows us to quickly work with data and get it into the format required for data purposes.
  • Speed to connect to data sources; the power of ELT tools is in pre-built integrations.
  • Support services are excellent and very quick to respond
  • My devs enjoy using it. It has an easy simple GUI and allows for repeatable processes.
  • It's very hard to version control out of your system. If I connect to Git it's impossible to tell the changes that we have made. It's the same for most GUI tools, but I would love to solve that.
  • Documentation is sometimes slow to keep pace with the changes in the tool, meaning confusion or lost time.
  • It's not clear what integrations are coming next.
  • Changing things across multiple workflows is quite involved and doesn't easily allow us to make changes across our entire ELT section.
  • We had to build all logging ourselves. Matillion tells us easily that a job failed, but it's hard to extract in an automated way why it failed.
I think it's great for lightweight ELT processes. If we got super complex and starting running loads of heavy processes then I think I would need something more robust.
I don't know if it will handle real-time use cases. Right now we live in the batch world so it's safe and easy to use Matillion for that
Read Mark Grace's full review
Chris Miller profile photo
April 17, 2019

Matillion brings the power of data to the people!

Chris Miller
Score 10 out of 10
Vetted Review
Reseller
Review Source
We use Matillion to consume our SaaS data organization-wide. From this data, we build dashboards to operate the business including finance, employee productivity, and sales. By leveraging our data sources in real time, it allows us to make better data-driven decisions, and prevent operating by the seat of our pants.
  • Connect to third-party data sources using a generic API interface
  • Wide support for a number of databases and data platforms
  • Pay as you go model brings extreme power in a cost-effective package
  • Oauth2 support for refresh tokens needs some work
Aside from a lot of great integrations already built in, Matillion is well suited to connect to any data source with an API. This allows us to move beyond the applications which enjoy mass adoption and to pull data in from edge case sources. This improves our ability to work with a wider number of customers to help solve their unique problems.
Read Chris Miller's full review

Matillion Scorecard Summary

Likelihood to Recommend (95)
7.9
Likelihood to Renew (1)
8.2
Usability (59)
7.8
Support (2)
8.2
Data Sharing and Collaboration (1)
9.0
Data Sources (1)
9.0
Product Scalability (57)
7.0

Feature Scorecard Summary

Connect to traditional data sources (58)
8.2
Connecto to Big Data and NoSQL (41)
7.6
Simple transformations (59)
8.5
Complex transformations (59)
7.4
Data model creation (34)
7.6
Metadata management (41)
6.6
Business rules and workflow (50)
7.5
Collaboration (52)
6.9
Testing and debugging (51)
6.8
feature 1 (4)
8.2
Integration with data quality tools (23)
6.6
Integration with MDM tools (21)
6.3

About Matillion

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.

Quickly develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate your ETL workflows with scheduling, notifications and alerting, and control flow.

Once your jobs are built, run them with confidence with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components giving you the ultimate extensibility and flexibility.

Shared Job templates, Dynamic and Grid variables, and Version control help your development teams share resources across your Matillion instance.

Enterprise customers benefit from additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.

Each product comes with a set of warehouse specific features that help you get the most out of the platform. See our Product Feature pages on matillion.com for more information.



Categories:  Data Integration

Matillion Features

Data Source Connection Features
Has featureConnect to traditional data sources
Has featureConnecto to Big Data and NoSQL
Data Transformations Features
Has featureSimple transformations
Has featureComplex transformations
Data Modeling Features
Does not have featureData model creation
Does not have featureMetadata management
Has featureBusiness rules and workflow
Has featureCollaboration
Has featureTesting and debugging
Does not have featurefeature 1
Data Governance Features
Does not have featureIntegration with data quality tools
Does not have featureIntegration with MDM tools

Matillion Screenshots

Matillion Videos (6)

Matillion Integrations

Pricing

Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Has featurePremium Consulting/Integration Services Available?Yes
Entry-level set up fee?No

Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.

Matillion Support Options

 Free VersionPaid Version
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

Matillion Technical Details

Operating Systems: Unspecified
Mobile Application:No
Supported Countries:Global
Supported Languages: English