Matillion is a company based in the UK that offers extraction, transformation and loading services for cloud data warehouses like Snowflake, Amazon Redshift, and Google BigQuery.
ETL refers to the three steps (extract, transform and load) that are used to prepare and combine data from multiple sources so that it can be analyzed for business use.
Y now the provider cloud data integration company Matillion Ltd. hhas made available its free tool Matillion Data Loader with Snowflake Computing Inc. Partner Connect to help businesses quickly and easily upload critical business data from a wide range of sources to Snowflake's popular cloud data warehouse. Service.
With an intuitive user interface and simple wizard setup, Matillion Data Loader provides a frictionless, code-free experience for knowledge workers and citizen data professionals to quickly configure data pipelines.
As companies seek their data to solve business challenges, access to accurate data sources is essential to unlock insights from that information.
Matillion Data Loader offers data professionals a code-free user experience with the following features:
- Pre-built connectors for popular data sources like Salesforce, Google Analytics, Microsoft Excel, Google Sheets, Google AdWords, and more
- No-code, wizard-based pipeline builder for rapid value generation
- Incremental data load to access up-to-date data, increase pipeline speed, and save CDW storage costs
- Intuitive dashboard to monitor your pipeline runs and data volumes
- Role-based permissions for multiple administrators and users across the enterprise
- Notifications and alerts to keep users informed during the data upload process
Matillion supports companies at various stages of their data journey, with solutions that enable them to address simple use cases, sophisticated analytics projects, or both at the same time. Matillion Data Loader works on its own as a lightweight solution for loading data into Snowflake, Amazon Redshift, or Google BigQuery. But it also works with Matillion ETL as a platform to join and transform data sources for analysis.
matillion said his business clients often deal with multiple types and sources of data, y They need a way to centralize that information. A recent IDG survey found that data professionals report needing 400 different data sources to power their business intelligence and analytics systems.
The tool Matillion Data Loader helps companies easily load data into the data warehouse Snowflake from sources like Microsoft SQL Server, Google Analytics, Salesforce and others. The tool helps provide a code-free experience for citizen data professionals and others who need to easily configure data channels.
Snowflake customers can access the Matillion tool through Snowflake Partner Connect and then start uploading data to Snowflake without leaving that platform.
The data loader works by itself as a lightweight solution to load data and works with Matillion ETL to join and transform data sources for analysis, the company said. Matillion said it will be available on Snowflake Partner Connect early in the third quarter of this year.
"Businesses need their data to be available for analytics-based insights more than ever," Matillion CEO Matthew Scullion said in a statement. “The inclusion of Matillion Data Loader in the Partner Connect program now means that data teams and business stakeholders have easy access to a free, no-code solution that ingests data directly into Snowflake, supporting business professionals. data at any stage of your data journey, both simple and complex use cases.
Source: https://www.matillion.com