Article From:https://www.cnblogs.com/lm970585581/p/9216314.html

First, an overview

  Database table:
    • Table output
    • Update, delete, insert / update
    • Batch loading (mysql, Oracle)
    • Data synchronization
  Document:
    • SQL File output
    • Text file output
    • XML output
    • Excel Output/Excel Writer
  Other (reports, applications)

Two. The output of the database

  1.Table output

    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:

  

  Field mappings:

    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:

      Delete the existing data in the database based on keyword matching.

    To update:

      Update existing data in database based on keyword matching.

    Insert updates:

      There are updates, no inserts.

  The operations are all similar and match above.

  

  5.Data synchronization

    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.

    

  6.Batch loading

    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

  1.SQLFile output

    The corresponding SQL script (DDL, DML) is generated according to the selected database type.

    

  2.excelFile output

    Note that 2007 of the previous versions had 65536 line limit:

    

 

   3.Text file output

    For example, TXT JSON, etc.

 Four. Other output

  1.Report output

    To generate PDF (Excel, HTML and other formats), we need to define the report template in advance.

  2.XMLoutput

    In the same way, I don’t think about it for the time being.

Leave a Reply

Your email address will not be published. Required fields are marked *