EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB442063: How to connect to Google Big Query(Native API) and query tables from Microstrategy Desktop 10.x?


Shuang Qi

Senior Cloud Support Engineer II • Strategy


This article instruct how to connect to Google Big Query Native API and query the tables from Microstrategy Desktop as there are some differences by design between Microstrategy Web and Desktop.

To configure OAuth Parameters for Server based Dataset from Desktop, following steps are required.
1. On Data Sources page, click Customize Shortcuts button to enter customize setting page.

ka04W000001IuB9QAK_0EM44000000Qy72.png


2. Hover over the cloud sources, and click Set OAuth (User required to have the privilege to Set OAuth Parameters).

ka04W000001IuB9QAK_0EM44000000Qy77.png

 
3. Set required OAuth Parameters "Client ID" and "Client Secret" in the dialog box. The credential is created in Google Cloud Platform. 
Refer here for detailed steps to generate credentials to access Google API.
  

ka04W000001IuB9QAK_0EM44000000Qy7C.png

 
4. Please note "Callback URL" patterns for different sources:
User should add "Callback URL" or "Redirect URL" to 3rd party data sources according to following pattern. Since some oauth sources can only support one Redirect URL for single app, so it is suggested user to set up separate apps for Web Server - Browser connection and Rest Server - Desktop / Workstation connection, otherwise user may need to update Redirect URL saved in 3rd party data sources frequently.
 

Data Sources

Support Multiple Authorized URLs in single app?

Callback URL

Google Analytics

Y

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

http://localhost
Google BigQueryYhttp://localhostGoogle DriveYhttp://localhost

Salesforce Reports

N

http://localhost

Dropbox

Y

http://localhost

Facebook

N

http://localhost/

Twitter

N

http://127.0.0.1

5. Click OK to save the OAuth parameters.
 
Article reference number KB442063


Comment

0 comments

Details

Knowledge Article

Published:

September 30, 2018

Last Updated:

December 31, 2018