Database Reference
In-Depth Information
available
on
the
BigQuery
third-party
tools
page
at
third-party-tools
. If you need the Linux version, want tech support, or
merely want to get updates, you can get those from Simba at
The remainder of these setup instructions assume you use Windows 7,
although the steps won't be much different whether you run Windows XP or
Windows 8.
To install the Simba driver and create a DSN, you can do the following:
1. Download the Simba BigQuery ODBC driver that matches your
operating system and hardware (the 64- or 32-bit versions as necessary)
and run the installer. This registers the BigQuery ODBC connector with
the operating system. (Note it also requires administrator privileges on
your machine.)
2. After the driver is installed, you need to create a Data Source Name
(DSN), an antique Windows term for a connection to a database. To
create your DSN to connect to BigQuery, open the Control Panel, select
the Administrative Tools (see
Figure 13.1
) and open the Data Sources
(ODBC) applet. You might have to change your Control Panel view to
large or small icons to see Administrative Tools.
3. After you open the Data Sources Control Panel applet, click Add in the
User DSN tab. This creates the connection for just a single user;
alternatively you could use a System DSN if you want to create the
connection for all users of the machine. The Add button brings up a
dialog box asking you to select the DSN type. Choose Simba BigQuery
ODBC driver from the list, and it displays the BigQuery-specific settings
dialog box.
4. Create a name for the DSN (
bigquery1
, for example). This is the name
that you will use later when you use the DSN to connect to BigQuery.
5. The DSN encapsulates authorization for BigQuery, so to set it up, you'll
need to tell BigQuery who you are and perform the OAuth2 sign-in
process. Click the Sign in button, and it pops up a web browser. Google
requires that OAuth2 be done in a web browser, which can make this
type of login flow a bit awkward. The rationale is that this prevents you
from having to type your password into anything that isn't a web
browser; presumably you already trust your web browser with your
