DataSpider adapter details "Microsoft Azure"

This adapter pack enables seamless integration of Microsoft Azure (hereinafter referred to as Azure) services, such as Azure SQL Database, Azure BLOB Storage, and Azure Machine Learning, with other systems and data without programming.

Use Cases

It automates data integration between clouds and reduces operational workloads in multi-cloud environments.
It automatically connects on-premise and Azure data while converting and processing it, reducing operational workload.

Collaboration image

List of features

function	overview	DataSpider Servista	DataSpider Cloud
Azure SQL Database
Table Reads	Read all data from a table	○	○
Search SQL execution	Read data using any search SQL statement (SELECT)	○	○
Table Write	Write input data to a table	○	○
Update SQL execution	Write data using any update SQL statement (INSERT, UPDATE, DELETE, etc.)	○	○
Stored Procedure Execution	Execute a stored procedure	○	○
Azure BLOB Storage
Get a list of containers	Get a list of containers at the specified connection destination	○	○
File/Directory Read	Writes a file or directory on Microsoft Azure BLOB storage to a specified directory on the DataSpider file system.	○	○
File/Directory Write	Writes a file or directory on the DataSpider file system to a specified container on Microsoft Azure BLOB storage.	○	○
Delete file/directory/container	Delete a file, directory, or container on Microsoft Azure Blob Storage	○	○
Azure Cosmos DB
Document Reading	Retrieve documents stored in a collection in Microsoft Azure Cosmos DB	○	○
Reading Documents with SQL	Use any SQL statement to retrieve documents stored in a Microsoft Azure Cosmos DB collection.	○	○
Document writing	Writes input data to a Microsoft Azure Cosmos DB collection	○	○
Document deletion	Delete a document stored in a collection in Microsoft Azure Cosmos DB	○	○
Azure HDInsight
Cluster Creation	Create an Azure HDInsight cluster	○	○
Cluster deletion	Delete a cluster in Azure HDInsight	○	○
Hive Job Execution	Run a Hive job	○	○
Azure Machine Learning
Job execution	Batch jobs run against Microsoft Azure Machine Learning	○	○
Azure Queue Storage
Message Reception	Receive messages from Azure Queue Storage	○	○
Sending a message	Send a message to Azure Queue Storage	○	○
Message deletion	Executes message deletion on Azure Queue Storage	○	○