Tag: SQL Server

SQL Server
January 31, 2024

ETL Tools for SQL Server: Which Ones Are the Most Popular Nowadays?

by Bill Balint

Migrate & transform your data seamlessly by discovering the most widely used ETL tools for SQL Server and boost your data integration & analysis efforts.

Read more

SQL server replication
December 27, 2023

SQL Server Replication: Overview & Step-by-Step Configuration

by Bill Balint

Explore seamless data synchronization with our guide on SQL Server Replication. Master configuration in easy steps for optimal database performance.

Read more

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