/
ORACLE: Configure connection
Document toolboxDocument toolbox

ORACLE: Configure connection

Owned by Alexej Hinz
Last updated: Apr 03, 2023

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

See: ORACLE: Connection fails

Related content

ORACLE: Connection fails
ORACLE: Connection fails
Performer Suite Knowledge Base
More like this
Oracle Server Setup
Oracle Server Setup
User Manual v22.1
Read with this
Technology used for the connection to SAP and its DB
Technology used for the connection to SAP and its DB
Performer Suite Knowledge Base
More like this
Services and Ports
Services and Ports
Performer Suite Knowledge Base
More like this
Find your BW parameters
Find your BW parameters
Performer Suite Knowledge Base
More like this
HANA SQL Connection
HANA SQL Connection
User Manual v21.2
More like this


© 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