CData Software provides data integration and connectivity solutions that enable access to data from a wide range of on-premises and cloud-based applications. Designed to support diverse deployment environments—including on-premises, cloud, and hybrid—CData solutions simplify how users connect, integrate, and work with data. By facilitating easy and secure data access across systems, CData helps organizations accelerate decision-making, improve process efficiency, and advance data-driven initiatives.
Do You Manage Peer Insights at CData?
Access Vendor Portal to update and manage your profile.
It is a robust data federation tool that offers a seamless unified layer to access and process data from a multiple data sources all in a single interface. Its user-friendly environment enables users to easily query databases from various vendors, APIs, and flat files all using SQL. This significantly improves your data integration and processing tasks in terms of performance and maintainability. In addition, the functionalities to have a complete automated data processing pipeline is very impressive. Users can intuitively create and schedule jobs that can access tables, views, and stored procedures from numerous data sources and perform complex processing tasks periodically with minimal effort. Query optimizer tool is also very effective in enhancing performance that makes retrieval and processing more efficient.
The studio tool enables very efficient data exploration and agile development. The scheduler is straightforward without limitations and its GUI makes it easy to analyze performance and schedule appropriately.
Easy to use, easy to learn
Python Coding feature is an exciting addition to their toolbox that can improve your experience considerably. However, the lack of access to some of the most widely used external Python libraries such as Pandas and Numpy is a bit limiting to perform more complex data processing tasks. Having access to those libraries will reduce the need to transfer data between multiple development environments, which will enhance both the experience and performance. In addition, although most of the existing utility functions in DV are very practical, there are a few areas where revisions could be considered mainly for performance reasons. For example, upserting data into tables takes longer using the related utility function in comparison to what you would experience by executing standard SQL commands in Postgres. Although it is not a major issue for smaller datasets, for relatively larger datasets or more complex tasks, it should not be neglected.
Hoping to see improvements to the Studio UI such as viewing an existing schedule in a more easily readable way, and the ability to edit a schedule, rather than deleting it and recreating.
Web Interface Handling should be improved on some sides (e.g. sorting of lists should be possible)