Announcing the Release of CData Virtuality 4.7: Role-based UI, Foreign Functions, and Trino Connector
The new CData Virtuality 4.7 release comes with exciting updates designed to improve data management, governance, and functionality. This release is a step forward in simplifying operations and enhancing your data infrastructure even further. Here’s a closer look at what CData Virtuality 4.7 offers.
Role-based UI (Developer Preview)
Effective data governance is crucial, and the new role-based user interface (UI) in CData Virtuality 4.7 helps you better govern your data by allowing granular user-based permissions. Four pre-defined user roles are now introduced.
Administrators can now assign users to pre-defined roles, which will adjust the user interface accordingly. Benefits of pre-defined user roles include:
- Precise control: Assign and manage user permissions more effectively, ensuring that users only have access to the parts of UI that they are permitted to see, and can operate in an interface customized to their permissions. For example, creating new connections.
- Improved governance: Strengthen your data governance by controlling visibility and functionality within the CData Virtuality environment.
|
Business User
|
SQL User
|
SQL Developer
|
Data Source Administrator
|
Access
|
Data Shop, download Excel, connect Tableau
|
Same as Business User + Code Editor (SELECT statements only)
|
Same as SQL User + Dashboard, Code Editor, Materialization, and Jobs
|
Same as SQL Developer + View/add/edit data sources, data warehouses, and sources tabs
|
Restrictions
|
No access to Dashboard, Data Warehouses, Sources, Jobs, Code Editor, Materialization tabs, or "Show data in the Editor" button
|
No CREATE/ALTER, Materialization, or Jobs
|
No data source creating, connecting or editing.
|
None
|
Foreign Functions (Developer Preview)
Datasource specific functions and user defined functions (UDFs) are essential for enhancing your data warehouse’s functionality. That’s why CData Virtuality added these capabilities in 4.7 through foreign functions. Foreign functions utilize the native capabilities or syntax of the underlying data source to perform tasks such as querying, transforming, or formatting data. They can also be custom functions created by the user to extend Virtuality’s capabilities, including pushdown support for these functions. CData Virtuality now provides the ability to import any function from your data sources, with full out-of-the-box support for MS SQL. Support for other data warehouses, such as Snowflake, is on the roadmap and will be available soon. Here is how it helps:
- Increased functionality: Utilize your data warehouse’s functionality directly within CData Virtuality, optimizing the handling of complex data operations, minimizing the need to switch between different tools, and benefiting from enhanced compatibility and code portability.
- Future-ready: Look forward to broader support across various data warehouses, making CData Virtuality a long-term asset for your data architecture.
Additional enhancements: Rebranding, documentation, and bug fixes
CData Virtuality 4.7 also includes several other updates:
- Product rebranding: The on-premises version is now fully rebranded to align with CData’s branding.
- Updated documentation: Documentation has been updated to meet CData’s standards.
- Bug fixes: Performance issues related to metadata and git integration have been addressed, ensuring a smoother and more reliable experience.
Introducing the Trino connector
One of the significant additions in CData Virtuality 4.7 is the Trino connector. With this feature, you can leverage Trino’s capabilities within CData Virtuality. It also lays the foundation for future enhancements, such as extended Hadoop MapReduce (HMS), support for Parquet files and simplified Hive Metastore management. Stay tuned!
Interested in CData Virtuality 4.7?
If you are an existing customer and interested in upgrading to CData Virtuality 4.7, please open a support ticket here.
If you are new to CData Virtuality, start a 30-day free trial to experience CData Virtuality for yourself, or schedule a demo with us today.