[Feature] Compass JDBC Driver now Generally Available

Hey everyone,

Wanted to spread the joy after the holiday season in case you hadn't come across it or otherwise heard. The Data Lake's "Compass JDBC" driver is now generally available and accessible from the Infor Support portal's Download Center.

If you have ETL clients, applications, or users that need a traditional database-like solution of connecting to the Data Lake in order to query and retrieve results, the Compass JDBC driver should make things a heck of a lot easier in those scenarios. Like the Compass APIs, the JDBC driver uses the underlying query platform to process your SQL. Note that any query you can run in one Compass interface can be run in any others - since it's effectively the same platform under the covers!

The Compass JDBC is different from a normal JDBC driver in quite a few ways, however. Remember - the Data Lake is an immutable data store. You cannot run the following familiar types of SQL syntax/commands:

UPDATE
DELETE
EXEC
ALTER
CREATE
DROP
INSERT

Finally, you'll need to double-check with your Infor account rep or manager if you don't see the Compass JDBC driver available for download. It does require an existing entitlement for moving data out of the Infor cloud. If you need a hand finding where & how to download it, go visit:

https://support.infor.com > Downloads > Products > Infor SaaS Add-Ons > Technology > Infor OS (formerly Xi Platform)

Enjoy!

Find more posts tagged with

Infor Data Fabric

Comments

tdouglass

If we wanted to build staging tables that multiple reporting tools could source, are we able to do this in the data lake? Would that include a tools such as SSIS that would read from the data lake, process the data, and then push back into the data Lake? Or is it only for getting the data out of the Data Lake and our staging tables would need to be outside of the data lake?

Legacy Contributor

The post says data lake data is immutable with no CRUD functions allowed. I would also like to know if we can add data lake tables or similar data stores. The latter can be done in Palantir Foundry, so it is possible in theory.

Legacy Contributor

Hey guys,

Sorry - took a brief hiatus and missed the forums for a bit.

Data Lake doesn't yet support building out tables, views, or materialized views at this moment. Some customers have used the Compass tooling to query a mix of tables and blend the data together before re-ingesting that into the Data Lake where it's represented as a new data object with accompanying metadata in the Data Catalog.

We're actually working on a couple of threads here to add in improved data management features around content already in the Data Lake to make this far easier in the future, however.

Legacy Contributor

Hey Denver,

You're not able to execute commands like INSERT, UPDATE, TRUNCATE, DELETE FROM, etc.

We will be introducing data management features that allow you to create new tables & views as well as scheduling refreshes for materialized content.

Legacy Contributor

Hi Mike,

I just posted a question on this topic, my question is about setting up SQL Server Management Studio (SQL Query Tool) to access the Data Lake. Are there any instructions on this available?

Copyright © 2025 Infor. All rights reserved.