[SERVER-2063] Need a plugin for excel Created: 04/Nov/10  Updated: 14/Dec/15  Resolved: 14/Dec/15

Status: Closed
Project: Core Server
Component/s: Usability
Affects Version/s: 1.7.0
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Alvin Richards (Inactive) Assignee: Unassigned
Resolution: Done Votes: 12
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
is related to SERVER-21877 Support ANSI SQL Closed
Participants:

 Description   

Request:
Mongo is being used to replace traditional RDBMS. A number of customer want to continue to present analytical data in Excel, now sourced from MongoDB. However, there is not a simple plugin or formatter for JSON documents into Excel spreadsheet cells.

Business Case:

  • user experience
    Integrate with the tech stack of the customer


 Comments   
Comment by Ramon Fernandez Marina [ 14/Dec/15 ]

With MongoDB 3.2 we've introduced the MongoDB connector for BI:

The MongoDB Connector for BI lets you use MongoDB as a data source for your SQL-based BI and analytics platforms. Seamlessly create the visualizations and dashboards that will help you extract the insights and hidden value in your multi-structured data.

See this article for an example on how to use MongoDB with Excel.

Regards,
Ramón.

Comment by Alvin Richards (Inactive) [ 04/Nov/10 ]

May be able to utilize REST service in Excel

http://msdn.microsoft.com/en-us/library/ee556413.aspx

Generated at Thu Feb 08 02:58:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.