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.
Highlighted
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 Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch