Delphi FireDac network encryption with Oracle

168 Views Asked by At

I'm looking for a possibility to encrypt the connection to our Oracle database. I did find this post below:

How to encrypt FireDAC connection to use TLS/SSL in Delphi?

The only answer I see there is that we have to buy ($3000/developer, wow) and use a CData component.

Is FireDAC ready for using network encryption with an Oracle DB? If so, how do I configure that?

1

There are 1 best solutions below

1
On

Don’t know about FireDac secure connection, but we use third-party components for this. First of all – it’s not a good idea to leave Oracle DB open from anywhere on the internet, try to change your application architecture to use (for example) REST-API from the internet and secure vpn or closed part of the network between REST-Server and Oracle. If it’s not possible or the client is in “paranoid mode” then you can use Devart ODAC and Devart SecureBridge. This allows you to connect to Oracle securely. It's not free, but it's not $3,000 for a developer either. Here is a documentation how to use it: https://docs.devart.com/odac/ssl.htm