Given that we now have Elasticsearch SQL, has anyone tried to set up Elasticsearch as a Linked Server in MS SQL Server? I figured it would be possible since there is an ODBC driver, but I haven't been able to successfully query my cluster yet.
I set up the ODBC connection to our Elastic Cloud cluster (I think correctly - the connection test passed, at any rate). When I set up the Linked Server in SQL Server Management Studio (I'm using 2014 in this case), it successfully creates the Linked Server object but when I expand the "Catalogs" list I don't see any indices, like I would expect. Instead I see a long list of catalogs all with the same id of our elastic host, and none of which have any tables in them.
Would love to know if anyone has had any success setting this up?