Quick and Easy Data Load From MS Excel to Oracle DB - No ETL Tools Needed

Опубликовано: 12 Октябрь 2024
на канале: YouVolve

225

Hello viewers, in this tutorial we are going learn how to extract, transform and load data from a Microsoft Excel worksheet or a text file in csv or other format to an oracle database without using any ETL tools.

If you are familiar with ETL or extract transform and load processes you might already be aware of many ETL tools like oracle DATA INTEGRATOR, IBM DATASTAGE, AWS GLUE, MS SSIS etc. Please note that this demo is to show you a quick and simple way to load data to an oracle database and it is not a replacement to the ETL tools and their versatile features.

If you are an oracle data professional, you might be aware of the data load and unload tool from oracle like SL Loader, data pump etc. But there is another hidden treasure in oracle called external table to load and unload data in a very quick and easy way. External table method internally uses the traditional data load and unload APIs but if you use this method you don't have to learn those tools like oracle SQL Loader or oracle data pump etc.

It is so simple that you can make it right even in the very first use. And as a data professional you will find this method very handy in many situations.

In this demo, I will use the data in an excel worksheet with little over 170,000 rows to extract, transform and load to an oracle table using an oracle external table.

Part-2 of the series:
   • Quick and Easy Data Load From MS Exce...

Full Syntax and Access Parameters of External Table Command:
https://docs.oracle.com/cd/B10500_01/...

Source data file in CSV format:
https://drive.google.com/file/d/1bulV...

Commands used in the tutorial:
https://docs.google.com/document/d/1K...

My Other Tutorials:

Create your Virtual Learning Environment Using Oracle VirtualBox Virtual Machines
   • VBox Virtual Machines

Oracle Database:
   • Oracle DBA

Installing SQL Developer on Windows, Linux or MAC:
   • Installing SQL Developer - The Free T...

Happy Learning.