Forum Discussion

eudson's avatar
eudson
Data Storage
01-17-2023

Migrating data out of Sisense

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? 

data models

2 Replies

Replies have been turned off for this discussion
  • irismaessen's avatar
    irismaessen
    Data Pipeline
    01-17-2023

    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's avatar
      eudson
      Data Storage
      01-18-2023

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