Connection to data bricks via UiPath Studio is failing

Help Something Else
1

Hi everyone,

  • My requirement is to connect to azure data bricks in UiPath studio for data extraction from data bricks.

  • I am trying to connect to data bricks using database activities.

  • Created Data Source based on the link Create an ODBC DSN for the Databricks ODBC Driver | Databricks on AWS

  • And filled the details in below window to finish the configuration (details are Data Source Name, Host, Port, Username, Password (generated token in data bricks), http path, enabled the SSL option)

    image
    image630Ă—932 104 KB

  • But the connection is failing with below error message
    “ERROR [HY000] [Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Bad Status: Unrecognized response with no error message header. Status code: 404.”

    Screenshot 2024-06-11 123129
    Screenshot 2024-06-11 123129941Ă—732 28.3 KB

  • Any idea on this error message?

  • Need help to resolve this issue.

Thank you in Advance.

Regards

2

@Swathi_Mangena

is the DNS done properly?

as per error it is unable to find the db or resource you are trying to access

cheers

3

@Anil_G In DNS also I am getting same error. Is there any specific permission we need to provide from azure data bricks to connect?

4

@Swathi_Mangena

Then its clearly a dns issue…first…if the databricks is on your local cloud then you need to get permissions to connect to it as well…your azure team can help you get access to necesary resource group

cheers

5

@Anil_G Is there any documentation that states which permissions needs to provide?

6

@Swathi_Mangena

The permissions are related to azure and not UiPath…ideally azure admin should have the details

as per my knowledge…the user needs to be added to resource group and the instance f databricks you want to access

cheers

7

@Anil_G
Yeah, I am able to access data bricks manually but for automation purpose connection is failing.
I will connect with data bricks admin and try to resolve it.

Thank you for your support

1 Like
8

@Swathi_Mangena

Accessing databricks manually and via db dns connection are pretty different

Hope your issue would be resolved

Cheers

9

@Anil_G

Able to connect to data bricks via DSN less connection string.

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.