CODEWITHSUNDEEP
encryptionodbcopenedgeprogress-db
David
David

Reputation: 2748

How to secure data transferred over ODBC connection using Progress DB

We have an application (written in PHP) that fetches data from several remote Progress databases. The way it is working now, we ask our clients to open a port in their firewall to our IP, then we're able to run queries using ODBC connection from the PHP code.

The problem is that the data transferred over the internet is unencrypted.

We thought about two solutions but we've issues with both:

  1. Updating Progress DB to use SSL. Problem: this requires our clients to change the way they connect with other vendors to have them all using the SSL.

  2. Creating a VPN connection between us and the clients. Problem: we have many clients and the IPs/subnets may be overlapping.

What else can we do to have the data transferred to us encrypted?

Thanks.

Upvotes: 2

Views: 1557

Answers (1)

Tim Kuehn
Tim Kuehn

Reputation: 3251

Create an SSH tunnel between your systems - this'll allow them to work as they were, the comms will be encrypted, as long as the client systems support SSH connections.

https://en.wikipedia.org/wiki/Tunneling_protocol

This document looks fairly complete: https://www.digitalocean.com/community/tutorials/how-to-set-up-ssh-tunneling-on-a-vps

You can find a windows version of Open SSH here: http://www.mls-software.com/opensshd.html

Upvotes: 2

Related Questions