Connect from Excel

Start Microsoft Excel.

Start Microsoft Excel and open a blank worksheet.

Use the Data Connection Wizard to set up the connection.

1. Click the Data tab.

2. Select From Other Sources >

   From Data Connection Wizard option.

3. Select ODBC DSN from the list of data source options and click Next.

4. Select the DSN created for your Atlas cluster and click Next.

5. Select a database and collection from which to import data and click Next.

6. 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.

7. In the final wizard window,specify a format for your worksheet. Click OK when finished.

Open a spreadsheet in Excel.

Start Microsoft Excel and open a blank worksheet.

Open the iODBC Data Source Chooser dialog box.

1. Click the Data on the toolbar.

2. On the toolbar, click New Database Query, then click From Database.

   If the New Database Query button is not displayed, click Get External Data, then New Database Query.

Select Your DSN.

1. Click the System DSN tab.

2. Select the DSN which connects to your BI Connector for Atlas.

3. Click OK.

Enter Credentials.

Enter the username and password used to connect to BI Connector for Atlas and click Ok.

Select a Table.

1. In the left side of the dialog box, click your server name to expand the list collections in your database.

2. Select the collection from the list from which contains the data you want to import.

3. To view your data before importing, click Run to run the generated SQL statement. Your data appears in the table below the statement.

4. Click Return Data.

Import the Data.

1. Select how you would like to import the data into Excel.

   You can choose to import the data into:

   • An Existing Sheet, specifying in which cell to begin the table.

   • A New Sheet, automatically beginning the table in cell A1.

   • A PivotTable in a new sheet.

2. Click OK to complete the import process.