Add Oracle Instant Client

This article explains how to add Oracle Instant Client to your Exasol SaaS system.

Exasol can exchange data with Oracle databases through Oracle Instant Client. You can upload the client using the File Management page in Exasol SaaS. You must first create a folder in the file system to store the client.

Prerequisites

• You must be logged in as a user with the Owner role.

• Oracle Instant Client 23.5.0.24.07 must be downloaded to your local machine. You can download the client using this link.

Oracle Instant Client 23.5.0.24.07 is the only version supported in Exasol. This version has been deprecated and the download link on this page is therefore not guaranteed to work.

Upload Oracle Instant Client

1. On the Databases page in the web console, open the database dropdown menu and select Manage UDF Files.

   

2. On the File Management page, click on Add folder and create a folder with the name drivers.

   

3. Select the drivers folder and click on Add folder to create a child folder inside it with the name oracle.

   

4. Select the oracle folder, then click on Upload file.

   

5. Select the Oracle Instant Client file on your computer to add it to the Upload files dialog, then click on Upload to upload it, or click on Cancel to abort the upload.

   

6. Verify that the client has been added to the file system.