Connectors and Connections

Back Next

Use the serverless runtime environment

You can use the serverless runtime environment with the Oracle Databse Ingestion connector to connect to the Oracle database.

Before you configure an Oracle Database Ingestion connection using the serverless runtime environment, perform the following tasks:

Prepare the Oracle OCI driver as a zip file.

Add the Oracle OCI driver as a zip file in the Azure container in your Azure account.

Configure the .yml serverless configuration file.

Prepare the Oracle OCI driver zip file: Perform the following steps:
Download the required version of the Oracle OCI drivers for Linux x86_64 (64 bit).
Extract the downloaded zip file on a Linux machine.
Update the name of the internal folder in the extracted zip file to
oracle-oci-client
.
Create a symbolic link in the
oracle-oci-client
folder with the following command:
ln -s libclntsh.so libclntsh.sl
Reassemble the zip file with the following command:
zip -yr oracle-oci-client.zip oracle-oci-client

Add the Oracle OCI driver as a zip file in the Azure container in your Azure account: Perform the following steps:
Create the following structure for the serverless agent configuration in Azure:
<Supplementary file location>/serverless_agent_config/oci

Add the Oracle OCI driver as a zip file in the internal subfolder
oracle-oci-client
.
The Database Ingestion agent service ociPath property value in the serverless runtime environment is defaulted with the following path:
/home/cldagnt/SystemAgent/serverless/configurations/odbc/oracle-oci/oracle-oci-client

Configure the .yml serverless configuration file: Perform the following steps to configure the .yml serverless configuration file in the serverless runtime environment:
Copy the following code snippet to a text editor and specify the driver file name:
version: 1 agent: databaseIngestion: autoDeploy: oracle: oci: drivers: - fileCopy: sourcePath: oci/<file_name>.zip

where the sourcePath specifies the directory path of the Oracle OCI drivers in Azure.

Ensure that the syntax and indentations are valid, and then save the file as
serverlessUserAgentConfig.yml
in the following Azure location:
<Supplementary file location>/serverless_agent_config

When the .yml file runs, the Oracle OCI drivers are copied from the Azure location to the serverless agent directory.