Hi folks
I'm currently writing to a MySQL database on AWS RDS using a small DLL written in C#, with username/password authentication. (we didn't have the database toolkit back then ... we do now)
So I could change to the NI database toolkit; however we are also moving everything we do on AWS to IAM authentication instead of username/password.
If I could find an ODBC driver then it would all be easy, but I can only find one for 'Redshift' (though that does support IAM authentication).
Has anybody been there before? I'm struggling to know where to start ... I figured that it shouldn't be much of a change simply to use a different authentication method!
Perhaps it could be done via another DLL but I wouldn't even know where to start (and the chap that wrote the existing one has left).
thanks
John