Our customer runs an application in the cloud on centOS version 11.3 64-bit. They've bought a windows reporting tool that needs to connect their database through/with odbc from a local workstation.
I presume they need some odbc driver but I've no idea what is needed for the client and server or how to set up the connection in a way that does not give the world access to their database in the cloud.
What would you advice?
The ODBC driver part is easy. Just download it from the Progress ESD site. Your customer will need an account so he may have to go through his software vendor.
The second part is probably most easily accomplished by setting up a VPN tunnel between the customer and the cloud DB. In Amazon-speak that would be a VPC.
The ODBC driver only needs te be installed on the client thus nothing on the database server itself? If so, it might be easier then I thought.
Yes. But you need to setup the DB to allow SQL conx without affecting ABL users AND you need to do the GRANTs.
The setup of the server side is the same you would do for local SQL access. Yes?
Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice http://www.cintegrity.com
Good to confirm by a more authoritative source!
I could not agree with you more TMH
I was wondering if a connection could be made using a SSH tunnel as provided by Putty?