Shulou(Shulou.com)06/01 Report--

Today Xiaobian to share with you about pentaho tools to import and export database data into Excel graphics and text methods of the relevant knowledge, detailed content, clear logic, I believe that most people are too aware of this knowledge, so share this article for your reference, I hope you will learn something after reading this article, let's take a look at it.

Requirement 1: export mysql table data to Excel step 1: add a database driver package

Note: since I want to export the mysql database data in this example, I need to copy the mysql driver package to the bin directory in the root directory after the tool is extracted.

After downloading the compressed package and decompressing it, there will be such a file in its root directory.

This file is the batch file under Windows and is used to open the pentaho tool.

Step 2: create a new transformation

1. Select the conversion right button to create a new.

2, drag a table input and an Excel output to the work area on the right in the toolbar on the left.

Step 3: configure the database connection

1, double-click the table input to enter the editing interface

Click New to enter the database connection configuration

Resolution: here mainly configure the local name, as well as select the database type, configure the host IP, database name, port number, user name, password.

After the configuration, you can preview the data.

Step 4: configure the output Excel format

1. We can take a look at the data of native mysql before exporting.

2, hold down shift and use the left mouse button to drag the table input to the Excel output

3. Similarly, double-click Excel to configure relevant configurations, such as file location and file encoding.

Step 5: run

1. Click the toolbar above the work area to select run

Parsing: after running, the data basically comes out, and then the date does not display properly. You just need to set the relevant properties of Excel.

Requirement 2: import Excel data into mysql database step 1: organize the data

1. We modify the data exported above to make it easier to distinguish

2. Delete the original data

Step 2: create a new transformation

1, same as before, but this time it is a new Excel input and table output

2. Configure connection and Excel input. Table output is the same as before.

Step 3: configure character encoding

Note: when inserting data, you must not forget to configure the corresponding code, otherwise it is up to you.

Step 4: view the results

Parsing: no problem, the data was successfully re-imported.

These are all the contents of this article entitled "how pentaho tools import and export database data into Excel graphics and texts". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.