Connect to Oracle

Starting in Strategy One (April 2026), you can create an Oracle data source using a TNS Names connection.

Connect to Oracle using Strategy's modern solution offerings. Strategy supports a wide range of Oracle versions across its platform.

Prerequisites

If you are using Cloud Wallet to connect to Oracle, you must have access to your Cloud Wallet zip file.
If you are using TNS Names Connection to connect to Oracle, you must have your TNS Names ORA file.

Connect to Oracle in Workstation

Open the Workstation window.
In the Navigation pane, click , next to Data Sources.
Click Oracle.
Type a Name for the data source.
Expand the Database Version drop-down list and choose your Oracle database version.
Expand the Default Database Connection drop-down list and choose Add New Database Connection.
Type a Name for the database connection.
Expand the Driver drop-down list and select the JDBC or ODBC driver.
Expand the Connection Method drop-down list and choose Standard, Cloud Wallet, or starting in Strategy One (April 2026), TNS Names Connection.
If you choose Standard:
1. Type your Oracle Host Name.
2. Type your Oracle Port Number.
3. Type your Oracle SID or Service Name.
If you choose Cloud Wallet, click Select a File, find your Cloud Wallet configuration file, and click Open.
If you choose TNS Names Connection:
1. Type the Oracle Server Name.
2. Click Select a File, find your ORA file, and click Open.
  
  For more information on accessing the tnsnames.ora file, see Specifying a Connection by Configuring a tnsnames.ora File.
Expand Default Database Login and choose your Oracle database login or click Add New Database Login.

For more information on creating a database login, see Create, Edit, and Delete Standalone Database Connections and Database Logins.
Optionally click Test.
If the connection is successful, click Save.
Optionally type a User Comment and click OK.
Expand the Projects drop-down list and choose the projects to associate with the data source.
Click Save.