Databases

The ETL Client utilizes two databases, a Repository database for managing Jobs and Transformations, and a Staging database for storing and facilitating the transfer of Data Lake data to an on-premises environment.

The ETL Repository is tested with these database platforms: MS SQL Server 2016, 2017, 2019, and 2022.

While the ETL Client application does offer additional connectivity options to other database platforms, it should be noted that the necessary drivers for these platforms are not included with the ETL Client installation and are the responsibility of the user to obtain and install them.

It is recommended to use Microsoft SQL Server database for optimal support from Infor. If another database platform is chosen, Infor's ability to provide assistance with connectivity or syntax issues may be limited as the database platform has not been thoroughly tested.

Repository database
The ETL Client Repository database stores and manages the Jobs and Transformations. It is recommended that you use a Repository database size of 5 GB. This database holds all transformation and job step information.
Staging database
The Staging database serves as the target location for loading data from the Data Lake. The size of the Staging database depends on the data that is required to be moved from Data Lake to an on-premises environment.
Database User
The ETL Client requires a SQL Authenticated (no password expiry) database user with dbo_owner permissions to both databases to create tables, views and indexes.

Naming Convention

Although databases can be named in any manner, we recommend that you keep the naming convention in alignment with the Infor OS Data Lake tenant suffix, for example: prd, trn, tst, and so on.

Example for a “prd” (production) tenant:

  • di_prd_repository
  • di_prd_staging
Note:  A repository and staging database must be identified or created for each tenant that is expected to extract data from Data Lake.

Folder structure

This table shows the recommended server folder structure:

Name Description Standard value
IONETL_BASE IONETL Software base catalog x:\Infor\IONETL
JAVA_HOME JAVA JDK 1.8 This is based on the installed java version.

For example:

C:\Program Files\Amazon Corretto\jdk1.8.0_252
DI_DESIGNER ETL Designer x:\Infor\IONETL\Infor_ION_ETL_%version%