Hi All,
From what I’ve learned, different DB’s in KNIME can’t be joined without first initiating Spark or similar. DB Connectors using Azure + Spark work great for me, but there’s incompatibility when trying to connect Spark to DB Connectors using SQL Server:
ERROR DB to Spark Execute failed: Failed to load JDBC data: This driver is not configured for integrated authentication. ClientConnectionId:96f56d7a-9c3e-4727-ba36-d58d4736c7ed
SQL Server’s JDBC Parameter for “integratedSecurity true” seems required for me. But this seems to be the Spark incompatibility. Anyone know of a workaround? I’m on Knime4