Pentaho

 View Only

 Pentaho Connectivity to Kerberized Sybase

ali rana's profile image
ali rana posted 04-17-2023 09:45

I am trying to setup connectivity to a sybase DB which is kerberized. i have tried the following solutions

1. updated spoon.bat file added the following 2 options at set OPT=
-Djava.security.krb5.conf=C:\PATH TO REALM info
-Djava.security.auth.login.config=C:\PTAH TO TGT CACHE

2. In transformation connection i have selected the Sybase and provided hotsname, database, port info.

3. In DB connection options i have provided
"AuthenticationMethod","kerberos"
"IGNORE_DONE_IN_PROC", "true"
"SERVICE_PRINCIPAL_NAME","sybase/HOSTNAME"
"REQUEST_KERBEROS_SESSION","true"

I am not able to establish a successful connection. I have tested my kerberos ticket cache by connecting using jdbc with a simple java application and i can establish a connection.