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

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;

AWS

AWS supports the following databases:

  • Oracle
  • MySQL
  • SQL Server
  • PostgreSQL
  • Aurora MySQL
  • Aurora PostgreSQL

Like Azure, you can create these database instances and connect them to ColdFusion using the connection parameters in ColdFusion Administrator.