Zeaware™ Data Loader for Dynamics

Easily load Dynamics data lake files into multiple target database formats

Fast and efficient loading of Dynamics data lake files

Microsoft Dynamics provides a powerful business application platform via their ERP and Customer Engagement applications. Dynamics supports exporting data into Azure Data Lake, but many customers are struggling to process this data and load into downstream databases.

Zeaware Data Loader for Dynamics solves this problem and provides a simple way to load data lake file data into target database systems, including:

Cloud databases in Azure, such as Azure SQL
On premise data warehouses
Non-Microsoft cloud databases

Automated Schema Management

Source system schema changes are detected automatically and will automatically be applied to the target database preventing loading failures due to source table changes.

Stringent Error Handling & Logging

Handling errors is a key capability and response to errors is configurable so that you can fail the whole process, fail a particular table or skip and retain affected record for manual analysis

Reconciliation

Zeaware Data Loader maintains detailed reconciliation statistics allow administrators the opportunity to undertake reconciliation between upstream and downstream systems.

Simple Setup

Install and deploy quickly, minimal configuration required to start loading Dynamics data into your selected target database.

Full Feature List

Features

Automated Schema Management

Source system schema changes are detected automatically and will automatically be applied to the target database preventing loading failures due to source table changes.

Stringent Error Handling & Logging

Handling errors is a key capability and response to errors is configurable so that you can fail the whole process, fail a particular table or skip and retain affected record for manual analysis

Reconciliation

Zeaware Data Loader maintains detailed reconciliation statistics allow administrators the opportunity to undertake reconciliation between upstream and downstream systems.

Simple Setup

Install and deploy quickly, minimal configuration required to start loading Dynamics data into your selected target database.

FAQS

How is this deployed?

Zeaware Data Loader for Dynamics is deployed into your environment. If can be deployed in various methods including as a container app, Azure Function app or Windows service.

Is this an ETL Tool?

Zeaware Data Loader for Dynamics is not a full ETL tool, it focuses only on the loading data exported from Dynamics into a target database. Any data transformation will require additional tools.

What target databases are supported?

Currently the BETA supports Azure SQL, SQL Server and AWS Redshift. However please check back regularly if you target database is not listed as additional targets are being developed.

Let us show you what Zeaware can do

Start Today

Request Demo