Learn more
 
Blog
 

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
Data ManagementCData SyncSQL ServerETLData Pipelines
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 ManagementSQL Server
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
Solutions & Use CasesCData DriversCData ConnectData Virtualization for the CloudData VirtualizationLinked ServerSQL ServerODBCODBC Driver
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
Solutions & Use CasesCData SyncETL/ELTData PipelinesSQL ServerData ReplicationSalesforce
Replace the Deprecated Microsoft Data Export Service with CData
February 9, 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
Solutions & Use CasesCData SyncReal-time ConnectivityData integrationSQL ServerDynamics 365Dynamics CRMSSIS
SQL Server
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
Solutions & Use CasesSQL ServerPolybaseLinked ServersData VirtualizationCData ConnectProducts