Kettle importing Excel data to Oracle

Guide

Ways to import Excel data into an Oracle database:

1. Low efficiency using the features included with the PL SQL tool

Refer to this article for an introduction: http://www.2cto.com/database/201212/176777.html

2, the use of kettle tools, free, compared to more rich features, can achieve a certain business logic, recommended use

Kettle importing Excel data into the Oracle process is logged as follows:

1. Prepare Excel File:

Note: The Excel file should have a field name Description: as Id,name,age here

2. Open kettle, file-to-new conversion, input---Select Excel input, drag it into the right side of the work bar

3.

Reference:

Use kettle to save data from Excel to the database-bestree007 column-Blog channel http://blog.csdn.net/bestree007/article/details/51088340

Using the Kettle component to import Excel files into a database-database other synthesis-Red and black Alliance http://www.2cto.com/database/201411/352182.html

Problems encountered:

Easy to solve Kettle connect Oracle Database-Data warehousing technology-refining into gold-dataguru professional data analytics Community http://f.dataguru.cn/thread-182412-1-1.html

Kettle Frequently Asked questions (turn)-asyl-Blog Park http://www.cnblogs.com/mybi/archive/2012/06/28/2568740.html

Kettle importing Excel data to Oracle