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
- 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
We are constantly working on improving our software if some of the functionality is missing please 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 objects tree and click New
- Dialog box will appear
- Fill in 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
The package screen overview provides the user with the ability to create objects. The objects are numerous and can be combined with any number of other objects. For instance, you can combine an SQL script to output information to an email and vice versa, to store information from an email into a database. There is a great deal of flexibility in the system.
Every package must have a starting point (Action on the left on the picture).
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. It is a very simple 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
- Zoom In
- Zoom Out
- Zoom back to 100%
Automatic Version Control
Every time the user presses save button package is automatically added to the version control
Video Tutorial