sisense弹性立方是否支持nosql数据库结构？

Question

我必须从MongoDB加载Sisense ElasticCube数据模型中的数据，MongoDB集合的数据结构如下。

 {
    "FirstName": "Dilip",
    "LastName": "Singh",
    "Address":
    [{
            "Address1": "E-34",
            "Address2": "New Ashoknagar",
            "City": "East Delhi",
            "State": "Delhi",
            "Country": "India"
        }, {
            "Address1": "D2098",
            "Address2": "14th Avenue",
            "City": "Gaurcity",
            "State": "Noida",
            "Country": "India"
        }
    ],
    "Designation": "Sr. System Analyst"
}

我发现Sisense数据模型中缺少地址。我点击了这个链接https://documentation.sisense.com/latest/managing-data/connectors/mongo-db.htm#gsc.tab=0

Answer 1

Sisense通过MongoDB数据连接器支持来自MongoDB的NoSQL。他们声称"MongoDB是一个无模式的NoSQL数据库。使用这个连接器，您可以直接在MongoDB上运行任何SQL查询，以理解您的非结构化数据。“

MongoDB Data Connector