How to connect from Studio Web to BigQuery/studio webからbigqueryへの接続方法について

Help Studio Web
, , ,
1

Is it possible to connect to BigQuery from UiPath Studio Web, execute a query, and retrieve the results?

I have looked into solutions such as using CData products, but most of them are designed to be executed locally.

I’m looking for a way to directly connect to BigQuery from Studio Web and retrieve data.

Additionally, I have already created a service account on GCP, and I have successfully created a connection to Google Cloud Platform.

studio webからbigqueryに接続してクエリを実行し、その結果を取得することはできますでしょうか？
cdataの製品を利用する方法等は確認していますが、localで実行する前提のソリューションが多く
studio webから直接bigqueryに接続してデータを取得する方法を知りたいです。

また、GCP上でservice accountは作成済みで
google cloud platformのconnectionは作成出来ています。

2

@shirata.motoki,

Try this solution

3

Hi @shirata.motoki

以下のリンクを確認してください:

https://www.cdata.com/kb/tech/bigquery-odbc-uipath.rst

役に立つものを見つけたら解決策としてマークしてください。自動化を楽しんでください!

4

Thank you for letting me know.
And I apologize for asking again.
With this method, I believe you need to install the Simba ODBC driver on a local Windows machine, configure the connection settings, and then use that connection to connect to BigQuery.
Is that correct?
In that case, could you please explain how to configure the connection in Studio Web?
I couldn’t find it in the Integration Service connectors.

5

@shirata.motoki

Try to follow below link , might be helpful,

Happy Automation!

1 Like
6

@shirata.motoki,

You will have to use it in Studio desktop. I think on Studio Web it won’t work.

2 Likes