ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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