First, an overview
• Table output
• Update, delete, insert / update
• Batch loading (mysql, Oracle)
• Data synchronization
• SQL File output
• Text file output
• XML output
• Excel Output/Excel Writer
Other (reports, applications)
Two. The output of the database
Inserting data into the database using SQL (INSERT)
Support batch submission
Support partition (Date partition)
Support field mappings
Support return self add
Here is a solution to the problem of Chinese garbled with table output.
Set up the connection code: characterEncoding utf8
Setting up the connection encoding can normally output the characters that are not messy. If there are still problems, you can continue to set up client encoding.
Set the client: set names utf8;
The output of a test table is as follows:
If you select the partition, you need to select the Date field to partition, and you need to create the table manually (for example, monthly partition, 201804201805 and two months, then you need to create a tb_201804 tb_201805 two tables).
2.Return to the self – added primary key
The configuration of the table output is as follows:
The preview can check the returned primary key:
3.Database field mapping
The preceding steps can match the following table output with field mapping:
The table output configuration is as follows:
If you use guessing, you can make name matching. If you need manual matching, you can choose between left and right, click Add.
And after mapping, you can also delete and discard some fields.
4.Other operations — deleting, updating, and inserting updates
Delete the existing data in the database based on keyword matching.
Update existing data in database based on keyword matching.
There are updates, no inserts.
The operations are all similar and match above.
A comparison based synchronization method. Perform the corresponding insert / update / delete operation according to a flag field.
The configuration diagram is as follows: use the merged flag field (possibly new deleteed and other flag), then follow the flag synchronously changing data to table 1.
Load data using stream mode
MySQLBatch loading needs to run in the Linux environment (commands can only be run under Linux).
OracleNeed local Oracle client (sqlldr file, found in Oracle installation directory)
Three. File output
The corresponding SQL script (DDL, DML) is generated according to the selected database type.
Note that 2007 of the previous versions had 65536 line limit:
3.Text file output
For example, TXT JSON, etc.
Four. Other output
To generate PDF (Excel, HTML and other formats), we need to define the report template in advance.
In the same way, I don’t think about it for the time being.