About EasyMorph Tutorials & Examples Web-help

How to configure advanced connection settings in the Oracle connector


#1

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