topic Re: SAS Data Quality and Azure in Microsoft Integration with SAS

SAS Data Quality and Azure

SASUser1001 — Wed, 29 May 2019 07:37:37 GMT

We are working on a specific business case and we need SAS Data Quality to connect to Azure Data Lake Store and/or Azure SQL Datawarehouse to retrieve data and perform all data cleansing activities.Please let me know if those software tools/platforms can work together and if this functionality is supported with the latest version of SAS Data Quality Advanced.

Re: SAS Data Quality and Azure

Patrick — Wed, 29 May 2019 08:39:45 GMT

Google search terms used: Dataflux Azure

First hit returned: http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_SupportedDB.html

Does that answer your question?

Re: SAS Data Quality and Azure

SASUser1001 — Wed, 29 May 2019 08:59:22 GMT

So, this means that it is not supported. We need to make an important decision, therefore if you are not 100% sure, let's wait for someone else to response.

To sum up, we need a connector for the below data systems:

• Azure Data Lake Store Gen2 and/or
• Azure SQL Data Warehouse

https://stackify.com/azure-sql-database-vs-warehouse/

Re: SAS Data Quality and Azure

Patrick — Wed, 29 May 2019 09:31:14 GMT

@SASUser1001

I thought below answers your question.

But given the importance you probably want an official SAS answer which you can get by:

- Internet search until you find the piece of official documentation which you consider detailed enough to feel comfortable with

- Contact SAS TechSupport (be clear about the importance and commercial impact of the answer)

- Directly contact your local SAS office and get in touch with the responsible SAS account manager

- Be lucky and have someone like @JBailey answer here

Re: SAS Data Quality and Azure

SASUser1001 — Wed, 29 May 2019 09:23:50 GMT

Thanks for your response. Unfortunately, no.
refer to the below link
https://stackify.com/azure-sql-database-vs-warehouse/

Re: SAS Data Quality and Azure

Patrick — Wed, 29 May 2019 09:44:31 GMT

@SASUser1001

I've looked into this link.

Only because these SQL Servers are in the cloud doesn't mean they aren't ODBC compliant anymore. I've just done some "random" Googling and found quite a bit of instructions how to connect to SQL Server in Azure via ODBC.

But yes, if the answer is that important for you then get it from SAS for exactly your environment and versions of SAS/DF and Azure/SQL Server.

Re: SAS Data Quality and Azure

JBailey — Fri, 19 Jul 2019 14:13:15 GMT

Hi @SASUser1001,

Azure SQL Database and Azure SQL Data Warehouse are two distinct databases. For example, SAS/ACCESS Interface to Microsoft SQL Server supports Azure SQL Database, but not Azure SQL Data Warehouse. You are probably asking, why? The Data Direct ODBC driver for Microsoft SQL Server that ships with our product does not support Azure Data Warehouse; it will eventually. Once the DD driver supports support Azure SQL Data Warehouse, we plan to look into adding support in SAS/ACCESS to Microsoft SQL Server.

Fortunately, Microsoft provides a free ODBC driver that can be used with SAS/ACCESS Interface to ODBC to support both Azure databases.

Here is the Azure SQL Data Warehouse doc.

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-connect-overview

There is a link in the above doc that will take you to the following ODBC driver download page.

https://docs.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows?view=sql-server-2017

Here is the money quote, "The ODBC Driver for SQL Server supports connections to Azure SQL Database, Azure SQL Data Warehouse, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005."

Hopefully, this will help you.

Best wishes,

Jeff

PS: @Patrick, you are way too kind, but thank you for the nice call-out.

Re: SAS Data Quality and Azure

JBailey — Thu, 30 May 2019 18:24:23 GMT

Thanks, @Patrick! You have made my day!

Re: SAS Data Quality and Azure

ccaulkins9 — Fri, 31 May 2019 17:15:16 GMT

@Patrick, something tells me that @SASUser1001 won't be trolling for Azure information here for a little while longer -

Re: SAS Data Quality and Azure

ccaulkins9 — Fri, 31 May 2019 17:17:42 GMT

@JBailey, did you suddenly get extra weight added to your like?

Re: SAS Data Quality and Azure

JBailey — Fri, 31 May 2019 18:07:51 GMT

Hi @ccaulkins9

Why, YES! I think I did;)

Thank you!

Best wishes,
Jeff