Hi, I have a requirement where the final destination to have the data in the Cloudera data warehouse and then connect to the Tableau dashboard. My data sources are PostgreSQL and MongoDB . What would be the best way to ingest data from MongoDB, the document structure is very dynamic- with nested loops and different objects . Do I convert the MongoDB documents to relational and then import the data or Have the documents imported as is from Mongo DB directly ? Would I be able to query the unstructured data if imported as is ? Any help would be highly appreciated.
... View more