topic Get data from Oracle Db through a firewall in QlikView https://community.qlik.com/t5/QlikView/Get-data-from-Oracle-Db-through-a-firewall/m-p/347332#M705455 <HTML><HEAD></HEAD><BODY><P> We want to read data from a Oracle Db via QV Publisher.<BR />There is a Firewall between these 2 servers because they are on different locations in the network.</P><P></P><P>A connection to the Db via servername/service or TNSname succeeds.<BR />Retrieving data is the problem. <BR />A telnet session to servername:1521 is ok, so the default Oracle port is open</P><P></P><P>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.</P><P><BR />Dirk konings</P></BODY></HTML> Fri, 11 May 2012 12:53:40 GMT dirk_konings 2012-05-11T12:53:40Z Get data from Oracle Db through a firewall https://community.qlik.com/t5/QlikView/Get-data-from-Oracle-Db-through-a-firewall/m-p/347332#M705455 <HTML><HEAD></HEAD><BODY><P> We want to read data from a Oracle Db via QV Publisher.<BR />There is a Firewall between these 2 servers because they are on different locations in the network.</P><P></P><P>A connection to the Db via servername/service or TNSname succeeds.<BR />Retrieving data is the problem. <BR />A telnet session to servername:1521 is ok, so the default Oracle port is open</P><P></P><P>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.</P><P><BR />Dirk konings</P></BODY></HTML> Fri, 11 May 2012 12:53:40 GMT https://community.qlik.com/t5/QlikView/Get-data-from-Oracle-Db-through-a-firewall/m-p/347332#M705455 dirk_konings 2012-05-11T12:53:40Z