LOAD-it

Load data from anywhere

LOAD-it can load data from almost any relational* or flat-file source. Data Academy automatically discovers the tables and columns to import, including data types and primary keys.

Data sources include SQL Server (all versions), ORACLE, Text, MS Access (all versions) and ODBC. Incremental loads are supported for all relational data types, by identifying a Last Updated field in the source.

Once you have configured your import, Data Academy will build the entire infrastructure - staging and import tables and an SSIS package with step-by-step logging. You can even open the SSIS package in BIDS to add your own customizations to the import process.

* Level 3 ODBC compliance required.