Today marks the one-year anniversary of general availability for Matillion Data Loader. It’s been exciting to watch the growth of our first SaaS product and its adoption by Matillion customers. You’ve moved more than 350 billion rows of data for free! We’ve come a long way in a year and are excited for what’s coming this year. More on that in future blog posts.
In the time since we first announced Matillion Data Loader, the pipeline business has grown and changed as well. To be frank, the data pipeline category has become commoditized. Connecting to a data source and loading that data into the cloud is no longer the unique province of one or two products. There are numerous startup and established companies who do data pipelines, and companies can take their pick.
Which product do you choose?
Data loading products are obviously named because they do one thing very, very well. But there are nuances in how each product does the job, and for how much money. It’s important to look for the following criteria if you’re evaluating a data loading pipeline product.
1. Your data loader has the data connectors you need
First and most obvious, you need a pipeline product that integrates with your data sources. But don’t get that confused with a product that has the most data sources. There’s no need to invest in a product with a thousand connectors if you only need a dozen. What’s important is to find a product that’s going to get YOUR data into the cloud, whether that data resides in Salesforce, your on-premises SQL database, or another cloud data platform.
2. It’s low cost
At this stage in the pipeline game, it’s basically a race to the bottom in terms of cost. Why would you pay a premium per connector when you can load your data for a nominal amount. Choose the product that aligns, that makes the most budget sense and reallocate the fees you would have formerly spent on pipelines to somewhere more useful.
3. It has minimal maintenance requirements
In another time, pipeline maintenance was a chore. Changes in table selections and configurations meant rebuilding a pipeline from scratch. And even if you had editable pipelines, schema drift meant constantly monitoring and correcting pipelines to avoid data loading failures.
Today, you not only want a tool that has editable pipelines, but you want to choose a product with “self-healing” pipelines that can easily adapt to schema changes and propagate them to the destination, without assistance from IT or the need to code.
4. If offers multi-cloud support
Many enterprise companies need support for a multi-cloud strategy, and multi-cloud will be a growing requirement for most companies in the years to come. Data can need to reside in different clouds and cloud data platforms because of different use cases and security requirements. You want to make sure that whatever data loading tool you choose is capable of loading data into the cloud, but also loading it from one cloud platform to another.
5. It offers a path to data transformation
For many companies, migrating or regularly loading data into the cloud is the first part of the data journey. But it’s not the last. Getting data into the cloud is the easy part: making that data useful for analytics requires data transformation. If you’re not doing data transformation right now, you want to be sure that any pipeline tool offers an upgrade path to a more robust cloud ELT tool. This will ensure that once your data is in the cloud, you can use your cloud data platform to ensure that it yields powerful insights for your business.
Matillion Data Loader: Start loading your data into the cloud
If you’re looking for a data loading pipeline product that checks all of the boxes, Matillion Data Loader is a SaaS-based product that makes it easy to get your data into your cloud data platform. Matillion Data Loader features:
- 38 different connectors for some of the most common data sources, including Salesforce, Google Analytics, Microsoft Excel, SQL databases, and more.
- Free data loading with just a few clicks
- Editable and “self-healing” pipelines
- Multi-cloud capabilities with connectors for Snowflake, Amazon Redshift, and Google BigQuery
- The ability to upgrade to Matillion ETL and add transformation capabilities when you need them