Connecting to Oracle

Applicable to Sisense on Linux and Microsoft Windows

This topic describes how to add data from Oracle to your data model using Live Connect or an ElastiCube.

Sisense enables quick and easy access to databases and tables, and to views contained within Oracle databases.

Note: The following instructions are for both Windows and Linux deployments. However, be aware that some of the options shown below are only available in Sisense for Linux

To add data from Oracle to your data model:

  1. In the Data page, open a Live model, open an ElastiCube, or create a new ElastiCube.
    For more information on Live models, see Creating Live Models and Adding Live Connections.
  2. Click . The Add Data dialog box is displayed.
  3. Select your live Oracle data source:

    Or select theOracle connector:
  4. The Oracle settings form opens.

    On Linux: Enter the following details, depending on the connection type you use to connect:

    Basic

    Service ID (SID)

    Service Name

    TNS

    Custom

  5. Click . A list of tables in the database is displayed. All tables and views associated with the database appear in a new window.
  6. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Live Table Query (for Live)/Add Custom Import SQL (for ElastiCube)
  7. Enter the following details, depending on the method you use to connect:
    Using Oracle Service ID (SID):
  8. Using Service Name:

  9. Click . A list of tables in the database are displayed. All tables and views associated with the database will appear in a new window.
  10. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Custom Import SQL.

  11. (Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube. You can disable this by toggling the Import Relationships switch.

  12. (Optional) Click + to to use SQL to customize the data See Creating Custom Live Table Queries or Importing Data with Custom Queries for more information.

  13. After you have selected all the relevant tables, click Done. The tables are added to your schema in Sisense.