ODBC connection to database in the cloud - Forum - OpenEdge RDBMS - Progress Community

ODBC connection to database in the cloud

 Forum

ODBC connection to database in the cloud

  • Hi,

    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?

    Richard

     

  • 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.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com
  • 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.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com
  • 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

  • Yes TMH.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com
  • Good to confirm by a more authoritative source!

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • 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?