Hello Everyone,
We are on cloud (21.4). We would like to know whether it is possible to connect to DataBricks from Appian? From what we are told, there is not any REST API for that. So, I was wondering if Appian can connect to DataBricks via DataStore connectivity, or any other way?
Thanks,Akshar
Discussion posts and replies are publicly visible
Which DataBricks do you mean?
My best guess is that the DataBricks we have in our org is on AWS (https://databricks.com/documentation).
The team who reached out to us was mentioning about having ODBC (https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html) or JDBC connector in order to perform CRUD operations on the data store.
Now, historically, we did connect to our internal MS SQL Database server through Data Store connectivity. But I am not so sure whether the same connectivity is possible from Appian to DataBricks.
I hope this answers the question!
docs.databricks.com/.../api.html
Thank you for this detail! I will check with the team on whether we have such API implemented. Thanks again!
The team managing the databricks has some security concerns on API endpoints and are interested in knowing whether Appian can directly connect to the DataBricks through JDBC/ODBC drivers? Any thoughts here?
AFAIK Appian does not support connecting other JDBC databases than the supported ones.
docs.appian.com/.../System_Requirements.html
Just to confirm with Stefan, Appian does not natively support DataBricks JDBC/ODBC drivers. In case anyone wishes to have connectivity, they can create custom Connected System Plugin to achieve the same.