Packages
This chapter describes Packages - a great way of combining different Actions together. Most of the actions are self-explanatory therefore only screenshots provided.
Example of data warehouse workflow
Supported list of actions
- Transformation (Advanced ETL Processor Only)
- Import
- SQL Data check
- SQL Script
- Package
- FTP Operation
- HTTP Download
- ZIP Operation
- Receive Email POP3
- Receive Email IMAP4
- Receive Office 365 Email
- Send Email
- External Application
- Check File
- File operation
- Compare Files
- Check Disk Space
- Backup Repository
- Clear Log
- Pause
- Check Date
- Report
- Export Data
- Show Message
- Ask Question
- Set Variable
- Script
- Check Connection
- Ping Server
- Case
- Gpg4win
- HTTP Form
- Soap
- SMS Messaging
- Twitter
- Loops
- Publishing Tableau Files
- Amazon S3 Action
- Azure Blob Action
- Cloud storage operations
- Change File Encoding
- Telegram messaging
- Check License Action
- Extract MIME Data
- Send RabbitMQ Message Action
- Receive RabbitMQ Message Action
- Send Apache Kafka Message Action
- Receive Apache Kafka Message Action
We are constantly working on improving our software if some of the functionality is missing please post your suggestions on our ETL Forum and we will be more than happy to add it.
Creating New Package
- To create a new Package select a Package group from the objects tree and click New
- Dialog box will appear
- Fill in the Description edit box with the name of the Package you are about to create
- Fill in a comment if required
- Click OK to finish the creation of the Package
Package Screen Overview
Every package must have a starting point (Action on the left of the picture). Action execution state defines which action is executed next. The Blue line is a success and the Orange Line is a failure.
Setting Starting Point
Joining Actions
Objects can be joined to other objects as shown here. This is achieved by simple “drag” and “drop” of the items from one to another. To remove the link repeat the process.
Catch All Actions
Catch-All Actions provide a way of reducing the complexity of a package
On Error
On Success
Package Tool bar
The package toolbar provides all the tools you need in order to create and manipulate objects. It is also possible to change how objects are viewed in the interface.
- Packages Properties
- Open Package from file
- Save Package to file
- Save to the Repository
- Print
- Print Preview
- Cut
- Copy
- Paste
- Delete selected Action(s)
- Clear all
- Undo
- Redo
- Search
- Align Left
- Arrange Vertically
- Align Right
- Align Bottom
- Arrange Horizontally
- Align Top
- Space Horizontally
- Space Vertically
- Snap to grid/show grid
- Manage Versions
- Add Version
- Revert to previous version
- Make Package Read Only
- Show/Hide execution log
- Open execution log directory
- Schedule Package for Execution
- View Execution Log (When executed by agent/scheduler)
- Debug package
- Continue execution
- Execute Package using agent/Integrated Scheduler
- Stop package execution
- Zoom In
- Zoom Out
- Zoom back to 100%
Automatic Version Control
Every time the user presses the save button package is automatically added to the version control
Video Tutorial: