Connecting uipath to Google Bigquery

[3175472466 (billlim)]

Hi Team,
How do i connect to Google Bigquery? Can i use the standard database activities that work for MySQL?

Regards,

[jack.chan]

Connect UiPath to google bigquery

1. Create a new service account in google console

• grant service acccount access to
  a) big query data editor
  b. bigquery admin
• export the account key as a JSON file

2. download simba odbc driver (32bit)

3. open odbc data source manager (32 bit)

4. add new data source, referencing the service account email and json file path
   

   

5. if it works you will able to select the catalog and dataset which will be automatically populated

now use UiPath db activity the same as any other DB
for connecting, use connection wizard (same as MySQL !!!) and connect to microsoft odbc driver
then search for the odbc source you created above…

for more information refer to this

BigQuery ODBC Driver - Simba using Service Account

[3175472466 (billlim)]

@jack.chan i have already one data source created but how do i link it to UiPath DB Activities?
is there a screenshot of how you connect?

Regards,

[jack.chan]

@3175472466

e.g. if your datasource is called BQ-SVC, set connection string =
"Dsn=BQ-SVC"

provider name =
"System.Data.Odbc"

[rikulsilva (Henrique Lima da Silva)]

Hi @3175472466

Just complementing…

For Windows Project you need download the 64bit Installer and use odbc data source manager (64 bit)

Another point, if the bot will be run from multiple users in the same machine you will need repeat step 4 for each user or create a System DNS and change the Encrypt Sensitive Data from For Current User Only to For All Users

Cheers