Connect from Excel¶
For M10+ clusters that have enabled the BI Connector for Atlas, the Connect dialog provides the details to connect via the BI Connector for Atlas.
Connect from Microsoft Excel¶
Start Microsoft Excel.¶
Start Microsoft Excel and open a blank worksheet.
Use the Data Connection Wizard to set up the connection.¶
- Click the Data tab.
Select From Other Sources >
From Data Connection Wizard option.
- Select ODBC DSN from the list of data source options and click Next.
- Select the DSN created for your Atlas cluster and click Next.
- Select a database and collection from which to import data and click Next.
Save the data connection file and click Finish.
If you wish to re-use this connection in the future, you can select it from the Data > Get External Data > Existing Connections menu.
- In the final wizard window,specify a format for your worksheet. Click OK when finished.
For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.