Announcing CData Virtuality 4.8: Resource Governor, Time-Zone Based Job Management, and More Connectors

We are excited to announce the release of CData Virtuality 4.8, packed with a range of new features and updates. Let's delve into the highlights of this latest version.

Resource governor

One of the most notable additions to CData Virtuality 4.8 is the resource governor feature, which offers several enhancements to optimize and manage resource usage effectively:

• User limit for concurrent queries: Administrators can now set specific limits on the number of concurrent queries each user can run, ensuring a balanced and efficient use of system resources.
• Output limit: This feature restricts the size of data that can be retrieved from queries of given users, preventing excessively large data retrievals that could negatively impact performance. Imposing these limits also helps deter users from executing overly expensive queries, promoting more efficient use of resources.
• Duration limit: The resource governor allows you to define the maximum duration for which queries can run for certain users, further optimizing server performance and preventing prolonged resource consumption.

Time-zone based job management

With this new feature, CData Virtuality 4.8 now allows jobs to run according to both account-level and job-specific time zones. This enhancement makes it easier to schedule tasks and jobs for a global workforce, ensuring that time-sensitive operations align with regional business hours and reducing the complexity of job management across different time zones.

Additionally, this functionality provides automatic adjustments for daylight saving time (DST) on a per-account and per-job basis, effectively addressing a common pain point and ensuring that jobs are executed precisely when needed, regardless of seasonal time changes.

Foreign functions

Following the introduction of foreign functions (i.e. availability of database specific functions and UDFs from the data sources inside Virtuality and the pushdown capability for such functions) and the announcement of built-in support for MS SQL foreign functions in 4.7, CData Virtuality 4.8 now expands these foreign function capabilities to include a number of foreign source-specific functions for Snowflake. These functions are pushed down directly to the source database, making it more efficient to work with the data. With this addition, users can benefit from:

• Greater flexibility in handling complex data operations by using Snowflake functions within CData Virtuality.
• Optimized compatibility and portability when migrating code from Snowflake to Virtuality.
• Direct availability of user defined functions created in Snowflake in CData Virtuality, resulting in increased productivity.

New connectors

In CData Virtuality 4.8, we introduce another set of new connectors based on CData Drivers:

• Kafka, based on the CData JDBC Driver: Gain real-time data integration with Kafka streams, allowing you to work with streaming data directly within CData Virtuality.
• KsqlDB: While not a new connector, KsqlDB now benefits from a newly added UI wizard, making it easier to set up and manage this streaming SQL engine for Apache Kafka.
• Zoho CRM: Connect directly to Zoho CRM to leverage your customer data, enhancing your analytics and CRM workflows.
• SAP SuccessFactors: Integrate with SAP SuccessFactors to access and manage your HR data effortlessly, optimizing human resource operations.
• Active Directory: Streamline authentication and user management by connecting to Active Directory, ensuring secure access control and simplified administration.

Interested in CData Virtuality 4.8?

Explore the technical details of the new features in our documentation.

If you are an existing customer interested in upgrading to CData Virtuality 4.8, please open a support ticket here.

If you are new to CData Virtuality, start our Product Tour to learn more about CData Virtuality, or schedule a demo with us today.