Access external data sources and web services from your autonomous database
summary
Demonstrates concrete APIs and configs: enable principal-based authentication for OCI/Azure/AWS/GCP, then load files with DBMS_CLOUD.COPY_DATA using credential names like OCI$RESOURCEPRINCIPAL or AZURE$PA; create external tables over CSV/Parquet/ORC/JSON from OCI, Azure, S3 or GitHub; call HTTPS services via UTL_HTTP with DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE and the built‑in wallet (90+ certs); use built‑in, no‑cost gateways and DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK+gateway_params to query Redshift, Snowflake, MongoDB, MySQL, Postgres and Hive.
AI-written summary · about
chapters (7)
- 0:00Intro
- 0:44What is Autonomous Database (ADB)?
- 6:53Principal Authentication for OCI, Azure, AWS, and GCP
- 10:24Loading Data from Object Stores
- 17:34Creating and Querying External Tables
- 20:25Oracle-Managed Heterogeneous Connectivity
- 23:50Calling Web Services
related talks
27mYour multicloud strategy and Database Cloud Services
14mCloud Native Development with Oracle Database
21mDeep dive: Data loading
18mMulticloud Development with Microsoft Azure and Oracle Database Cloud
27mAutonomous Database Data Studio
28mAutonomous Data Warehouse and the Data Lake
31mAutonomous Database: Simplify your database management
30mSelf-service data warehousing