Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer 

The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced […]

5 (1)


254 reads

Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes increase in importance, organizations are looking for ways to simplify integration and manage workflows.  In this article, we'll walk you through how to design a data flow that adds new HubSpot contacts to a MailChimp list using CData SSIS Components for HubSpot and MailChimp.  Connecting to HubSpot and MailChimp  The […]

5 (1)

2021-09-03 (first published: )

471 reads


Daily Coping 17 Sep 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021


  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available


Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs


SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

update final code where not contain x then null if not contain x and another cod

By ahmed_elbarbary.2010

i work on SQL server 2012 I face issue i can't update table replacement...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers