Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Request help to connect to an oracle database with Kerberos

 

Hello I am currently working on a Talend data integration project and I use an oracle database that goes through kerberos with Skinit to connect. Indeed I did not understand how to use it on talend data integration. Can someone please help me. My connection requires the following steps:

Card authentication by AccessMaster.

  • Kerberos authentication of the user (automated by the HK component).

  • The Kerberos password can only be determined if the user has been authenticated by AccessMaster, and is registered with the ANSR-HD service Launch of a tool using SQL * NET (sqlplus, BO, ...).

  • The Oracle client asks the kerberos server, an access token to the Oracle database. This request can only succeed if the user's kerberos authentication has been successful beforehand.

  • The resulting token is sent to the "Kerberos listener", which verifies it using the kerberos database extract file.

  • If it is OK, Oracle checks that the authenticated user matches an external user declared in the database. The user can then work on the Oracle database.

  • According to you how I right to proceed on a job talend.

Thank you in advance.

Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hello,

Please have a look at talend Kerberos component which is used to set the relevant information for Kerberos authentication.

Let us know if it is what you are looking for.

https://help.talend.com/reader/F47Red1NLwB72yU9lQrFSQ/AZB3SD_7i~D3EYJUirUsuw

Best regards

Sabrina