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:
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables