SSL Authentication For Oracle Data Source In TDV

SSL Authentication For Oracle Data Source In TDV

book

Article ID: KB0080078

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.5, 7.0.6,7.0.7, 7.0.8

Description

  • Understand that what kind of SSL communication setup for Oracle data source.
               https://www.oracle.com/technetwork/database/enterprise-edition/wp-oracle-jdbc-thin-ssl-130128.pdf 
  • Test the Oracle SSL connection using any other JDBC tool or standalone JDBC program to make sure that you are able to connect to Oracle database using SSL
Now follow the below steps to configured Oracle data source using SSL in TDV:
  • Ensure that you is using JRE 1.8 for TDV/CIS. If not then upgrade your TDV/CIS JRE version to 1.8.
  • Copy the Oracle JDBC jar to appropriate oracle adapter location (Depending on which Oracle driver/adapter your are configuring i.e. Oracle 11g, Oracle 12c etc.)
  • Create a truststore/keystore using the SSL certs. (or use the truststore/keystore used in testing using other JDBC tool or standalone JDBC program)\
  • Copy the truststore/keystore to TDV host and provide appropriate permission.
  •  Now create a new Oracle data source in TDV.
  • In order to establish the Oracle SSL connection, you would like to use Oracle JDBC url as below sample url (or use the same connection url used in testing using other JDBC tool or standalone JDBC program). To set the Oracle connection url, please open Oracle data source and go to "Advanced" tab and edit the "Connection URL Pattern" property (refer below screenshot). 
              jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST =172.23.7.188)(PORT = 2484))) (CONNECT_DATA =                                              (SERVER = DEDICATED) (SID = orassl)))

                                 Oracle_SSL_JDBC_Connection_URL
  • Now please setup the below JDBC properties. To set the Oracle connection url, please open Oracle data source and go to "Advanced" tab and edit the "JDBC Connection Properties. (Please note that below is a sample and you need to use the values according to your environment). 
                                 Oracle_SSL_JDBC_Properties
             Note: You would like to confirm with Oracle admin/DBA for the supported cipher suites in your environment and use the same values for "javax.net.ssl_cipher_suites" property. 
  • After that please perform a "Test Connection" to test the data source connection.
  • Please perform Add/Remove Resources and execute a table to ensure everything is working as expected.
                                      
                                      
                                       





 

Issue/Introduction

This article illustrate how to configure Oracle data source in TDV with SSL.