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.