Information Systems:Notes on development using Iptor Integrator

Noteworthy libraries

This section lists some important libraries that greatly enhance development, or make it possible altogether.

• [Information Systems: IBM Toolbox for Java|IBM Toolbox for Java] - Programming in Java for IBM i would be useless without this quintessential package.
• Apache Commons - another immensely useful library. Actually, Commons is an umbrella for a collection of many libraries. The significant ones thus far are:

• Apache POI - For reading/writing to Microsoft document formats. The XSSF is particularly useful for dealing with XLSX files e.g. the Health Canada MAR report uses this to output and stylize the report.
• Apache Commons Net - FTPClient class used for creating
• Apache Commons CSV - Useful for reading/writing CSV files.

• JCraft - For sFTP communication. Apache Commons Net is limited to FTP.
• univocity - CSV parser/writer. The CSVWriter class has features that are not found in Apache Commons CSVPrinter.
• MariaDB JDBC driver - to read/write to the database.