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

  • 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
  • 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
  • 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.

  • 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

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

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 provide a way of reducing the complexity of a package

On Error

On Success

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.

  1. Packages Properties
  2. Open Package from file
  3. Save Package to file
  4. Save to the Repository
  5. Print
  6. Print Preview
  7. Cut
  8. Copy
  9. Paste
  10. Delete selected Action(s)
  11. Clear all
  12. Undo
  13. Redo
  14. Search
  15. Align Left
  16. Arrange Vertically
  17. Align Right
  18. Align Bottom
  19. Arrange Horizontally
  20. Align Top
  21. Space Horizontally
  22. Space Vertically
  23. Snap to grid/show grid
  24. Manage Versions
  25. Add Version
  26. Revert to previous version
  27. Make Package Read Only
  28. Show/Hide execution log
  29. Open execution log directory
  30. Schedule Package for Execution
  31. View Execution Log (When executed by agent/scheduler)
  32. Debug package
  33. Continue execution
  34. Execute Package using agent/Integrated Scheduler
  35. Zoom In
  36. Zoom Out
  37. Zoom back to 100%

Automatic Version Control

Every time the user presses save button package is automatically added to the version control

Video Tutorial

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetle/packages/start.txt
  • Last modified: 14/04/2019 14:36
  • by admin