How to query data from Google Big Query into Statistica /Statistica Enterprise for analyses using Simba ODBC Driver?
Article ID: KB0078682
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0 and higher |
Description
PREREQUISITES:
1. Google BigQuery with at least 1 project and a dataset with at least 1 table
2. Simba ODBC driver for Google BigQuery
3. Cookie enabled browser
Issue/Introduction
Resolution
1. Launch Control Panel >> System and Security >> Administrative Tools >> ODBC Data Sources >> System DSN tab ( a simpler alternative to get there is: Click Start button -> type "ODBC" -> Windows Search finds the "ODBC Data Sources" administrative module, click on it to run ) .Click on the Add button.
2. Choose the Simba ODBC Driver for Google BigQuery. Choose User Authentication.
3. Login to Google account and generate the Refresh Token by pasting the confirmation code. You may choose the appropriate catalog and Dataset that you plan to query
Optionally the DSN can be tested.
4. Login to Statistica or Statistica Enterprise Manager.
- If you are logging into Statistica Enterprise Manager ensure you login as a user with Database Admin and Data Admin permissions.
5. If using Statistica desktop, the user may choose File >> External Data >>Query >> Create. If using Enterprise Manager, you may right-click on Database connections and select "New Database connection".
6. Click on New OLEDB and in the Data Link properties dialog, the user should choose "Microsoft OLEDB Provider for ODBC".
7. Choose the DSN that was created in Step 3 and enter credentials as required. You may optionally test the connection to ensure the connection details are correct and name the connection appropriately. In Enterprise Manager, commit the change to Save
8. In Statistica, you may define the query with the Query window that launches as shown below.
- In Enterprise Manager, right click on a folder and click "New Data Configuration" and pick the database connection created and click on Query Builder. Define the SQL query by dragging and dropping tables into the right-hand frame. ( the user may alternatively type the SQL statement instead of using the query builder). Click on the green triangular play button to finalize the query. In Enterprise Manager, click on the commit button to save the data configuration. Explore the data configuration created to bring the data into a spreadsheet.
Feedback
