Widgets for AppWorx
AscendoSoft offers Widgets for those common everyday AppWorx (formerly Applications Manager) tasks that can be difficult to automate or that you never quite find the time to focus on.
- It can be difficult to detect errors in scripts, which can cause delays in batch processing
- Scripts can be difficult to maintain and keep current
- Testing is difficult since environments often have different job definitions and hard-coded parameters
- installs quickly
- is fully object-oriented
- is fully parameterized to support all features
- supports full error-checking
File Actions Widget
The File Actions Widget plugs into Applications Manager to automate common file & directory actions. Two scenarios have become common. Either a site implements the File Actions widget to avoid scripting their file copies, moves, etc., or they implement the File Actions widget to eliminate existing scripts (a consolidation strategy). Existing scripts often have no error checking, no logging, and/or don’t accept parameters – the widget supports all these. And, the widget makes taking actions on files so easy that more manipulation of files is added to existing automation.
The job automates the following:
- Move files
- Copy files
- Xcopy files
- Rename files
- Delete files
- Create directories
- Remove directories
The WinZip widget automates compression/decompression of WinZip files. This is often a critical step in file transfer activities. Frequently used in conjunction with the WinSCP and File Actions widgets. Zipping and unzipping files prior to upload or after download are common requirements at several institutions. Zipping files prior to archiving (to save space) is another common activity.
The PGP Widget automates file encryption/decryption – another process that is often critical to the file transfer process. Used primarily with the WinSCP widget for encrypting and decrypting files for upload or download. PGP encryption is becoming more prevalent as both institutions and/or third-party vendors decide to require it. PGP encryption ensures security of data in motion and ensures only the intended recipient can decrypt their file.
SQL Server Widget
The SQL Server Widget allows Application Manager to run scripts against SQL Server Databases. This is critical in processes such as automating data warehouse loads and integrating CCM with Fiserv DNA. It executes Transact-SQL jobs. The ability to run Transact SQL scripts against SQL server databases is being used by several institutions to automate CCM jobs. The CCM jobs are coordinated with other DNA processing. One institution has automated a management KPI data warehouse refresh that extracts data from DNA, loads the data into SQL Server, then manipulates the data within SQL Server to update the data warehouse. The entire process runs frequently throughout the day to ensure management never sees data more than one hour old.
The WinSCP widget automates secure file transfer between a local and a remote computer. For secure transfers, WinSCP uses Secure Shell and supports the SCP protocol in addition to SFTP. With consolidation and modernization driving adoption of the WinSCP File Transfer widget. Some sites were using a number of file transfer mechanisms or applications, e.g. manual processes, scripts, multiple applications (like WS_FTP, CoreFTP, FileZilla, WinSCP), or the AppWorx job SFTP_JAVA. Consolidating on the widget makes all transfers consistent and makes training and troubleshooting easier. WinSCP supports all transfer protocols, including S3. Eliminating scripted transfers avoids the security risk of hardcoded passwords in scripts. Finally, the now obsolete AppWorx SFTP_JAVA job is easily replaced with the simpler to manage WinSCP widget.
The PowerShell widget automates PowerShell scripts in AppWorx. The PowerShell widget allows you to run your own PowerShell scripts from AppWorx. Custom PowerShell scripts can perform a wide variety of actions both large and small. Customers have automated scripts that perform fairly traditional tasks, like querying data and generating reports or manipulating the contents of files. Other customers have indicated their scripts will take advantage of PowerShell features for administration of Windows tasks.
- Support for named and positional parameters, and PowerShell switches, as prompts in AppWorx
- Elevate to Administrator as necessary
- Full error checking and logging
- Support for separate report file in addition to other logs
- Use AppWorx Login objects to supply credentials to scripts