In my project, I need to connect to DataLake using Microsoft SQL Server. Im using the Linked Server functionality. How can I achieve this? I’ve already tried using JDBC-to-ODBC bridge drivers, but this solution appears to be very slow and unstable.
Did anyone ever answer this for you? Check out streaming pipelines - they (Infor) should be supporting on-prem SQL Server in Data Fabric shortly if they're not already (you might be able to talk them into pre-release).