External Data

Data, whether for an enterprise application or quick analysis, can come from a myriad of sources. Dyalog provides the tools to access and manipulate data irrespective of the source. These tools could be integral to the APL interpreter or provided in an APL library.

A good place to start is the LOADDATA workspace, which contains example functions to read and write data in a variety of formats, including Microsoft Excel spreadsheets, XML files, SQL tables and CSV/text files.

Read more about the support that Dyalog and its tools provide for different data formats below.

Relational Database Access using SQAPL

SQAPL provides an interface to ODBC-compliant SQL databases including Oracle, MS Access, MySQL and DB2. Even properly-formatted text and CSV (comma separated value) files can be accessed using SQAPL.

SQAPL contains functions to read, write and manage SQL databases. It is supported on all platforms, although some platforms could incur an additional licence fee for the server component of SQAPL.