Connecting to Oracle¶
Anaconda Enterprise enables you to connect to your Oracle database, to access data stored there without leaving the platform.
Before you can do so, you’ll need to install the following conda packages which contain the Python extension module and kernel access libraries required to connect to Oracle:
See Developing a project for information about the various ways to add packages to a project, and the implications of using each method.
You’ll also need to download the appropriate client-side files required from Oracle.
If your organization requires Anaconda Enterprise users to download and install the Oracle Instant Client as a package—from a secure private repository, for example—see these instructions for building an Instant Client package. Otherwise, let your Administrator know that you need them to build it, if that’s your typical workflow.
You can then use code such as this to access an Oracle database from within a notebook session:
See Storing secrets for information about adding credentials to the platform, to make them available in your projects. Any secrets you add will be available across all sessions and deployments associated with your user account.