Microsoft Azure Database Integration with Appian Cloud

Overview

Appian Cloud customers have the ability to connect to specific database options available in Microsoft Azure.

For Azure’s SQL Database Managed Instances and SQL Server on Virtual Machines database options, customers are required to establish IPSec VPN Tunnels when integrating with their Appian Cloud instance.

For Azure's fully managed databases, customers can integrate with any supported SQL Server databases, such as Azure SQL Database. Connectivity must be established over the Internet and customers can configure the data source in the Admin Console. Customers need to configure IP whitelisting on their Azure Server Firewall to whitelist Appian Cloud IPs. As per Azure documentation, in-transit traffic to the database is encrypted using TLS.

Architecture

The diagram below shows two Appian Cloud Instances integrating with two different Azure Database resources. Appian Cloud Instance A is integrating with an Azure SQL Database by connecting over the internet, while Appian Cloud Instance B is connecting to an Azure SQL Managed Instance over an IPSec VPN Tunnel.

azure_appian_integration.png

Supported Configuration Summary

Database Option Connectivity Option Encryption
SQL Database Managed Instance VPN IPSec
SQL Server on Virtual Machine VPN IPSec
Azure SQL Database Internet (with IP whitelisting) TLS
FEEDBACK