This topic describes how you can add live connections to your Oracle databases from the Sisense Web Application.
For information about live connections, see Sisense Live Connect.
Adding Oracle Live Connections
To add a live connection:
- In the Sisense Web Application, select Admin > Data Sources. The Data Sources page is displayed.
- In the Data Sources page, click Add Live Connection. The Add Live Connection dialog box is displayed.
- In the Add Live Connection dialog box, select your live data source.
- Under the Connect tab, enter the following credentials:
- (Optional) 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.
- Click Next.
- Under the Select Data tab, on the left side is a list of schemas located in your data source. Select the relevant schema. You can find the schema easily by searching for it through the search field at the top of the list to filter the schemas displayed. After selecting the schema, a list of the available tables and views are displayed.
- Select a table or view. You can find the table easily by searching for it through the search field at the top of the list to filter the tables displayed.
- Click Next.
- Under the Connection Settings tab, set the following:
Connection Name: Enter a name for your connection. This field defines the name of your data source displayed in the Sisense Web Application.
Refresh Rate: Enter or select the refresh rate for your data source. The shortest refresh rate you can set is 10 seconds. The refresh rate is the time in between queries to the data source. If the previous query has not been completed, the next query is not sent until the previous refresh is complete unless the refresh rate is greater than the time it took to complete the refresh since the last query. For example, if your refresh rate is 10 seconds, and your query takes 15 seconds, the next query is sent when the previous query is complete as 10 seconds has passed and the previous query is complete. If your refresh rate is 30 seconds, and the previous query is complete, the next refresh will be in 30 seconds from the last query.
Time Out: Enter or select the Time Out rate for your data source. The Time Out rate determines how long Sisense waits before cancelling a query that does not receive a response from your data source.
- Click Done. The connection is added as a data set to your Data Sources page.
Location: The IP address of your data source.
User Name: The user name to access data source.
Password: The password to access your data source.
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.