🚀 New Features and Enhancements​

Core​

• Introduction of the term "Virtual Dataset" to summarize Functions, Models, Code-Files and Value Lists. In the Modeler the input table is now referred to as physical dataset.
• Improving stability of the Agent (Breaking Change): Some changes within the Agent were made to improve the stability with respect to restarts, reconnections and general communication.
• Preparatory changes for introducing new data types (Breaking Change): In case a constant date is used in a formula, e.g. for filtering, this will not work anymore and has to be rebuild.

Modeler​

• Introducing the simple syntax in beta version to be able to copy parameter configurations into the text editor.

🐛 Solved Issues​

Modeler​

• Problems with nested operations solved
• Transformation:
  • Utilizing auto-correct for column renaming along with the selection or removal of columns has been rectified.
  • Changing the description of a node and the title is now working correctly.
• Union: Problems causing errors while changing column order are solved.
• Using the control key "del" (German: "entf") while renaming, e.g. columns in an editor, does delete the text but not the node itself anymore.

🚧 Known Issues​

Docs​

• The term "Virtual Dataset" is not used consistently within the documentation. This will be corrected in on of the next releases.

Modeler​

• Concurrent save issue when launching a Model with multiple Parameters or adjusting multiple Parameters in parallel.
• Parameter of type date is visible but not enabled yet.
• Union of identical nodes might result in 'Duplicate Key' error message.
• New: Meta data preview potentially not loading for large models. It ends with an infinite load and the error message "cancelled by user".
• New: Using Models as Platform Request within other Models, in particular in case of nested Models, might cause errors.

ODBC Handler​

• Columns of type TIME cannot be processed.

🙌 How to Upgrade​

The stabilization of the Agent requires a new one. Please remove all old Agents and install new ones via the Portal. All other components are upgraded automatically, and no action from the user side is necessary.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.

🚀 New Features and Enhancements​

Portal and Core Platform​

• Workspaces (breaking change): The Workspace Public is renamed to MyCompany, to make clear that all functions are only available in the company specific tenant and not available in other tenants. This change is breaking for all Platform Requests executed via the Universal Connector (beta). Here Users have to adjust the connection configuration in the respective client tool to use the database MyCompany instead of Public.

🚧 Known Issues​

Modeler​

• Concurrent save issue when launching a Model with multiple Parameters or adjusting multiple Parameters in parallel.
• Parameter of type date is visible but not enabled yet.
• Union of identical nodes might result in 'Duplicate Key' error message.

ODBC Handler​

• Column type time cannot be processed.

🙌 How to Upgrade​

All components are upgraded automatically. No action from the user side is necessary.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.

🚀 New Features and Enhancements​

Portal​

• Menu Location & Agents: A new column has been added to display the status of Agents. This status can also be shown in other linked components, such as the System Line, and consequently, in associated Functions.

🐛 Solved Issues​

Modeler​

• UI: Consistent naming of Data Operator selections and default node names.
• Formula:
  • DecimalConstant fixed.
  • Invalid Formulas can now be corrected without ending in an infinite load.

Excel Client​

• The current data filtering based on ranges (e.g. a parameter entered via VDP.RANGE()) is now working correctly; it accurately filters the lower as well as the upper bound.

🚧 Known Issues​

Modeler​

• Concurrent save issue when launching a Model with multiple Parameters or adjusting multiple Parameters in parallel.
• Parameter of type date is visible but not enabled yet.
• Union of identical nodes might result in 'Duplicate Key' error message.

ODBC Handler​

• Column type time cannot be processed.

🙌 How to Upgrade​

All components are upgraded automatically. No action from the user side is necessary.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.

🚀 New Features and Enhancements​

Agent​

• Shortened start times for Agents: The time it takes for the Agents to begin working has been reduced.
• Fewer updates for Agents (breaking change): Agents will now require fewer manual updates, thanks to the increased ability to automatically download and update more components, such as Query Handlers. This not only streamlines the update process but also minimizes the footprint on the Agent's hard drive, as Query Handlers now reside solely in the Agent's RAM (temporary memory).

Modeler​

• Formula: LOWERCASE() and UPPERCASE() added.
• Aggregation (breaking change): Refactored the handling of column names in the transformation logic. Therefore, if any data operators are used after an aggregation, these operations would fail and require modification.

Portal​

• Introducing smart caching: Performance improvemnts, the user interface is now much smoother and faster.
• System Line: For Systems of kind "SAP" it is now possible to override the default ports.

🐛 Solved Issues​

Platform Core:​

• All clients: In addition to the breaking change in release v202312-02 some fixes were implemented in regard to string encapsulation (single quotes instead of double quotes).

Modeler​

• Transformation: Issues with special cases of using Transformation (e.g. Reorder, Select or Rename) in combination with other Data Operators like union or join fixed.
• Model Parameter: Data type boolean added.

🚧 Known Issues​

Modeler​

• Concurrent save issue when launching a Model with multiple Parameters or adjusting multiple Parameters in parallel.
• Parameter of type date is visible but not enabled yet.
• Union of identical nodes might result in 'Duplicate Key' error message.

ODBC Handler​

• Column type time cannot be processed.

Excel Client​

• The current data filtering based on ranges is not working correctly; it accurately filters only the lower bound, while the upper bound is not being handled properly.

🙌 How to Upgrade​

Due to the Agent refactoring, new agents must be installed. Please remove all old Agents and install new ones via the Portal. This breaking change was introduced to minimize the need of Agent restarts in the future.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.

🚀 New Features and Enhancements​

Modeler​

• Union: Improved usability of the drag and drop functionality.
• Formula syntax refactoring (breaking change): Single quote (') is replacing double quotes (") to encapsulate text. This change breaks existing formulas using double quotes (").
• Transformation: Additional date patterns for date conversion are added.

🐛 Solved Issues​

Modeler​

• Parameters:
  • Problem when Model was saved while a new Modeler Parameter was created in Admin Portal is solved.
  • Referencing Parameters of cardinality List with Parameter values being empty or null is now possible.
  • The date format mismatch when referencing Model Parameter of type DateTime is fixed.
• Transformation:
  • Renaming columns in combination with other transformation steps in the same Transformation Node is fixed.
  • Reordering multiple columns using one transformation step is now possible.
• Platform Requests: Date picker in Platform Request editor working.
• Formula: LENGTH() is fixed.

🚧 Known Issues​

Modeler​

• Problems with parameter data type boolean.
• Concurrent save issue when launching a Model with multiple Parameters or adjusting multiple Parameters in parallel.
• Parameter of type date is visible but not enabled yet.

ODBC Handler​

• Column type time cannot be processed.

Agent​

• After release, there might be mismatches between the Platform Handler versions and the Agent Handler versions.

🙌 How to Upgrade​

All components are upgraded automatically and no action from the user side is necessary. Requests throwing error messages (e.g. in case of an SQL Procedure: The given key 'ODBC_Procedure_1.0.253' was not present in the dictionary) indicate a mismatch of Handler versions. This can be solved by a simple restart of the agent.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.

🚀 New Features and Enhancements​

Platform Core​

• OData Connections: Users can now connect to sources supporting OData, such as Microsoft Dynamics 365 or Azure DevOps, by using a System of kind "Web" and the new OData Handler. The new OData Handler also supports Parameters to filter the respective queries.
• Parameters for SharePoint List Connections: With the new SharePoint List Handler, users can create parameters to filter their respective queries. Some limitations apply to special SharePoint List column types like Person or Group, Multiple Choice, Multiple Lines of Text and Lookup.
• New Executable Value List (beta): Introducing a new VDP object - Value Lists. They allow to limit Parameter inputs to specific predefined values. These Value Lists can also be created dynamically based on Platform Requests.
• Cancellation: The backend is now equipped to stop already started requests, though not enabled in all clients yet.

Universal Connector (beta)​

• First official release of the Universal Connector, allowing users to connect to Virtual Data Platform using SQL Server connectors in the respective client tools. Please note that this is a beta version and that not all client tools support the Universal Connector yet.
• Please find a short description to get started.

Modeler​

• Adjustments to Filter node: The UI for the Filter node has undergone a complete overhaul. Consequently, adjustments are required for all existing Filter nodes.
• Model Parameters in Platform Requests and Filter nodes: All types of model parameters can now be referenced in Platform Requests and Filter nodes.
• Use Esc on your keyboard to cancel refreshes in the Modeler (referring to new feature Cancellation).

🐛 Solved Issues​

Agent Deadlocks​

• Agent performance and deadlocks: Queries are now limited to 10min runtime. Thus, deadlocks can be prevented.
• Improved logging in the agent while executing requests.

🚧 Known Issues​

Modeler​

• Platform Requests: Date picker in Platform Request editor not working.
• Model Parameter:
  • Missing Model Parameter data type Boolean.
  • Issues when Model Parameter values are empty or null.
  • Date format mismatch when referencing model parameter of type Date & Time.
• Formula: method LENGTH() not working.
• Transformation: Problems with multiple transformation steps including rename.

ODBC Handler​

• Column type time cannot be processed.

🙌 How to Upgrade​

The bug fixes in the agent require a new agent. Please update the currently running agents according to the provided descriptions. All other components are upgraded automatically, and no action from the user side is necessary.

🗣️ Feedback​

If you have questions, want to share feedback or have any new ideas please do not hesitate to contact us via contact@virtualdataplatform.com.