Data Output, Reporting, and Connectors
What to know
Output mastery covers the Output Data tool (file formats, delimiters, encoding, overwrite vs. append, and "output to multiple files" by grouping field), and database outputs (write modes: create, append, overwrite). Reporting tools include the Table, Render, Layout, and Report Text tools, plus the Report Map and Charting tools; understand how report objects flow into a Render or Layout to produce a final document (PDF, HTML, etc.). Connectors include input/output to databases and cloud sources; know that connection credentials and drivers matter.
Traps
- Overwrite vs. append: Output Data defaults can overwrite; appending requires the correct setting and matching schema.
- Grouped output: "Output to multiple files" uses a grouping field; the filename can incorporate the group value.
- Report assembly: Table/Chart objects must be combined via Layout and finalized with Render to produce a single document.
- Schema on append: Appending to a database requires matching columns/types; mismatches fail.
- Encoding on output: Writing CSV without the correct code page can corrupt non-ASCII characters.
Rule of thumb
Decide the destination first: file → Output Data with format/encoding/overwrite settings; database → connector with explicit write mode; document → Table/Chart into Layout into Render. Confirm schema compatibility before appending.
Worked example
To produce one PDF per region: build a Table tool per region's data, group the output by Region, route each group through Layout and Render to PDF, and use Output Data configured to write a separate file per group named with the region value.