Spoon (Kettle) Basic Configuration (Connect MySQL and Oracle)

1. Download the spoon package and driver

   The spoon package I use, including spoon7.1, Mysql driver and Oracle driver

   link: https:// pan.baidu.com/s/16Q-iUNB7qGU0xlKbGTw-vg Extraction code: q9h5

   If you have installed an Oracle database or oracle client locally, you can use its own Oracle driver,

< p>   all the jar packages beginning with ojdbc under the directory: \product\11.2.0\dbhome_1\jdbc\lib

2, double-click spoon.bat to open the spoon main page

Click “File” in the upper left corner, create a new conversion, configure a data connection (using mysql database as an example)

   select the “main object tree” in the left working area, select DB connection, right-click and select New, enter Configuration information

  If the database is local, the host name can be written as localhost, if not locally, write the ip of the host where the database is located

  share picture

3. Click test, and the following pop-up box appears, indicating that the configuration is correct Share pictures

For Oracle database connection, please refer to the following configuration:

Share a picture

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 2985 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.