Migrating data out of Sisense

[eudson]

Dear community members - happy new year.

Although I have seen this post it doesn't full gives me what I need. 

Am working on project which is funded therefore our license was paid thru the funder and unfortunately the funds have runout and we want to migrate from Sisense to an OpenSource solution. So am looking for a way to export all the work we did (data) to a format(csv, excel, json, sql...) that I can then use to import to a relation database or even continue using elasticsearch. 

Can someone please point me to the right direction? 

[irismaessen]

If you have administrator privileges in Sisense, you can use the SQLRunner or the REST API to query the Elasticube directly and export all individual tables from the Elasticube to JSON (or, if you're scripting this, subsequently directly into the database of your choice)

[eudson]

@irismaessen thank you so much for your prompt response. I will try this and revert