| Table of Contents |
|---|
...
| Note |
|---|
Using an Oracle database requires the installation of Oracle instant clients on the Users' machines. |
User Manual:
/wiki/spaces/DPUM193/pages/583734890Oracle Server Setup
Connection string
Input Server Name:
...
(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
...
We do not use any specific technology to connect to our DBs but use a third-party ORM (Object-Relational Mapping) framework from DevExpress: XPO
Through this framework, we can connect to Oracle, SQL Server, and SQLite as a black box without knowing and caring about the details of the lower levels.
...
We used a third-party library for connection (Theobald's ERPConnect).
So we do not hardcode any port to be used. There are some standard ports defined for SAP connection which that are automatically used by ERPConnect, which are documented on their homepage https://theobald-software.com/en/erpconnect
The Performer Suite connects to SAP via ERPConnect, we do not directly use any specific port, nor or JDBC.