ORACLE: Configure connection
- Alexej Hinz
- Elias Mumm
- Alexander Ludwig
Summary
Using an Oracle database requires the installation of Oracle instant clients on the Users' machines.
The Client libraries provide the necessary network connectivity.
User Manual:
Oracle Server Setup
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 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.
Connecting to SAP
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 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, or JDBC.
Troubleshooting
© 2024 bluetelligence GmbH. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of bluetelligence GmbH. The information contained herein may be changed without prior notice. bluetelligence and Performer Suite and their respective logos are trademarks or registered trademarks of bluetelligence GmbH. SAP, ABAP, BAPI, SAP NetWeaver, SAP BI, SAP BW, SAC, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany or an SAP affiliate company. All other product and service names mentioned are the trademarks of their respective companies.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy