Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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