4 Replies Latest reply: Apr 13, 2018 6:59 AM by David Štorek

Data Connection Timeout Change

Rajarshi Guin Apr 11, 2018 6:44 AM

Hi All,

We have a data connection pointing to an Oracle database. We have created the connection using the Qlik ODBC Connector Package option. We are able to connect to the database properly.

We would now like to increase the timeout for this data connection. However, we could not see any option to increase the timeout from with Qlik Sense.

So, we tried to create an ODBC connection to the database and set the timeout in that ODBC. We used the Qlik-oracle driver to create the ODBC connection and set the timeout. The ODBC connected to the dataabse successfully. However, when we created the data connection to the ODBC, the connection did not return any table.

We also tried to use the native Oracle driver present in Oracle Client to create the ODBC connection. But there we are only getting the option of creating ODBC with TNS Service name and not with Host Name and Service Name as required in Qlik Sense. We could not use this driver as we don't have the TNS Service Name.

So, can anyone please suggest how we can increase the timeout for the data connection.

Thanks,

Rajarshi Guin

Re: Data Connection Timeout Change

David Štorek Apr 12, 2018 5:46 AM (in response to Rajarshi Guin)

Hi,
what is you QS version? QS February2018 supports TNS services for Oracle
Like Show 0 Likes (0)

Actions
- Re: Data Connection Timeout Change
  
  Rajarshi Guin Apr 12, 2018 8:31 AM (in response to David Štorek)
  
  Hi David,
  
  Thanks for the reply. However, my query is not regarding the TNS Service name in Qlik Sense. I want to increase timeout for a Oracle data connection and need help on how that can be done.
  
  Thanks,
  Rajarshi
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Data Connection Timeout Change
    
    David Štorek Apr 13, 2018 6:36 AM (in response to Rajarshi Guin)
    
    Hi, based on following
    
    We also tried to use the native Oracle driver present in Oracle Client to create the ODBC connection. But there we are only getting the option of creating ODBC with TNS Service name and not with Host Name and Service Name as required in Qlik Sense. We could not use this driver as we don't have the TNS Service Name.
    
    I thought, that you are able to set timeout using native Oracle driver and this is ok, but you are than not able to connect to Qlik because of Qlik requires Host Name only not TNS Service.
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Data Connection Timeout Change
      
      David Štorek Apr 13, 2018 6:59 AM (in response to David Štorek)
      
      If it is not ok you can set timeout by setting advanced parameter when creating connection.
      By default it is set to 30 seconds. In image above it is changed to 120 seconds. You can see details here. Oracle documentation here
      Is this what you have been looking for?
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post