38
Views
1
Comments
How to encrypt oracle database connection

Hello Community,

I have seen from our platform release notes 

https://www.outsystems.com/Downloads/ScreenDetails.aspx?MajorVersion=11&ReleaseId=19341&ComponentName=Platform+Server

  • Upgraded Oracle Data Provider for .NET, Managed driver to version 19.3.1 (4.122.19.1:20190703). According to the official documentation, this driver allows applications to connect to Oracle Database 11g Release 2 or later.If you have integrations with earlier versions of Oracle Database, they will not work. You will need to upgrade your Oracle engine to version 11g Release 2 or later, in order to continue using those integrations. This driver supports native encryption, meaning that you can set up your database to require encryption and this means all connections will be encrypted between the server and the database (applicable for the platform and external databases). (RSAT-1723)

Can anyone offer any guidance on an actual connection string for this?

based on 

I assume it takes the form:

user id=foo;password=<hidden>;Integrated Security=no;Data Source=(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1521)) (CONNECT_DATA= (SID=foo)))

but I get:

What I am trying to achieve is an encrypted connection to the oracle database. 

Which I assume is achieved by Integrated Security=yes

But I can't get the connection string to work.


Many thanks,

Andy


2023-02-09 12-36-42
Damian Fonville

I'm not a Oracle database expert, But with my experience you should setup Encryption on the database server side, And the client will use Encryption if it is possible, Or when this is required the client can only connect when it supports Encryption.


https://docs.oracle.com/en/database/oracle/oracle-database/21/dbseg/configuring-network-data-encryption-and-integrity.html#GUID-50817699-B199-49CA-8779-137EBC4B0564

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.