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

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator
GO TO >

How Data Mesh Can Succeed on the Microsoft Data Stack

How Data Mesh Can Succeed on the Microsoft Data Stack
GO TO >

How to Operationalize Data Products Without Overburdening Domain Teams

How to Operationalize Data Products Without Overburdening Domain Teams
GO TO >

Best way to integrate your SAP data into Microsoft Fabric

Best way to integrate your SAP data into Microsoft Fabric
GO TO >

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator
GO TO >

How Data Mesh Can Succeed on the Microsoft Data Stack

How Data Mesh Can Succeed on the Microsoft Data Stack
GO TO >

How to Operationalize Data Products Without Overburdening Domain Teams

How to Operationalize Data Products Without Overburdening Domain Teams
GO TO >

Best way to integrate your SAP data into Microsoft Fabric

Best way to integrate your SAP data into Microsoft Fabric
GO TO >

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator

Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator
GO TO >

How Data Mesh Can Succeed on the Microsoft Data Stack

How Data Mesh Can Succeed on the Microsoft Data Stack
GO TO >

How to Operationalize Data Products Without Overburdening Domain Teams

How to Operationalize Data Products Without Overburdening Domain Teams
GO TO >

Best way to integrate your SAP data into Microsoft Fabric

Best way to integrate your SAP data into Microsoft Fabric
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.