Can you run data quality rules against Microsoft SQL DW?

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Can you run data quality rules against Microsoft SQL DW?

Post by vmcburney »

Does anyone know if Information Analyzer is supported for use against Microsoft Azure SQL Data Warehouse? I am getting an error when I try to run a simple DQ rule and its looks like IA is trying to use query cursors via the ODBC or JDBC connector which is not supported by the database:
pxbridge(0),0: ODBC Info: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.

pxbridge(0),0: Execution failed on statement select

pxbridge(0),0: ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 46,706: Msg = [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint. (CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1,531)
SQLDW does not support client-side or server-side cursors as it is designed for dimensional table querying that retrieves the full result set.
Post Reply