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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema