SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 


#Analytics
#SPSSStatistics
#Analyticstools
 View Only

  • 1.  Nested Arrays in MongoDB

    Posted 04/24/20 02:37 PM
    Hello SPSS statistics community, 

    I am currently working on a project using MongoDB and SPSS Statistics 26. I was able to import normal MongoDB files into SPSS statistics by reformatting them to JSON files. My question is whether it is possible to read nested arrays correctly in columns when I create an ODBC between MongoDB and SPSS? Or are the nested arrays displayed together in one column? Would I have to flatten the arrays first to read them in SPSS via JSON?

    Thanks for your help!

    Best regards
    Anna
    #SPSSStatistics


  • 2.  RE: Nested Arrays in MongoDB

    Posted 04/24/20 02:56 PM
    I don't have any experience with it, but look at

    It says that the ODBC driver ...
    "The MongoDB BI Connector provides access to MongoDB data by abstracting rich, hierarchical document structure and presenting it as a tabular, relational schema via a MySQL interface. The BI Connector acts as a SQL proxy and converts incoming SQL queries to equivalent MongoDB Query Language (MQL). Results are then returned in a standard tabular format and can be consumed by any application that supports direct connection to MySQL." 

    --


    ------Original Message------

    Hello SPSS statistics community, 

    I am currently working on a project using MongoDB and SPSS Statistics 26. I was able to import normal MongoDB files into SPSS statistics by reformatting them to JSON files. My question is whether it is possible to read nested arrays correctly in columns when I create an ODBC between MongoDB and SPSS? Or are the nested arrays displayed together in one column? Would I have to flatten the arrays first to read them in SPSS via JSON?

    Thanks for your help!

    Best regards
    Anna
    #SPSSStatistics