Strategy One

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 Mosaic Studio

  1. Create a Mosaic model or right-click an existing Mosaic model and choose Edit.
  2. In the Sources tab, click Add Database.

  3. Click Oracle.

  4. Type a Name for the data source.

  5. Expand the Database Version drop-down list and choose your Oracle database version.

  6. Expand the Driver drop-down list and choose your Oracle driver type.

  7. Expand the Connection Method drop-down list and choose Standard, Cloud Wallet, or starting in Strategy One (April 2026), TNS Names Connection.

  8. If you choose Standard:

    1. Type your Oracle Host Name.

    2. Type your Oracle Port Number.

    3. Type your Oracle SID or Service Name.

  9. If you choose Cloud Wallet:

    1. Click Select a File, find your Cloud Wallet configuration file, and click Open.

    2. Expand the Service drop-down list and choose your Oracle service.

  10. 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.

  11. Optionally toggle on Use Vault and enter your vault connection information.

  12. If you do not toggle on Use Vault, type your Oracle Username and Password.

  13. Optionally click Test.

  14. If the connection is successful, click Save.