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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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