Data Loader

You can use data loader to migrate many database tables at once directly to Data Lake.

Data Loader is started manually. It connects to the database through an Enterprise location. After connection, it starts loading all the columns from the selected tables and creates data objects with the newline-delimited document type. The maximum size of each object is 50 MB of uncompressed data. The Data objects are compressed and sent through API Gateway directly to the Data Lake Batch Ingestion API.

Before you can use Data Loader, you must define a new Database connection point with the Data Loader type. Define object schemas in Data Catalog with the Metadata crawler.

How to define a new Database connection point with Data Loader type, see the Infor ION Technology Connectors Administration Guide.

How to use Metadata Crawler to generate object schemas for selected tables or views from database, see Metadata Crawler wizard.