Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Connecting to Big SQL - BigInsights V3.0

nshah
5 - Atom

Does anyone has experience connecting to IBM Big Insight. I tried using IBM DB2 Driver but getting error message while try to connect to within Input Data. I have configured ODBC driver using IBM DB2 ODBC driver version 10.5.x. Able to test within ODBC Admin tool successfully. But when I try to connect from Alteryx, I am getting error message.

 

Error on the alteryx screen is 

nshah_0-1618936161035.png

 

On Big SQL side DBA is seeing following error message...

 

"SYSIBM.SYSDATABASE" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.19.56
 
Script: Script1.sql
Database Name: BIGSQL
Authorization Id (Database): XXXX
System/IP Address : XXXXX
User Id (System) : XXXX
 
XXXX - masked to hide infor

 

1 REPLY 1
TrevorS
Alteryx Alumni (Retired)

Hello @nshah 
That appears to be an IBM error message.
I was able to find this IBM help page that should help you troubleshoot this issue!
https://www.ibm.com/docs/en/baw/19.x?topic=tic-db2-log-file-error-sql1092n-userid-does-not-have-auth...

Thanks!
TrevorS

Community Moderator
Labels
Top Solution Authors