Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

One Star

Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

So far okay: I can use a tMSSQLInput component. The Select statement in the SQL is executed correctly on the database and returns results. -
Problem: On pressing the "Guess Schema" button within the Properties of the tMSSQLInput component I get the error message "Can't connect to SOCKS proxy". (Besides: Same error also when testing the registered connection in the metadata)
==> Question: What is necessary to get a SOCKS proxy working:
a) for the SOCKS proxy server itself
b) on the network/firewall side (protocol, port etc)

I am using TOS 6.1.1 with jdk1.8.0_72 on a Windows 2012 Server





Proxy settings are working to download external modules:

Highlighted
Moderator

Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

Hi,
We cannot repro your issue on our side. Is your socket proxy working well on other softwares?
Can you successfully connect to your mssql DB through client without using Talend Tool?
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.
One Star

Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

Hi Sabrina
I even don't know if there is a socket proxy. (It's for the Swiss Government - IT org structure is quite complicated. Even simple questions take days to be answered and often need an official inquiry request...
But I can successfully connect to the MS SQL Database
  a) with other means than Talend (e.g. SQL Server Management Studio)
  b) but also with Talend.
All 3 things are on the same machine: MS SQL DB, Talend and SQL Server Management Studio.
Moderator

Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

Hi,
Does this issue repro on other build version?
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.
One Star

Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

Sorry, in this case I am not allowed to install another build.
Could you, please, just tell me what happens on the network when pressing the "Guess Schema" button?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog