SC Navigator ETL Module

SC Navigator ETL (Extract, Transform, Load) is technology that simplifies data management by automating the process of collecting, transforming, and loading data into our application. With built-in automation, integration, and guidance, SC Navigator ETL eliminates the manual burden of preparing your data so you can focus on optimizing your supply chain.

With the SC Navigator ETL module, we offer our users access to an existing ETL tool, namely Azure Data Factory (ADF). ADF will be deployed in a separate environment on Azure with a pre-configured connection (REST API) to your specific AIMMS Cloud. You will receive a handbook which will guide you through the first steps of the tool. After the first steps, you are free to use the ETL tool in any way you prefer. Data on the ADF environment and on the AIMMS Cloud environment will be separated from other customers that are using the ETL module. Users need to sign up to the ADF instance with their email address and will require Multi-Factor Authentication (MFA) or SSO if they already have an Azure identity.

The ETL module requires a module purchase for existing and new accounts. The ETL module contains the following features:

• Access to your own Azure Data Factory Studio.

• Automated integration with SC Navigator for effortless data transfer.

• Step-by-step handbook to guide users through the process.

You can download the handbook here: Download the ETL handbook