Dear team, We have a usecase where we need to conenct to mongoDB from spotfire and have to retrieve all data for visualizations. Here we have taken the step to go with Apache drill which inturn connects to mongo DB. We have followed the steps given in documentation and have setup the connection to apache drill from spotfire successfully. https://drill.apache.org/docs/configuring-tibco-spotfire-server-with-drill/
When we expand the database connection in spotfire using Drill JDBC/ODBC driver, we are not able to see the list of columns/attributes under the collection but the same columns we are able to see when we use the progress odbc driver for mongo db in spotfire. We have tried with both ODBC and JDBC driver for apache drill, its the same issue with both drivers. When I expand users collection in information designer, am not finding users(collection).id/name/age, I see only ???* under users collection. Please find attached screenshots which gives a clear picture that we are not able to see id/name/age columns of user collection and kindly help us in fixing this issue at the earliest. Many Thanks in advance,Sandhya Modupalli
