Many Vendors (like Infor Data Lake) offer only JDBC drivers and do not offer ODBC drivers. If you are thinking about how to use Java Driver in Non-Java apps (e.g. Excel, SSIS, Power BI) to perform some data integration then no worries.
We have a Product called JDBC Bridge Driver which can convert JDBC Driver calls to ODBC calls so any non-java app can use JDBC drivers without issue Check this article for detailed steps.
For example: You can load data from Infor Data Lake using their JDBC Driver two different ways (See below)
Method#1
Connect via SSIS–>ODBC Soure–>ZappySys JDBC Bridge–> Infor JDBC → Infor Data Lake
For this method: You need ODBC PowerPack installed on both sides (client / server) - Install on the Workstation (to design/ debug SSIS Packages) and Install on the SSIS Server after deployment.
Method#2
Connect via SSIS–>OLEDB Source → SQL Server -->Linked Server–> ZappySys Data Gateway → ZappySys JDBC Bridge → Infor JDBC → Infor Data Lake
For this method: You need ODBC PowerPack installed on the Server only.
After this, you can consume data in SSIS by writing a query like below in OLEDB source
SELECT * FROM OPENQUERY(LS_INFOR, 'select col1 from some_infor_table')