User Guide : Using Design Templates : Available Templates
Share this page             
Available Templates
The following table provides a brief description of the workflows. The templates have built-in documentation with more details.
Enables you to quickly load data from the following sources into Avalanche on AWS, Azure, or Google Cloud Platform storage:
Actian Zen
Delimited files
You need to edit only a few macro values (bucket/Avalanche credentials, object name, table name, and so on) before running the template and loading their data. These templates were designed to dynamically discover the schema (fields, field size, data types, and so on), perform field level mapping, and determine the target output mode (append, insert) without input or any manual intervention. The templates leverage VWLoad for high-performance.
For information to run this template, see the Using Actian Library Templates for Loading Data to Avalanche section in the Actian Avalanche documentation available at
Compresses or decompresses text or binary files.
Receives emails from IMAP or POP3 servers and send emails using SMTP.
EZScript Libraries
Reusable user-defined function that extracts a text string from any two text strings.
File Folder Queues
Gets all files with a matching file name pattern from a file server and moves them to a destination folder for processing.
Note:  The destination folder can be monitored as a File Listener for event driven integration.
File Listener
Gets data from the file that triggers a real-time integration and uses that data as an input to the integration.
File Splitting
Splits a large file into multiple smaller files that can be used as input to a parallel or distributed processing workflow.
Gets all files with a matching file name pattern from a secure FTP server and moves them to a destination folder for processing. This is similar to File Folder Queues.
Example of extensibility in calling a Java object to generate a unique ID.
Uses the Orchestration Invoker to dynamically call any integration already deployed to an Integration Manager instance.
SFDC Login Invoker
Uses the Salesforce Login Invoker to get a session token than can be used throughout the workflow and reduce API calls.
SHA-1 Encryption
Example of reusable user-defined functions from an EZScript Library module that hashes and encrypts string data.
Web Service API
Example of using the API Invoker to make a RESTful web service API call and pass the response data into a Transformation Map.