I am trying to use Elasticsearch SQL ODBC Driver to push data from Elasticsearch to MicroStrategy on Windows 10. I've created a system DSN in Windows and a Database Instance in MicroStrategy Developer Tool for this purpose. But the connection keeps failing.
Has anyone successfully connected Elasticsearch and MicroStrategy? I am open to other approaches to achieve the same.