B2Win Suite 5.4 Released

Key Features

More SQL-Scripting (low-code) capabilities added to VisualQuery

We've integrated more scripting capabilities into VisualQuery's intuitive point-and-click interface, benefiting business users and SQL programmers. This enhancement empowers them to collaborate effortlessly within a unified environment to address the company's business needs.

New "Views" feature, based on SQL scripting

Users can now construct more robust SQL models through "Views" and create tables that represent a subset of the database derived from queries that operate on one or more database tables. This new feature empowers users to create "Views" or custom tables that represent a subset of the database derived from queries that operate on one or more are derived for using custom SQL scripting and incorporate them as custom tables. These custom tables can then be effectively joined with other tables, allowing users to develop advanced SQL models tailored to their needs.

More SQL Scripting in "Conditions" and "Virtual Fields"

Users can now use free SQL scripts in Conditions alongside the existing point-and-click user interface.

We have added the capability to use free SQL Script with Virtual Fields for greater flexibility and robustness. The user can now choose the type of formula that better fits their project.

Support for Plugins

Services and nodes are now independently managed, simplifying integration and administration. Admins can now easily add or remove services/nodes without server restarts, ensuring continuous availability and system uptime for all users.

Full support for "B2Win Suite Client" has been added to B2Data

This powerful capability that already exists in B2Output is now available in B2Data. For example, users can configure workflow to connect to their local machine and use their personal MS Outlook to send emails for even more personal ways to interact with customers, schedule a print job for a weekly report right next to them on a printer connected to their local machine… possibilities are endless.

Joiner Node - New Update

Support for joining multiple tables has been added.

What's New and Improved

New Nodes

NEWFile Copy (B2WS Client) – Empower users to transfer files to their local machines effortlessly. Admins gain the capability to distribute files to other users' local systems with ease.

NEWPrint (B2WS Client) – Streamline the printing process for users by enabling direct printing of reports and files, including MS Excel and PDF documents, to printers connected to their local machines.

NEWSend Email (B2WS Client) – Enhance email communication efficiency with the ability to send emails using the locally installed email client. Users can bypass the server's SMTP and leverage their local machine's email capabilities.

NEWQueryTrigger – Activate queries triggered by data changes, empowering users with real-time responsiveness to dynamic data environments.

NEWScriptTrigger – Trigger workflow based on the value evaluated from your script.

NEWColumns Renamer – This node provides a quick way to rename field codes and descriptions for nodes with Data Frame output. It is handy for tasks like matching and synchronizing tables with target databases.

NEWPowerBI Uploader – Easily upload datasets to PowerBI.

NEWQlik Uploader – Easily upload datasets to Qlik Sense.

NEWCustom Script (File) – This node allows you to write custom scripts with "file" output.

NEWCustom Script (Object) – Enhance your workflow with the capability to write custom scripts with "Object" output, including formats like XML or JSON.

NEWFile Read (Windows Share) – Access and read files from a Windows Share or Samba network.

NEWFile Copy (Windows Share) – Copy files to a Windows Share or Samba network.

NEWFile Listener (Windows Share) – Listen to files on a Windows Share or Samba network.

More Changes

IMPROVEDDelete synced data for db connection

NEWSupport properties in excel templates for excel merger

IMPROVEDAbility for zoom to for input form fields with multiple selection

NEWHaving list of fixed values for input form fields

NEWDisk usage for workflows

IMPROVEDBug fixes, usability and performance improvements

B2Output