Odbc Rstudio Download The Driver

Lebron James, Anthony Mason, and Latrell Sprewell averaged 39 minutes followed by several players -- including Michael Jordan and Kevin Durant -- at 38 minutes.

This driver makes it incredibly simple to connect to MongoDB data using analytics tools such as Microsoft Excel, Qlik, Microstrategy Desktop, Tableau Desktop, and PowerBI.

But before diving into specifics of the driver, it will be helpful to review some information about the BI Connector, how it functions, and what use cases it is intended to serve.

The BI Connector acts as a SQL proxy and converts incoming SQL queries to equivalent MongoDB Query Language (MQL).

Results are then returned in a standard tabular format and can be consumed by any application that supports direct connection to MySQL.

These ODBC connections are managed by underlying drivers that handle communication and the transfer of data between client applications and a defined data source.

As a result, the process was error-prone and did not represent an ideal user experience.

If you are using Windows, you should install the driver that matches the architecture of your application.

For example, if you are running a 32bit version of Excel, install the 32bit ODBC driver.

Likewise, the 64bit version of PowerBI requires the 64bit ODBC driver.

If you are running a mix of both 32bit and 64bit applications, there is no problem with installing both driver versions.

Odbc Rstudio Download The Driver

Make sure to download the driver that matches your version of Excel.

In our case, well select the 32bit version of the ODBC driver.

Now that the driver is installed, we can set up our Data Source Name (DSN) using the MongoDB ODBC driver.

Select the MongoDB ODBC 1.0 Unicode Driver.

We encourage all users to select the unicode driver unless there is a specific need to use the ANSI driver.

In this example, we are connecting to an instance of BI Connector running in the MongoDB Atlas database service and will be working with data from the nba database.

In the server and port fields, input the address and port number for the BI Connector.

This DSN will now be available to Excel, and other apps that support ODBC.

If you are prompted to input username and password credentials, do so and click Connect.

Excel will then present you with a database and table listing where you can select the data you want to import.

After a moment we can see that Excel has loaded in just over 500k rows into our worksheet - from MongoDB.

For example, we want to find out which NBA player averaged the most minutes played per game.

Each row in our dataset represents the stats for a single player during a specific game.

So, in our Pivot Table we set player names as rows, and the average of minutes as our values.

Free Odbc Driver For Mac Rstudio