1

One of the teams using RPA in my company wants to automate reporting that is run in Qubole - Hive environment. The initial approach is to unleash the robot to log in to Okta, then Workbench in Qubole, run the query, and download results.

Is there a more straightforward way to do it using UiPath Studio you know about?

Sabito stands with Ukraine
  • 4,271
  • 8
  • 34
  • 56
Krystian Duda
  • 11
  • 1
  • Thanks, Mohit and Pradeep. It turns out that in my org I can only use the rest API option since the data sits on s3. I'll have to explore how to do that using UiPath. – Krystian Duda Sep 23 '20 at 15:48

2 Answers2

0

I'm not much familiar with the UiPath studio but if UiPath has ODBC/JDBC interface to connect to different data sources, then you can make use of the Qubole ODBC or JDBC driver (refer: ODBC Driver and JDBC Driver ) to directly fire the hive SQL query on Qubole Analyse and the driver will return the results to UiPath.

Sabito stands with Ukraine
  • 4,271
  • 8
  • 34
  • 56
Mohit Yadav
  • 21
  • 2
0

You can also utilize REST API calls REST API Reference to submit queries to qubole.

Sabito stands with Ukraine
  • 4,271
  • 8
  • 34
  • 56
Pradeep Gouru
  • 3
  • 2