Connecting to Azure SQL DB Issue

We are wanting to create a connection to an Azure SQL Database from our Appian host. The Azure SQL database uses firewall rules to only allow specific incoming IP addresses and IP address ranges for access to the data. Could you please provide the IP address/ranges that will come from Appian when making a connection to the Azure SQL database.  Using a VPN tunnel for connection is not an option for us.  Appian support indicates that they cannot provide static IP addresses.  So questions are: Has anyone else encountered this issue?  Second, does Appian support oAuth 2.0?  Again, oAuth 1.0 and basic authentication is not an option.  The azure authentication uses the Azure Active Directory.  

  Discussion posts and replies are publicly visible