July 2022 Summaries

Cloud and data virtualization are increasingly popular among organizations due to affordable cloud computing, remote workforces, and digital transformation. Data virtualization is a specific type of virtualization that integrates disparate data sources into a single platform without moving the data, facilitating real-time access and improving decision-making. Virtualization has various types, including server, storage, network, desktop, and application virtualization, each offering benefits such as higher capacity utilization, cost reduction, flexibility, scalability, and improved resource allocation. Emerging trends in cloud virtualization include shifting focus to security, expediting cloud migration, achieving a balance between flexibility and control, implementing intelligent infrastructure management through AI, increasing access to data, improving security, and responding to customer needs. The future of virtualization is expected to be shaped by advancements in AI integration, edge computing, hybrid cloud solutions, and no-code/low-code platforms, but also poses challenges such as security concerns, resource management, and skill gaps that require strategic planning. CData offers various solutions for data virtualization catering to different needs, including embedded virtualization, cloud-based virtualization, and comprehensive virtualization for the entire organization.

Introducing New dbt Core Integration and Real-Time CDC Sources for CData Sync The CData team is dedicated to providing flexible, easy-to-use, and robust data pipeline technology to support customers' data integration needs as enterprises leverage Sync to move their data from over 250 sources. The new features allow users to work collaboratively within the extended data ecosystem for demanding use cases. dbt Core provides new solutions for transformation adding to Sync's native transformation capabilities. It addresses some of the drawbacks in large organizations where data wrangling is typically the domain of scarce data engineers. The tool offers a workflow environment where analysts write business logic in SQL, transforms are tested, code is executed, and documentation is created. This latest CData Sync release also adds support for real-time Change Data Capture (CDC) for Oracle and MySQL in addition to SQL Server and PostgreSQL. CDC allows users to replicate data in real-time by automatically tracking updates in source data as they occur. A new History Mode for replication jobs with CData Sync appends a timestamped entry of every change that occurs in the source, allowing users to audit a source for any creates, updates, or deletes without having to modify existing applications. Available on-premises or in the cloud via AWS or Azure, CData Sync makes it simple to replicate and transform all the data needed.

App integration vs. data integration: Choosing the right tool for your organization's needs requires considering how you want to treat your data and what outcome you're expecting. Application integration is like taking a taxi, transporting smaller loads of data on-demand, while data integration acts as an airplane, uniting many sources and destinations through fixed hub locations. Both approaches have advantages and disadvantages, with application integration streamlining business processes, improving real-time data access, and offering scalability and flexibility, but requiring more configuration effort. Data integration consolidates information from disparate sources into a unified view, providing comprehensive insights for informed decision-making and increased operational efficiency. The choice between application integration and data integration depends on the specific use case, including network and computing bandwidth, infrastructure upkeep costs, data age, and data compatibility. Ultimately, selecting an integration method requires considering your organization's unique needs and goals.

CData is expanding its Connect Cloud connectivity solutions to include AWS Glue, adding hundreds of new data sources and destinations to existing workflows. This expansion aims to simplify data integration for organizations using AWS Glue, providing a faster path towards flexible pipelines with complete data. CData Connect Cloud's no-code tools empower users to connect various sources and destinations to AWS Glue without installation or specialized development required. The service offers real-time connectors for extracting data from any application, system, or platform, enabling informed business decisions through concrete insights. By breaking down cloud data silos, teams can make better decisions by leveraging complete data in reports, streamlining operations, and communicating more effectively. With the partnership, AWS Glue users can leverage even more applications to power analytics, automation, and data initiatives, eliminating custom development and maintenance cycles for integrating disparate data sources with AWS Glue.