Connecting IBM Data Stage with SEP

Starburst Enterprise
1

Is it possible to connect IBM Data Stage with JDBC URL. We tried but getting this error even though the credentials are correct.

java.sql.SQLException: Authentication failed: Access Denied: Invalid credentials
at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:284)
at io.trino.jdbc.TrinoStatement.execute(TrinoStatement.java:238)
at com.ibm.is.cc.jdbc.CC_JDBCRecordDataSetProducer.setupOperation(CC_JDBCRecordDataSetProducer.java:791)
at com.ibm.is.cc.jdbc.CC_JDBCAdapter.preRun(CC_JDBCAdapter.java:666)
Caused by: io.trino.jdbc.$internal.client.ClientException: Authentication failed: Access Denied: Invalid credentials
at io.trino.jdbc.$internal.client.StatementClientV1.requestFailedException(StatementClientV1.java:448)
at io.trino.jdbc.$internal.client.StatementClientV1.(StatementClientV1.java:122)
at io.trino.jdbc.$internal.client.StatementClientFactory.newStatementClient(StatementClientFactory.java:28)
at io.trino.jdbc.TrinoConnection.startQuery(TrinoConnection.java:756)
at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:252)
ā€¦ 3 more

The connector could not obtain the data source metadata information. The reported error is: java.sql.SQLException: Authentication failed: Access Denied: Invalid credentials.

2

Never tried this with IBM DS, but if just a generic JDBC connector then this error reads like it reads (bad creds). Iā€™m sure you have configured it correctly as detailed in Starburst Generic JDBC connector ā€” Starburst Enterprise.

Have you been able to update the configuration to hit another datasource with different configuration? Wondering if it is a universal problem with the connector version/instance you have before running this to ground as either a IBM DS <> SEP issue (or simply a true creds issue).

3

Hi Lester, The issue got resolved. We were using lower version of the trino-jdbc driver. Once we updated the driver to the correct version the issue got resolved. Thanks for the points.

Regards

1 Like