0 Replies Latest reply: May 11, 2012 8:53 AM by Dirk Konings RSS

    Get data from Oracle Db through a firewall

    Dirk Konings

      We want to read data from a Oracle Db via QV Publisher.
      There is a Firewall between these 2 servers because they are on different locations in the network.

       

      A connection to the Db via servername/service or TNSname succeeds.
      Retrieving data is the problem.
      A telnet session to servername:1521 is ok, so the default Oracle port is open

       

      Which things do we have to check, to get this working ? It seems that the SQL Selects gets a timeout, so the job stays running in QEMC.


      Dirk konings