# Connecting to Oracle

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

*Source: https://docs.sisense.com/main/SisenseLinux/connecting-to-oracle.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

This topic describes how to add data from Oracle to your data model using [Introducing Live Models](https://docs.sisense.com/main/SisenseLinux/live-connect.md) or an ElastiCube.

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

**Note:**

The Oracle connector is not yet supported with the [Analytical Engine](https://docs.sisense.com/main/SisenseLinux/analytical-engine-overview.md).

**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 about Live models, see [Creating Live Models and Adding Live Connections](https://docs.sisense.com/main/SisenseLinux/creating-live-models.md).
2. In the Model Editor, click ![+Data](https://docs.sisense.com/main/Resources/Images/+Data.png). The Choose Connector window is displayed.

   ![ConnMgmtChooseConnector](https://docs.sisense.com/main/Resources/Images/connMgmtChooseConnector.png)
3. Choose an available [managed connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#AccessingandManagingAvailableConnections), or create a [new connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#CreatingNewConnections), for **Oracle**. The Oracle settings form opens.

   ![Oracle Settings Form](https://docs.sisense.com/main/Resources/Images/Oracle Settings Form.PNG)
4. Select your live Oracle data source:
5. From the **Select connection type** menu, depending on the information you have for your Oracle connection, select the relevant connection type.

   - **Basic**

     ![Oracle Connector - Basic](https://docs.sisense.com/main/Resources/Images/Oracle Connector - Basic_1147x315.png)

     - *Location* - Enter the address of the remote server to connect to, in the format *host:port*.
     - *User Name* - Enter the user name to connect to the database.
     - *Password* - Enter the user name's password to connect to the database.
   - **ServiceId**

     ![Oracle Connector - ServiceId](https://docs.sisense.com/main/Resources/Images/Oracle Connector - ServiceId_560x315.png)

     - *Location* - Enter the address of the remote server to connect to, not including the port.
     - *User Name* - Enter the user name to connect to the database.
     - *Password* - Enter the user name's password to connect to the database.
     - *Service ID* and *Port* - Enter your Service ID. These can be found in the TNSNAmes.ora file. See: [Service ID](http://www.orafaq.com/wiki/Tnsnames.ora.htm).
     - *Additional Parameters* (Optional) - Enter additional configuration options by appending key-value pairs to the connection string (for example, Schema=XXX;). For a full list of connection string options, click [here](https://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDBFDF.htm).
   - **ServiceName**

     ![Oracle Connector - ServiceName](https://docs.sisense.com/main/Resources/Images/Oracle Connector - ServiceName_1152x315.png)

     - *Location* - Enter the address of the remote server to connect to, not including the port. Optionally, an Oracle connection string can be used:

       `(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=your_ip)(PORT=your_port))(CONNECT_DATA=(SERVICE_NAME=$service_name)))`

       replacing $your\_ip, $your\_port, and $service\_name. These values can be found in the TNSNAmes.ora file. You can find a full description in [Service ID](http://www.orafaq.com/wiki/Tnsnames.ora.htm).
     - *User Name* - Enter the user name to connect to the database.
     - *Password* - Enter the user name's password to connect to the database.
     - *Service Name* and *Port* - Enter your Service Name. These can be found in the TNSNAmes.ora file. See: [Service Name](https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams188.htm#REFRN10194.htm).
     - *Additional Parameters* (Optional) - Enter additional configuration options by appending key-value pairs to the connection string (for example, Schema=XXX;). For a full list of connection string options, click [[here](https://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDBFDF.htm)].
   - **TNS**

     ![Oracle Connector - TNS](https://docs.sisense.com/main/Resources/Images/Oracle Connector - TNS_1153x315.png)

     - *User Name* and *Password* - Either use your Windows login details if they are configured with the database, or enter the username and password to connect to the database.
     - *TNS\_ADMIN path* - Enter the full path of the .ora file.
     - *Network Alias* (Optional) - Enter the network alias, if there is one.
     - *Additional Parameters* (Optional) - Enter additional configuration options by appending key-value pairs to the connection string (for example, Schema=XXX;). For a full list of connection string options, click [[here](https://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDBFDF.htm)].
   - **Custom**

     ![Oracle Connector - Custom](https://docs.sisense.com/main/Resources/Images/Oracle Connector - Custom_1156x315.png)

     - *User Name* and *Password* - Either use your Windows login details if they are configured with the database, or enter the user name and password to connect to the database.
     - *URL connection string* - The JDBC connection string.
6. Click ![Next](https://docs.sisense.com/main/Resources/Images/Next.png). A list of tables in the database is displayed. All tables and views associated with the database appear in a new window.

   ![Db list](https://docs.sisense.com/main/Resources/Images/db-list.png)
7. Select a database. The list of tables in that database appears.

   ![Table list](https://docs.sisense.com/main/Resources/Images/table-list.png)
8. From the Tables list, select the relevant table or view.

   You can click ![8 5previewtable](https://docs.sisense.com/main/Resources/Images/8-5previewtable1.png) next to the relevant table or view to see a preview of its data. 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), or **Add Custom Import SQL** (for ElastiCube).
9. (Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube. You can disable this by toggling the **Import Relationships** switch.
10. (Optional) Click + to to use SQL to customize the data. For more information, see [Creating Custom Live Table Queries](https://docs.sisense.com/main/SisenseLinux/creating-custom-live-table-queries.md) or [Importing Data with Custom Queries](https://docs.sisense.com/main/SisenseLinux/importing-data-with-custom-queries.md).
11. After you have selected all the relevant tables, click **Done**. The tables are added to your schema in Sisense.