Connecting to Big SQL - BigInsights V3.0

Question

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

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

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

TrevorS · Answer

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-authority-perform-requested-command-operation

Thanks!
TrevorS