Configuring Encrypted Communication (SSL/TLS) For TDV Hive Data Source
Article ID: KB0080245
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.5, 7.0.6,7.0.7 |
Description
- Please test the SSL/TLS communication with Hive data base using any other JDBC client tool or standalone JDBC program.
- Now copy the certificate JKS file to the host where TDV has been installed and make sure that appropriate permission/access granted to certificate JKS file & its path so that it can be accessible by TDV.
- Now create a Hive custom adapter in TDV. Please refer the attached document for creating a Hive custom adapter in TDV.
- After creating the Hive custom adapter, create a new data source using newly created Hive custom adapter.
- Now open the newly created Hive data source. In "Basic" tab of data source, please select "Authentication" as "KERBEROS". Also please specify "Login" & "Password" if you are using username/password with principal name for Hive database authentication. Else please specify the "Keytab file" name along with its path and "Service Principal Name".
- Now go to "Advanced" tab in Hive data source and edit the "Connection URL Pattern". Please use the same JDBC connection url in "Connection URL Pattern", which was used for testing in step#1.
For Example:
-----------------
jdbc:hive2://abc.test.com:10000/default;principal=hive/dvbu-cdh53-7094.hadoop.net@HADOOP.NET;ssl=true;sslTrustStore=/opt/TDV/truststore.jks;kerberosAuthType=fromSubject
- Now save the data source changes and perform the "Test Connection".
- After successfully verified the test connection in step# 5, now perform "Add/Remove Resources" operation to add the Hive data source resources and you should be able to add resources for Hive data source.
Issue/Introduction
This topic describes how to set up encrypted communication For TDV Hive Data Source
Attachments
Feedback
Yes
No
Powered by
