On this page, we will walk through how to set up an ODBC connection for your Unix-Based operating system so you can connect your data using Microsoft Excel.

Before You Begin

Before you can enable a connection to Microsoft Excel, you will need to obtain and download a Walmart-issued, secured key. If you have not yet obtained a secure key, please contact your Account Manager to request access.

Set Up the ODBC Connection

Watch the video or follow the steps below to set up the ODBC connection. Suggested installs needed are provided below.

Download and install the MacOS SimbaODBC driver for BigQuery here.
Download and install the ODBC Manager here.
If you haven't already, save your Walmart-provided json key file (recommended path: /Library/ODBC).
Configure the ODBC Manager:
- Navigate to the System DNS tab and click Add
- Choose your Simba ODBC Driver for Google BigQuery
- Complete all required fields, including:

Field	Value
Data Source Name	Provide a name, such as "BI Link Channel Performance"
Description	Provide a description, such as "BI Link"
Encrypt Sensitive Data	For All Users
OAuthMechanism	Service Authentication
Email	Enter the email associated with the connection
KeyFilePath	Provide the path to your JSON file (such as /Library/ODBC/filename.json)
Catalog	wmt-dv-bi-link-prod
Dataset	Select the BI Link dataset

Select OK.

Once you have set up the ODBC Connection, you can connect Microsoft Excel.

Disclaimer

Your use of this documentation is at your own discretion and risk. To the maximum extent permitted by law, the data, documentation and all related software, components, and support are provided by Walmart on an ‘as-is’ and ‘as available’ basis without any warranties of any kind, and Walmart expressly disclaims any and all express and implied warranties, including, but not limited to, warranties of merchantability, fitness for a particular purpose, title, non-infringement, non-interference, and warranties arising from a course of dealing. You acknowledge that Walmart does not warrant that the data will be uninterrupted, timely, secure, or error-free. Walmart may modify and delete the documentation in its sole discretion and without notice.

In no event shall Walmart be liable to you or any third parties for any damages whatsoever, including, without limitation, those resulting from loss of use, damage to your computer system, loss of data or profits, or any liability arising out of or in connection with the use of the data, documentation, software, components, or support.