Tag: SQL

Data virtualization SQL Server
November 20, 2023

Unlocking Data Potential: Virtualization in Diverse Database Environments

by Dibyendu Datta

Learn how to access data with linked servers in SQL Server, MySQL Remoting, and TDS (tabular data stream) foreign data wrapper for PostgreSQL using data virtualization for the cloud.

read more

Data JOINS blog image
November 15, 2023

Using Transformations to JOIN Data After Replications (in SQL Server)

by Dibyendu Datta

See how to use CData Sync to replicate multiple tables from a data source into SQL Server, then transform those datasets with the JOIN clause – a technique extensively employed across various industries to analyze data.

read more

February 09, 2023

Replace the Deprecated Microsoft Data Export Service with CData

by Dibyendu Datta

We'll show you how to use CData’s connectivity solutions to efficiently replace the deprecated DES and easily facilitate data replication from Dynamics 365.

read more

November 29, 2021

Extend SQL Server with Real-Time Cloud Data Connectivity

by Jerod Johnson

SQL Server has long been the data hub of choice for IT teams. In fact, a recent survey of 10,000 customers conducted by CData found 75% of organizations rely on SQL Server as their operational database to run their businesses. According to a recent study conducted by Deloitte, 68 percent ...

read more

September 10, 2021

Join CData for Data Platform Virtual Summit 2021

by Jerod Johnson

CData is proud to sponsor the Data Platform Geeks Virtual Summit 2021 . Join us for one of the largest events on data, analytics, and AI with exclusive training on SQL Server, Power BI, Synapse, Azure Data Stack, Azure Data Factory, DAX, machine learning, artificial intelligence, and more...

read more

July 23, 2021

Support DataOps Agility with Data APIs

by Eric Madariaga

Data fragmentation has become a major roadblock for many enterprises on their journey to digital transformation. Gaining business insights from data is more crucial than ever, but as cloud-based infrastructure that data has become more decentralized and difficult to manage. Data virtualiz...

read more

June 09, 2021

APIs vs. SQL-Based Connectivity

by Alex Pauncz

When you need to provide your customers with access to data stored in your application or platform, the easiest place to start is with traditional application programming interfaces, or APIs. An API serves as an intermediary that allows two or more applications to interact with one anothe...

read more

May 12, 2021

Solve Salesforce and SQL Server Data Challenges with DBAmp

by Bill Emerson

Salesforce provides teams and companies a powerful cloud hub to understand their customers and coordinate customer interactions across sales, marketing, and support teams. For Salesforce to serve as an end-to-end customer ecosystem, organizations must connect Salesforce to the data they u...

read more

June 16, 2020

High Performance Drivers for Relational Databases

by Jerod Johnson

At CData, we are most commonly known for technologies that enable SQL access to SaaS, cloud, and other non-relational data sources. With application and data storage becoming increasingly distributed, solving the diverse connectivity needs of modern BI, ETL, and data integration has been ...

read more