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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach