Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
A complete cloud platform for an app or your entire digital business
Detect and predict anomalies by automating machine learning to achieve higher asset uptime and maximized yield
Automate decision processes with a no-code business rules engine
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Personalize and optimize the customer experience across digital touchpoints
Build, protect and deploy apps across any platform and mobile device
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
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?