Difference between revisions of "Linking Autoloaders"

From SmartWiki
Jump to: navigation, search
Line 21: Line 21:
  
 
[[Image:LinkingAutoloader_1.PNG]]
 
[[Image:LinkingAutoloader_1.PNG]]
 +
 +
3. External Data Source & Schedule
 +
 +
''Autoloader 1''
 +
a. Proceed to the ''General'' tab,  select ''Connection Type'' and configure [[Auto_Loader#External_Data_Source|connection type]].
 +
 +
b. [[Auto_Loader#Schedule|Configure schedule]]
 +
 +
''Autoloader 2''
 +
c. Proceed to the ''General'' tab,  select ''Connection Type'' and configure [[Auto_Loader#External_Data_Source|connection type]].
 +
 +
d. [[Auto_Loader#Schedule|Configure schedule]]
 +
 +
If you are using the same file, ''Connection Type'' should be ''N/A'' and ''Frequency'' should be ''On File Upload''
 +
 +
If you are using a different file, configure c & d the same way as a & b.
  
  

Revision as of 14:24, 3 July 2018

Overview

New ability to chain multiple autoloaders to run the same file in sequence. This allows you to load a single file through multiple autoloader imports in a specific sequence. This is useful for various integration processes that aim to import data.

Use Cases

  • Using the same file in different autoloaders
Example a company record contains three addresses organised by column. So first Autoloader reads and creates the company record including default address. Second Autoloader uses other columns to create second address record.Third Autoloader creates the third address records.
  • Using different files as per autoloader sequence
Example one file contains company records, second file contains addresses for company. Two Autoloaders are required.

In both cases, autoloader will process the file/files in sequence.

Configuration

1. Create two autoloaders 

  • e.g. Autoloader 1 will create the Parent Company while Autoloader 2 will create the sub-companies.

2. Link the second autoloader to the first autoloader

  • Go to the settings of Autoloader 1 and proceed to the PROCESS tab,
    and select Autoloader 2 from the Run sequential Autoloader after loader ends

LinkingAutoloader 1.PNG

3. External Data Source & Schedule

Autoloader 1 a. Proceed to the General tab, select Connection Type and configure connection type.

b. Configure schedule

Autoloader 2 c. Proceed to the General tab, select Connection Type and configure connection type.

d. Configure schedule

If you are using the same file, Connection Type should be N/A and Frequency should be On File Upload

If you are using a different file, configure c & d the same way as a & b.


See Also