AnalyticsCreator logo dark text
Get trial

English

back Back to all Blogs

New connector for exporting data from DWH to many target systems

, ,
New connector for exporting data from DWH to many target systems
author
Peter Smoly Sep 14, 2022

With the latest version of AnalyticsCreator you are able to generate Azure Data Factory pipelines and also SSIS packages to export data from your data warehouse to external databases.  

AC support any OLEDB or ODBC driver functionality for this export. The suitable driver will write data in your target system.  
As well CSV, text files and Azure blob storage is supported, too.

What can you achieve:

  • This functionality supports you to create a data lake in Azure or somewhere else in the cloud.
  • Export data into the CSV files and upload these files into the cloud services like Google Query, AWS or Microsoft Data Lake
  • You are able to export the data of your top layer (e.g. data mart) to a analytical database like thoughtspot or snowflake or terradata, ..  
  • Export your data in a planning solution like Acterys, IBM Planning Analytics TM1, Lucanet, ..
  • Transition of data to other ML and AI applications (you can use ML and AI directly in Microsoft Azure and SQL databases).
  • Export data back into your source databases. It can help you to use data transformed and calculated in the data warehouse in your client applications.

For more information, please have a look at the AnalyticsCreator YouTube channel: New connector for exporting data from data warehouse to many target systems

Meeting with CEO

 

 

 

Related Blogs

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator
GO TO >

Analyze trends & compare data over time with snapshot historization in Azure

Analyze trends & compare data over time with snapshot historization in Azure
GO TO >

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment
GO TO >

Streamlining Data Management with Data Warehouse Automation in Azure

Streamlining Data Management with Data Warehouse Automation in Azure
GO TO >

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator
GO TO >

Analyze trends & compare data over time with snapshot historization in Azure

Analyze trends & compare data over time with snapshot historization in Azure
GO TO >

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment
GO TO >

Streamlining Data Management with Data Warehouse Automation in Azure

Streamlining Data Management with Data Warehouse Automation in Azure
GO TO >

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator

Reducing the cost of prototyping a data warehouse solution in Azure using AnalyticsCreator
GO TO >

Analyze trends & compare data over time with snapshot historization in Azure

Analyze trends & compare data over time with snapshot historization in Azure
GO TO >

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment

Why You Need a Holistic Data Model and a Data Catalog for Your Azure Environment
GO TO >

Streamlining Data Management with Data Warehouse Automation in Azure

Streamlining Data Management with Data Warehouse Automation in Azure
GO TO >
meet-the-team-bg

Meet the team:

Ellipse 307

Mr. Peter Smoly CEO

Peter Smoly is a serial entrepreneur in the Data Warehouse and Business Analytics as well software development. All together more than 25 years’ experience as a founder, CEO, project manager and consultant.

Dimitri_Sorokin

Mr. Dimitri Sorokin CTO

Dimitri Sorokin, PhD electrical engineering,  has more than 30 year IT experience. As a CIO in global operating companies, Head of development, BI and data warehouse consulting and Analytics tool development.