rds: DatabaseInstance to support the creation of MSSQL DB bound to self managed AD instance.

[zcvetkovicgscf]

Describe the feature

As recently announced AWS-RDS MsSQL Instances support the integration with self managed AD Instances, look at: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServer_SelfManagedActiveDirectory.html#USER_SQLServer_SelfManagedActiveDirectory.Managing

It Seams that cdk_rds is not supporting this feature.

Use Case

Create a RDS-MSSQL Instance coupled to a self managed Active Directory.

Proposed Solution

extend the DatabaseInstanceProps by needed parameters e.g.

domain-fqdn
domain-dns-ip
domain-ou
domain-auth-secret-arn

and implement it in DatabaseInstance constructor alt least for MSSQL engine.

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.99.1

Environment details (OS name and version, etc.)

linux, macosx and GitHub

[pahud]

I am not 100% sure if cloudformation has this support but yes, we could support that if it does.

[zcvetkovicgscf]

Thanks @pahud for the quick triage:
have a look - the given parameters are already defined for CloudFormation Resources
https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_rds.CfnDBInstance.html:

domain: 'domain',
domainAuthSecretArn: 'domainAuthSecretArn',
domainDnsIps: ['domainDnsIps'],
domainFqdn: 'domainFqdn',
domainIamRoleName: 'domainIamRoleName',
domainOu: 'domainOu',

so I guess this it what you meant when looking if cloudformation has this support?

[pahud]

Yes, sounds like it could be a new L2 for that. Please help us prioritize with 👍 .