Re: Need help in connecting/retrieving Mongo DB data using Apache drill from Spotfire

[Andries Engelbrecht]

http://drill.apache.org/docs/create-view/ 
<http://drill.apache.org/docs/create-view/>

http://drill.apache.org/docs/sql-extensions/ 
<http://drill.apache.org/docs/sql-extensions/>

http://drill.apache.org/docs/mongodb-storage-plugin/ 
<http://drill.apache.org/docs/mongodb-storage-plugin/>


--Andries



> On Aug 8, 2016, at 8:47 AM, Sandhya Modupalli <sandhya_2...@yahoo.com> wrote:
> 
> Hi Andries,
> 
> Thanks for the quick response.
> 
> Could you please point me to the right place where I can find examples for 
> creating drill views or custom sql in Spotfire which can be read by drill.
> 
> Thanks & Regards,
> Sandhya
> From: Andries Engelbrecht <mailto:aengelbre...@maprtech.com>
> Sent: ‎08-‎08-‎2016 04:46 PM
> To: user@drill.apache.org <mailto:user@drill.apache.org>; Modupalli Sandhya 
> <mailto:sandhya_2...@yahoo.com>
> Cc: tshi...@apache.org <mailto:tshi...@apache.org>; jnad...@apache.org 
> <mailto:jnad...@apache.org>
> Subject: Re: Need help in connecting/retrieving Mongo DB data using Apache 
> drill from Spotfire
> 
> You will probably need to create Drill Views on the MongoDB tables for it to 
> display successfully. Tools like Spotfire will query Drill's INFORMATION 
> _SCHEMA for metadata, but complex data sources like Mongo will not provide 
> all the metadata in a consumable manner.
> 
> The advantage of a View is that you can use it to handle complex data 
> structures with Drill extended SQL, and make it available in a tabular format 
> that is more easily consumed by Spotfire.
> 
> Alternatively you can create custom SQL data structure in Spotfire to gain 
> access to Mongo.
> 
> --Andries
> 
> 
>> On Aug 8, 2016, at 1:07 AM, Modupalli Sandhya 
>> <sandhya_2...@yahoo.com.INVALID <mailto:sandhya_2...@yahoo.com.invalid>> 
>> wrote:
>> 
>> 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/ 
>> <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
> 

Re: Need help in connecting/retrieving Mongo DB data using Apache drill from Spotfire

[Andries Engelbrecht]

You will probably need to create Drill Views on the MongoDB tables for it to 
display successfully. Tools like Spotfire will query Drill's INFORMATION 
_SCHEMA for metadata, but complex data sources like Mongo will not provide all 
the metadata in a consumable manner.

The advantage of a View is that you can use it to handle complex data 
structures with Drill extended SQL, and make it available in a tabular format 
that is more easily consumed by Spotfire.

Alternatively you can create custom SQL data structure in Spotfire to gain 
access to Mongo.

--Andries


> On Aug 8, 2016, at 1:07 AM, Modupalli Sandhya 
>  wrote:
> 
> 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

Need help in connecting/retrieving Mongo DB data using Apache drill from Spotfire

[Modupalli Sandhya]

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