Posts

Transform Your Data with Azure Data Factory

Image
Transform Your Data with Azure Data Factory - Perficient Blogs   LinkedIn This blog will help you to understand the basic functionality of Azure Data Factory (ADF) and how powerful a tool it is when working with big data. Explore the basic architecture on ADF and get to know the components and services involved. A Quick Intro to Azure Data Factory & Its Key Features ADF is a cloud-based integration service for orchestrating and automating data movement and data transformation with 90 maintenance free connectors built-in at no added cost. Easily construct ETL and ELT processes in a visual environment or write your own code. Cut down operating expenses and capital expenditures and save precious time with these key features: No code or maintenance required to build hybrid ETL and ELT pipeline within the Data Factory visual environment. Cost efficient and fully managed serverless cloud data integration tool that scales on demand. SSIS integration runtime to easily rehost on-premises SS

Getting Started with Matillion ETL Tool

Image
Getting Started with Matillion ETL Tool - Perficient Blog LinkedIn In this article, I will show you how you can set up your own Matillion instance, but before we get started let’s talk about the Matillion ETL tool. What is Matillion, and why should you care? Matillion is an ETL tool that is available on the Cloud Marketplace. It is completely cloud-based, billed at an hourly rate, and comes with the most significant advantages when coupled with Snowflake, Redshift, and Delta Lake. To get that significant advantage, I will be showing you the coupling of Matillion with Snowflake in this article. We have been using the Matillion ETL tool on the data warehouse, such as Snowflake on the ETL project for our clients. Recently I worked on a project in which I was working on Matillion for data transformation and orchestration from source to target. Matillion has two main flavors of jobs: Orchestration: Orchestration is primarily concerned with DDL statements (especially Creating, Dropping, and