How to configure advanced connection settings in the Oracle connector

Under the hood, EasyMorph uses the managed Oracle Data Provider for .NET (ODP.NET ). Therefore, everything that is supported by ODP.NET should work in EasyMorph.

There are a few possible ways how to configure advanced Oracle connection settings in EasyMorph:

Configure and use TNS

Create/edit local tnsnames.ora file as described here: https://docs.oracle.com/database/121/NETRF/tnsnames.htm

Then use the Oracle connector in EasyMorph in the TNS mode and provide the name of a data source configured in tnsnames.ora:

image

For configuring TLS/SSL, read this Oracle docs article: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/odpnt/featConnecting.html#GUID-0DF481DD-2BBE-4746-936C-1AF7830423F2

Use custom properties

Alternatively, specify additional connection settings using custom properties of the connector:

image

See this Oracle documentation page for all attributes supported by ODP.NET: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/odpnt/featConnecting.html#GUID-0CFEB161-68EF-4BC2-8943-3BDFFB878602

Data source can also be specified in custom properties using the same syntax as in tnsnames.ora:

image