Oracle

Access configuration details to connect Soda to an Oracle data source.

Connection configuration reference

Connecting to Oracle requires having installed the soda-oracle package using the Private PyPi installation flow available wtih Entreprise license, unless you are using a Runner.

Need access to the private PyPI? Please contact us.

Install the following package:

pip install --pre -U "soda-oracle>4" -i "https://${SODA_CLOUD_API_KEY_ID}:${SODA_CLOUD_API_KEY_SECRET}@enterprise.pypi.us.soda.io/simple

The package must be installed from Soda's private enterprise pypi server using Soda Cloud API keys from an organization with an Enterprise license.

Data source YAML

Create the config file:

soda data-source create -f ds_config.yml

The data source configuration YAML should look like the following:

ds_config.yml

type: oracle
name: my_oracle
connection:
  user: system
  password: ${env.ORACLE_PASSWORD}
  host: oracle.databases
  port: 1521
  service_name: SODA

Note: Oracle Client Libraries must be available to connect to Oracle via Soda Core. You should install the appropriate Oracle Instant Client and make sure that the libraries are accessible, e.g.,:

export PATH=$PATH:/Users/adkinsty/Downloads/instantclient_23_3
export DYLD_FALLBACK_LIBRARY_PATH="/usr/local/lib:~/Downloads/instantclient_23_3:~/lib"

Connection test

Test the data source connection:

soda data-source test -ds ds_config.yml

---

Text truncation in Diagnostics Warehouse

When using Oracle as your Diagnostics Warehouse target, large text values may be truncated (4,000 char limit) or produce hashing collisions when stored in Soda result tables.

To learn more, go to limitations & edge cases in Diagnostics Warehouse data sources.

---

You are not logged in to Soda and are viewing the default public documentation. Learn more about Documentation access & licensing.

If you do have a Soda license, make sure to log in to Soda Cloud in this same browser.