Summary
Using an Oracle database requires the installation of Oracle clients on the Users' machines.
The Client libraries provide the necessary network connectivity.
User Manual:
/wiki/spaces/DPUM193/pages/583734890
Connection string
Input Server Name:
<host>:<port>/<serviceName> (ex. "127.0.0.1:1234/serviceName")
OR
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>) (PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<serviceName>)))
https://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm
Connecting to Oracle
We do not directly use any specific technology for connection to our DBs, we use a third party ORM (Object-Relational Mapping) framework from DevExpress: XPO
Through this framework, we can connect to Oracle, SQL Server, SQLite as a black box without knowing and caring about the lower-level details.
Connecting to SAP
We used a third-party library for connection (Theobald's ERPConnect).
So we don't hardcode any port to be used, I guess there are some standard ports defined for SAP connection which are automatically used by ERPConnect, maybe it is documented on their site (https://theobald-software.com/en/erpconnect/)
DP connects to SAP via ERPConnect, we do not directly use any specific port, neither JDBC.
