By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Loading Data into Autonomous Data Warehouse Cloud Database

 

Data Loading Options

  • Data loading via SQL*Net
    • Suitable for small volumes of data
      • SQL*Loader from local filesystem
      • ETL scripts that use DML to insert/update data
  • Data loading from Oracle Object Storage
    • Preferred technique for large volumes of data
      • Additionally enables data-sharing with other cloud services
  • Stage data in Oracle Object Storage, then load into the database using new PL/SQL APIs

 

Loading Data from Object Stores

  • Source data from files on object stores for data loading
    • Oracle Object Store or AWS S3
    • Any supported Oracle-loader file format
    • Roadmap: any Hadoop file format

lou011.jpg

 

New Cloud API to Access Object Stores, DBMS_CLOUD

  • New PL/SQL package for accessing files in object stores
  • No need to manually define external tables for loading files
    • Makes it easier to specify the format of the source data

lou022.jpg

 

Loading Data from the Oracle Object Store

  • Define your credentials for the object store
    • Oracle Cloud Infrastructure Object Store username and Swift password required
  • Credential stored in the database schema once and used for accessing the object store for all loads

lou033.jpg

 

Loading Data from the Oracle Object Store

  • Load data directly into the target table without any intermediate steps
  • Data format in the source file easily specified as JSON

lou044.jpg

 

Troubleshooting Loads

  • Load operations logged for troubleshooting and historical load tracking
    • New table user/dba_load_operations
  • Log and bad files accessible as tables

lou055.jpg

 

As an additional resource you can listen here an interesting Podcast about this topic

Oracle Cloud Podcast Series: Oracle Autonomous Data Warehouse Cloud

http://streaming.oracle.com/ebn/podcasts/media/30324001_Autonomous-Data-Warehouse_Sep_2017.mp3

Oracle Cloud Podcast Series Featuring Oracle's VP of Product Management Discussing the new Oracle Autonomous Data Warehouse Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co