How AnalyticsCreator Enables Easy Data Exports with Azure Data Factory & SSIS

The newest version of AnalyticsCreator lets you generate export pipelines and packages — using Azure Data Factory or SSIS — to send data from your warehouse into cloud services, analytical databases, data lakes, ML platforms, or even back to source systems.

With the latest update, AnalyticsCreator supports generating Azure Data Factory pipelines and SSIS packages that export data from your data warehouse to a wide variety of target systems — from cloud stores to analytical databases to planning or ML platforms.

Flexible Export Options with ADF and SSIS

AnalyticsCreator allows export to any external database or storage target using standard OLEDB or ODBC drivers. You can also export to CSV or text files, or directly to cloud storage such as Azure Blob Storage — whichever target your external system supports.

What You Can Achieve

• Create a data lake in Azure or other cloud environments
• Export data into files (CSV, text) and load them into services like BigQuery, AWS, or other cloud data lakes
• Export data marts into analytical databases such as Snowflake, Teradata, or specialized analytics platforms
• Feed data into planning or financial tools like Acterys, IBM Planning Analytics, or LucaNet
• Send data to machine‑learning or AI platforms — within Azure or other databases for AI/ML workflows
• Push transformed or calculated data back into source systems so your applications can use clean data directly

For a demonstration of this export functionality in action, watch our video on the AnalyticsCreator YouTube channel: New connector for exporting data from data warehouse to many target systems