Open NorthwindCdk.sln in Visual Studio.
Open NorthwindCdkStack.cs.
Add the following changes at the end of NorthwindCdkStack constructor. The following code creates new parameter in AWS Systems Manager Parameter Store named /Northwind/ConnectionStrings/NorthwindPostgreDatabase and adds full connection string to the Amazon Aurora PostgreSQL database as it’s value.
namespace NorthwindCdk
{
public class NorthwindCdkStack : Stack
{
internal NorthwindCdkStack(Construct scope, string id, IStackProps props = null) : base(scope, id, props)
{
.........
// Aurora PostgreSQL connection string in Systems Manager Parameter Store
new StringParameter(this, "NorthwindPostgreSQLDatabaseConnectionString", new StringParameterProps
{
ParameterName = "/Northwind/ConnectionStrings/NorthwindPostgreDatabase",
Type = ParameterType.STRING,
Description = "PostgreSQL connection string",
StringValue = string.Format("Server={0};Database=NorthwindTraders;Username=adminuser;Password=Admin12345?", postgreSql.ClusterEndpoint.Hostname)
});
}
}
}
Save changes and compile the project.
Run cdk diff to take a look at the changes that are going to be deployed.
cdk diff
The output should look like this:
Stack NorthwindCdkStack
Resources
[+] AWS::SSM::Parameter NorthwindPostgreSQLDatabaseConnectionString NorthwindPostgreSQLDatabaseConnectionString2F8E55B7
Now it’s time to deploy the project using cdk deploy command.
cdk deploy
The output should look like the following:
NorthwindCdkStack: deploying...
NorthwindCdkStack: creating CloudFormation changeset...
0/2 | 6:07:01 AM | UPDATE_IN_PROGRESS | AWS::CloudFormation::Stack | NorthwindCdkStack User Initiated
1/2 | 6:07:08 AM | CREATE_IN_PROGRESS | AWS::SSM::Parameter | NorthwindPostgreSQLDatabaseConnectionString (NorthwindPostgreSQLDatabaseConnectionString2F8E55B7)
1/2 | 6:07:09 AM | CREATE_IN_PROGRESS | AWS::SSM::Parameter | NorthwindPostgreSQLDatabaseConnectionString (NorthwindPostgreSQLDatabaseConnectionString2F8E55B7) Resource creation Initiated
1/2 | 6:07:10 AM | CREATE_COMPLETE | AWS::SSM::Parameter | NorthwindPostgreSQLDatabaseConnectionString (NorthwindPostgreSQLDatabaseConnectionString2F8E55B7)
2/2 | 6:07:13 AM | UPDATE_COMPLETE_CLEA | AWS::CloudFormation::Stack | NorthwindCdkStack
2/2 | 6:07:13 AM | UPDATE_COMPLETE | AWS::CloudFormation::Stack | NorthwindCdkStack
✅ NorthwindCdkStack
Outputs:
NorthwindCdkStack.PostgreSQLEndpointAddress = northwind-postgresql.cluster-cn0kwmvargy2.eu-west-1.rds.amazonaws.com
NorthwindCdkStack.SQLServerEndpointAddress = northwind-sqlserver.cn0kwmvargy2.eu-west-1.rds.amazonaws.com
Stack ARN:
arn:aws:cloudformation:eu-west-1:672916551513:stack/NorthwindCdkStack/962b7760-9070-11eb-9654-0a6ae1197ba5
Now connection string to the Amazon Aurora PostgreSQL database is securely stored in AWS Systems Manager Parameter Store as a parameter named /Northwind/ConnectionStrings/NorthwindPostgreDatabase.