Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Use Case Overview

This Use Case would help you jumpstart solution development for a Adeptia Solution developer with basic knowledge of ETL. ETL is the most common integration pattern where the key requirement is to pull or receive data from a source system or a file  and perform the necessary transformation and deliver to a target system or file. 

This document will outline the key steps to very quickly setup an ETL based transformation.

Scope of Use Case

Applicable Scenarios

  • This use case is applicable for any simple ETL use case for source and target systems supported by the product..
  • Uses out of the box pre-built Data Integration Flow.
  • Transactions using this template is meant to be used bu internal Business users.

Excluded Scenarios

  • Not recommended for partner self-service.
  • Post processing  and complex mapping requirements.

Pre-requisites

Following are the pre-requisites to implementing the the simple ETL use case:

  • Input schema and type of source data (file in this case ). The most common types are XML, Excel, CSV, JSON, Text, and Database.
  • Source Type - File or LAN location in this example.
  • Target schema and type. The most common types are XML, Excel, CSV, JSON, Text, and Database.
  • Target Type - File or LAN location in this example.
  • No labels