Apache Ignite as linked Server in SQLServer? I tried to set up a linked server via ODBC connection in SQLServer. It seem to connect but showed all the caches as empty names in SSMS. Also I couldnt get a select query to work.

Has anybody had any luck with doing this?
If so.. How did you write the select statement?
Maybe you don't have tables for your caches. By default, Apache Ignite will not create tables in its caches - i.e. they are not mapped to SQL but work in key-value mode.

There are basically three options to make tables in Ignite - CREATE TABLE, Query Entities, and Indexed Types + annotations.

You can validate it by connecting to cluster with built-in sqlline utility and then issuing !tables command.