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

SQL Server 2025: Pioneering the Future of Data Management with AI Integration

SQL Server 2025: Pioneering the Future of Data Management with AI Integration
GO TO >

Choosing the Right Business Intelligence Platform in 2025

Choosing the Right Business Intelligence Platform in 2025
GO TO >

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective
GO TO >

Oktoberfest Facts you didn't know (2004-2024)

Oktoberfest Facts you didn't know (2004-2024)
GO TO >

SQL Server 2025: Pioneering the Future of Data Management with AI Integration

SQL Server 2025: Pioneering the Future of Data Management with AI Integration
GO TO >

Choosing the Right Business Intelligence Platform in 2025

Choosing the Right Business Intelligence Platform in 2025
GO TO >

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective
GO TO >

Oktoberfest Facts you didn't know (2004-2024)

Oktoberfest Facts you didn't know (2004-2024)
GO TO >

SQL Server 2025: Pioneering the Future of Data Management with AI Integration

SQL Server 2025: Pioneering the Future of Data Management with AI Integration
GO TO >

Choosing the Right Business Intelligence Platform in 2025

Choosing the Right Business Intelligence Platform in 2025
GO TO >

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective

Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective
GO TO >

Oktoberfest Facts you didn't know (2004-2024)

Oktoberfest Facts you didn't know (2004-2024)
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.