Connecting to Oracle
Note: This topic describes how to import data using the online Sisense Web Application. To import data through the desktop ElastiCube Manager, click here.
Sisense enables easy and quick access to databases, tables and views contained within Oracle databases. The steps below describe how to connect to this type of data source.
To import data from Oracle:
- In the Data page, open an ElastiCube or create a new ElastiCube.
- In the ElastiCube, click . The Add Data dialog boxis displayed.
- Click Oracle Database to open the Oracle settings.
- Enter the following details:
- Location: Enter the computer/server IP address of the database. To connect to a database running on your own computer enter localhost.
If Windows Authentication is configured with the database in the User Name and Password fields, enter your database credentials.
Use Direct Connection: You can also use a direct connection to connect. Select Use Direct Connection. You will need to enter the Service ID and Port number to connect.
Service ID: Enter your Service ID. This can be found in the TNSNAmes.ora file. You can find a full description in the following topic: Service ID.
Note that in the file for each tnsname, you can find the service ID and service name.
User name and Password: Either use your Windows login details if they are configured with the database, or alternatively enter the username and password to connect to the database.
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.
(Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube. You can disable this by toggling the Import Relationships switch.
(Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
After you have selected all the relevant tables, click Done. The tables are added to your schema in Sisense.