Announcing the Release of CData Virtuality 4.7: Role-based UI, UDF, and Trino Connector
![https://www.cdata.com/blog/announcing-cdata-virtuality-4-7](https://files.cdata.com/media/media/ohwfj0h2/cdata-virtuality-47-blog.png)
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
|
Sames 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
|
UDF improvement (Developer Preview)
User Defined Functions (UDFs) are essential for extending your data warehouse’s functionality. CData Virtuality 4.7 improves UDF support for MS SQL, with plans to include other warehouses like Snowflake in the near future. Here’s how it helps:
- Increased functionality: Utilize your data warehouse’s functionality directly within CData Virtuality, minimizing the need to switch between different tools.
- 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.