Back to all BlogsExport Data from Your Data Warehouse with Azure Data Factory and SSIS in AnalyticsCreator
With the latest version of AnalyticsCreator, you can generate Azure Data Factory pipelines and SSIS packages to export data from your data warehouse to a wide range of target systems. This includes analytical databases, cloud services, planning solutions, machine learning platforms, and even your original source systems.
Flexible export options with Azure Data Factory and SSIS
With the latest version of AnalyticsCreator you can generate Azure Data Factory pipelines and SSIS packages to export data from your data warehouse to external databases.
AnalyticsCreator supports any OLEDB or ODBC driver functionality for this export. The appropriate driver writes data to your target system. CSV files, text files, and Azure Blob Storage are also supported.
What you can achieve
- This functionality supports you in creating a data lake in Azure or other cloud environments.
- Export data into CSV files and upload them into cloud services such as Google BigQuery, AWS, or Microsoft Data Lake.
- Export data from your top layer, for example a data mart, to analytical databases like ThoughtSpot, Snowflake, or Teradata.
- Export your data into planning solutions such as Acterys, IBM Planning Analytics TM1, or LucaNet.
- Transfer data to machine learning and AI applications. You can use ML and AI directly in Microsoft Azure and SQL databases.
- Export data back into your source databases to use transformed and calculated data in your client applications.
For more information, please visit the AnalyticsCreator YouTube channel: New connector for exporting data from data warehouse to many target systems
Frequently Asked Questions
What export technologies does AnalyticsCreator support?
AnalyticsCreator supports Azure Data Factory pipelines and SSIS packages for exporting data from your data warehouse to external systems.
Which drivers can I use when exporting data?
You can use any OLEDB or ODBC driver. The driver you choose determines how data is written to your target system.
Can AnalyticsCreator export to cloud storage?
Yes. You can export data to CSV or text files and upload them to cloud storage platforms such as Azure Blob Storage, Google services, AWS, and Microsoft Data Lake.
Can I export data to analytical databases?
Yes. You can export data from your data mart or top layer to analytical databases such as ThoughtSpot, Snowflake, and Teradata.
Does AnalyticsCreator support exporting data to planning solutions?
Yes. You can export data to systems like Acterys, IBM Planning Analytics TM1, and LucaNet.
Can data be exported for machine learning and AI applications?
Yes. You can transfer data to ML and AI applications, including those running directly in Microsoft Azure and SQL databases.
Is it possible to export data back into source systems?
Yes. You can write transformed and calculated data back into source databases to make it available for client applications.
