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

Highlighted
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>

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

How to Modernize Your Cloud Platform for Big Data Analytics With Talend and Micr...

Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>

Read