Where Empower Lives

Empower is deployed inside your Azure Tenant. It keeps all data within your tenant. In other words, none of your data will ever leave your Azure Tenant, unless you deliberately move it out yourself.

All of Empower's required infrastructure, code, and packages also stay within your Azure Tenant.

How Empower Works

From a high-level, Empower allows you to pull in and centralize data from multiple sources, such as SQL Server, CRM system, and many (over 200!) more into your Lakehouse.

You can then transform this raw data into a more useful format that allows you to create the reports and metrics you need.

Finally, you can publish any data, transformed or not, outside of the Lakehouse to a variety of different data sources.

Empower allows you to do all of this through an easy-to-use interface in just a few simple steps:

1. Configure the connections you want to pull data from and push data to.
2. Define the data flow steps that will pull in, transform, and publish your data.
3. Chain those data flow steps using Workflows to create your full, end-to-end data movement orchestration.

Let's look at what each of these means a bit more below.

Connect to Your Data

The first thing you'll want to do is define and configure all of the connections to the systems you want Empower to connect with, i.e. pull data in from and push data out to.

Empower has over 200+ pre-built connectors that make it easy for you to set up in just a few minutes.

To learn more about what connectors are available and how to use them, visit our Data Connections page.

Configure Data Movement with Data Flows

Empower separates the core data movement functions of acquiring, transforming, and publishing the data into modular, re-usable steps called Data Flows.

There are four different types of Data Flows that you can create:

• Data Acquisition Flows ingest data from sources. All of Empower’s connectors support automatic schema drift and are designed to be straightforward: you configure which data, and the tool handles the mechanics of extraction. Read more on creating Data Acquisition Flows.

• Analytics Engineering Flows transform the data into usable information within the Lakehouse. As a user, you may customize these transformations to your heart's content: Empower supports notebook execution. All you need to do is define the data transformation logic as SQL statements. Read more on creating Transformation Flows.

• Data Publishing Flows writes data to external systems, such as Power BI, SQL servers, SFTP systems, and Dynamics CE or F&O. Read more on creating Publishing Flows.

• Custom Flows executes any specified custom notebook, making them ideal for running custom logic beyond the standard data flow types. Read more on creating Custom Flows.

Create Your Workflow

Once you have created a Data Flow, you can use it in any number of Workflows. Workflows allow you to chain together data flows in any sequence to create complete end-to-end data movement pipelines custom to your needs. Because Data Flows are created outside of Workflows, they can be configured once and used many times.

Read more about Workflows and how to use them here: Workflows Overview.