Issue 45457: Support for JDBC or ODBC Connection to Informatica IICS

issues
Status:open
Assigned To:steveh
Type:Defect
Area:ODBC
Priority:3
Milestone:22.07
Opened:2022-05-06 15:14 by steveh
Changed:2022-05-12 09:57 by hannahb
Resolved:
Resolution:
Related:45117
Support Ticket:45117
Pull Requests:
Closed:
2022-05-06 15:14 steveh
Title»Support for JDBC or ODBC Connection to Informatica IICS
Assigned To»triage
Type»Defect
Area»ODBC
Priority»3
Milestone»22.07
Support Ticket»45117
Client would like to use Informatica IICS to query LabKey over JDBC or ODBC.
They attempted both JDBC and ODBC connections, but could not make them work.

2022-05-06 17:07 adam
Related»45117
As you probably know, a different client was successful connecting Informatica EDC to LabKey using our JDBC driver. That doesn't guarantee it will work with IICS (whatever that is), but JDBC is the place to start. I see their JDBC error shows LabKey's standard UnauthorizedException message. This would indicate that IICS connected to LabKey successfully but LabKey rejected the request as unauthorized. Perhaps the configured user hasn't been granted permission in the folder that IICS is attempting to read. (There's not enough information in the screen shot to determine what folder is configured... is it attempting to read from the root?)

2022-05-12 09:57 hannahb
Assigned Totriage»steveh
Steve, sounds like there's more troubleshooting to do here before we decide to address this, assigning back to you