Oracle Cloud Interface
Always Free ADW Does Not Allow Private End Point Networking
When spinning up an Autonomous Data Warehouse in the Oracle Cloud OCI please take note that the always free versions do not allow you to update Network Access and set the database to a private end point in your VCN. This means unless you upgrade to a paid version of the database you cannot incorporate the data as part of a Bastion Server or configure it for TLS access. A potential work around may be to set your ADW database Access Control list to enable, but in doing so, you will be restricted to accessing the database from only Public IP addresses that you configure under Access Control. This may also limit you to accessing your ADW Database with third-party clients using a database wallet.
Using Oracle ODBC Drivers
Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. The application's source code does not have to be recompiled for each data source. A database driver links the application to a specific data source. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. Therefore, the application can access any data source for which a database driver exists.
Setting Up Oracle ODBC & Client
Oracle Instant Client enables development and deployment of applications that connect to Oracle Database, either on-premise or in the Cloud. The Instant Client libraries provide the necessary network connectivity and advanced data features to make full use of Oracle Database. The libraries are used by the Oracle APIs of popular languages and environments including Python, Node.js, Go, PHP and Ruby, as well as providing access for Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), JDBC OCI, ODBC and Pro*C applications. Tools included in Instant Client, such as SQL*Plus, SQL*Loader and Oracle Data Pump, provide quick and convenient data access.
Installing the Oracle CLI
This section documents how to quickly install and configure the OCI Command Line Interface (CLI) For the Following Environments
Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) is a small-footprint tool that lets you create and manage resources in Oracle Cloud using a command line interface. It enables you to automate tasks and makes things easier.
Oracle Data Provider for .NET
Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, Application Continuity, and Fast Connection Failover. Developers can also use popular .NET features, such as Entity Framework Core.