Introduction

Microsoft Azure SQL Database is a general-purpose relational database, running as a managed service on the Microsoft Azure cloud computing platform

Authenticating connections

The adapter supports username/password based authentication method.

Microsoft Azure SQL adapter as a source

Microsoft Azure SQL adapter as a source supports:

  • Fetching data from tables and views.

  • Executing stored procedures and consuming results.

  • Executing query statements and fetching results.

Microsoft Azure SQL adapter as a target

Microsoft Azure SQL adapter as a target supports:

  • Inserting and updating rows in tables.

  • Executing parameterized stored procedures.

  • Executing parameterized query statements.

  • Executing custom data manipulation language (DML) statements.