Can we install ADO.NET components on RDS Instances?

0

We have SSIS running in a RDS instances.

One of the DB Connection Manger in the SSIS workflow is to an Actian PSQL database. For the connection manager to work we need the PSQL-AdoNetDataProvider4.3 to be installed on the RDS server. https://esd.actian.com/product/Zen_PSQL/SDKs/ADO.NET/ADO.NET

Is this supported? If so how can i accomplish it?

1 Answer
0

Hello there,

Thanks for reaching out. I understand you have a query on whether or not ADO.NET components can be installed in RDS SQL Server.

I would like to start by bringing to attention that RDS uses option groups to enable/install features in any instance. As such, only the list of features documented here are available in RDS SQL Server; https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.html

At this time, this list of features does not include ADO.NET components or the ADO.NET product. If this is absolutely necessary for your environment, you can also consider migrating the databases from RDS to an EC2 instance. If they are running in EC2, you would have full control over the database engine and everything installed in it. If you wish to go down that route, you can use a service such as Database Migration Service (DMS) or native backup/restore to migrate the databases.

On a best effort, I did manage to find some documentation here on adding an RDS instance to your .NET application in Beanstalk; https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/create_deploy_NET.rds.html

I would ask that you please read over the link and see if that may accomplish your task. If you have any further queries on that documentation, I would recommend asking under our Elastic Beanstalk topic to ensure you can be answered by an engineer from the appropriate team.

I hope the above answer will be helpful. Please feel free to reach out to us again at any time.

AWS
Shane_F
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions