These tasks streamline data movement, integration, and processing across the environment.
These tasks let you easily move, transfer, export, and combine data across different platforms. This makes your work easier and more productive. Whether you're working with files, data, or APIs, application tasks give you the tools you need to manage and improve data handling processes.
- File Import tasks: Import an Excel or csv file to the data model.
- Automated Import Workflow tasks: Find file storage locations such as Azure Blob Storage or FTPS Servers to import either CSV or XLSX files.
- Data Transfer tasks: Transfer data from a staging table to a data model.
- Model Export tasks: Export data from a Data Model or Model View.
- Exporting Data to Azure Blob Storage: Send data safely to Azure Blob Storage. This lets you store more data and work with cloud services easily.
- Application Integration tasks: Integrate workflow directly with external ETL tools such as Azure Synapse Analytics or Azure Data Factory.
- Calculation tasks: Execute a stored procedure on the database server.
- REST API Call tasks: Execute a REST API call to an external source.