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

WinZip Widget

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.

PGP Widget

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.

WinSCP Widget

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.

PowerShell 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