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 Respuesta
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
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas