How do I create a UDL for a Cloud-based Database like Amazon ?

[DeOdderKeith]

I have been using UDL connections to SQL Server without any issues.

I was just asked to look in to Cloud-based databases, but I'm not sure ho to create a connection to the databases once they have been created.

Has anyone done anything like this?

If so, do you have an example the you can share?

Keith

[altenbach]

Maybe the LabVIEW Interface for Amazon S3 - National Instruments can give you some ideas. Not sure....

[rolfk]

Unless the cloud based database you are interested in does provide an ODBC and/or OLE/ADO driver there is no way to connect to this database through the LabVIEW Database Toolkit or any other of the Database Toolkits out there that can use an UDL.

However if you talk specifically about a service like Amazon RDS then this is based on a database engine of MySQL, SQL Server, Oracle SQL or PostgreSQL depending what the client chose when setting up the DB in the Amazon cloud and as such you simply would have to use the according database driver and get the correct internet address to connect to. What address that would need to be should be most likely visible in the setup console program or as Amazon calls it the AWS Management Console.