tSnowflakeConnection and tSetProxy

Four Stars

tSnowflakeConnection and tSetProxy

Hi,

 

Has anyone got the tSnowflakeConnection to work from a corporate network behind a firewall?

 

We have to use a HTTP/S Proxy to connect out.

 

This works fine for connecting for example to S3 as you can click Config client in the Advanced Settings for tS3Connection and set your Proxy Host/Port/Protocol/Username and Password.

 

The tSnowflakeConnection does not have this functionality and as such i'm getting:

 

Jun 25, 2018 3:08:22 PM net.snowflake.client.jdbc.RestRequest execute
SEVERE: Got error response: http status=407

 

I've tried to put a tSetProxy behind the tSnowflakeConnection but there is no way to provide HTTPS proxy connections with a username and password.

 

Is there any other way of doing this or am I going to have to use a different product such as Matillion to get this done until the tSnowflakeConnection is more fully developed?

 

Thanks

Moderator

Re: tSnowflakeConnection and tSetProxy

Hello,

Could you please go to  Studio > Window -> Preferences-> General -> Network connections to see if you can set up Studio/jobs to use proxy settings?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tSnowflakeConnection and tSetProxy

Hi Sabrina,

This is already set and does not seem to get picked up by jobs.

Thanks,

Giles

Moderator

Re: tSnowflakeConnection and tSetProxy

Hello,

Could you please let us know if this practice mentioned in topic https://community.talend.com/t5/How-Tos-and-Best-Practices/bd-p/howto_bestpractice is helpful for you?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: tSnowflakeConnection and tSetProxy

Hi gcar31,

have you tried to setup those vars in Job Level using JVM params?

 

Screenshot at Jun 29 08-27-43.png

Employee

Re: tSnowflakeConnection and tSetProxy

List of params:
-Dhttp.proxySet=true
-Dhttp.proxyHost=<proxy_server_host>
-Dhttp.proxyPort=<proxy_server_port>
-Dhttp.nonProxyHosts=localhost
-Dhttp.proxyUser=<proxy_server_user>
-Dhttp.proxyPassword=<proxy_server_password>
-Dhttps.proxyHost=<proxy_server_host>
-Dhttps.proxyPort=<proxy_server_port>
-Dhttps.proxyUser=<proxy_server_user>
-Dhttps.proxyPassword=<proxy_server_password>