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 […]
2021-09-15
559 reads
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
909 reads
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
2021-01-15
In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.
2020-12-23
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
2020-07-16
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
2019-04-23 (first published: 2019-03-26)
2,470 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers