Infostrux Loader

This application performs the "load" (L) portion of an "extract load transform" (ELT) data pipeline. It works on raw extracts that conform to Singer open-source standard.

The application provides a stored procedure that performs the load. The input is a table, view, or query string that returns the raw extracted data. The stored procedure reads the raw extracted data, creates target tables with proper schema, and populates them. The stored procedure manages target table schemas as needed. The stored procedure returns the state needed for the next incremental extraction.

The functionality of the app is similar to that of a Singer target.

The app works well with extractor applications that output data conforming to Singer standard (https://github.com/singer-io/getting-started), such as Infostrux Extractor Apps, but it can be used standalone.