Connect to an Oracle Database

You can add Oracle as a data source, but to do so you must first enable it in the chorus.properties file. You might need to add oracle.enabled=true. You must also copy the ojdbc8.jar file to your /shared/libraries folder.

Note: Team Studio can exclude schemas from displaying. The list of blacklisted schemas is in chorus.properties and is editable.

Prerequisites

Procedure

  1. Follow the steps in Enable Oracle Data Sources. Supported Oracle versions can be found in System Requirements.

  2. Fill in the required fields and, if you like, the optional Description.
    • Data Source Name: Set a user-facing name for data source. You can choose anything you like.
    • Database Name: Enter the actual name of your Oracle database.
    • Database Account and Database Password: Provide your credentials for that database.
    • If you check the Set database credentials as a shared account box, all users can access the data source without providing their own credentials - they are accessing the database with your credentials as the data source owner. If you do not check this box, each user must enter his or her own credentials for that data source in order to access it. You can change this setting later if you change your mind.