In ColdFusion (2021 release), you can now create your databases in AWS and Azure clouds and store data there.
Just as you’d create a database locally, you can do the same in AWS and Azure clouds.
Azure supports the following databases:
- SQL Server
- MySQL
- PostgreSQL
You can connect these databases in ColdFusion. Create the database instances in Azure and then use the Add Data Source page in the ColdFusion to enter the server, port, username, password, etc.
For SQL Server in Azure, you need a connection string. For example,
EncryptionMethod=loginSSL;ValidateServerCertificate=true;hostNameInCertificate=*.database.windows.net;