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
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers