Here is another option for SQL Server JDBC authentication on my blog if you are looking for commercial support. Full disclaimer: I do get a paycheck from Progress. jdbc:datadirect:sqlserver://server1:1433;AuthenticationMethod=ntlmjava;Domain=Americas;User=SUMITS;Password=my_windows_auth_pwd ... View more

I came across this thread and my colleague published a more recent option on the DataDirect blog with Salesforce JDBC and Apache Nifi ... View more

Thank you mkempanna.  Performance will depend on which SQL queries you run through the Linked Server.  For example, complex queries are typically faster when pushed down to the database using OPENQUERY.  If you just select * from the table, both syntaxes will perform similarly. ... View more

One difference I noticed with DataDirect Impala ODBC driver is that it has a very large default varchar size for string data types to prevent possible data corruption, and SQL Server Linked Server doesnt like the length.     To fix, make sure to set Max Varchar Size = 4000 in the advanced tab. ... View more

Can you try the DataDirect ODBC driver for Impala to help rule out issues at the odbc layer? This is the fastest driver available, so should help point to driver or application depending on results. If storing data in SQL, have you considered SSIS? https://www.progress.com/products/data-sources/cloudera-impala-odbc-driver-cloudera-impala-jdbc-driver ... View more