How to output data retrieved from a database to a CSV file

Question

How do I output data retrieved from a database to a CSV file?

Answer

Data can be retrieved and output to CSV files by Read Table or Execute Select SQL operations.

1. Table Read operation
   Required components
   ・Table Read Processing
   ・Mapper
   ・Write CSV File
   
   Connect Table Read and Write CSV File operations with Mapper and output to CSV file.
   
   
2. Execute Select SQL operation
   Required components
   ・Execute Select SQL
   ・Mapper
   ・Write CSV File
   
   Set the output schema in Execute Select SQL and output to Mapper.
   The following procedures are the same as for Table Read operation.

Please refer to the following pages for the setting items of each component and how to use Mapper.

Read Table
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/database_read_table.htm

Execute Select SQL
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/database_execute_select_SQL.htm

Write CSV File
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/csv_put_data.htm

Mapper Logic
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/mpp_logic_and_schema_spec.htm