Connect Ignition to DataBricks EDL

Ignition
,
1

Hello there,

I have never connected Ignition gateway with DataBricks EDL connection. I want to do this now with JDBC Driver.

I’ve added JDBC driver with spark jar. Now I am not getting how to get Connect URL and generate token to connect required schema.

Please suggest.

Ignition version: 8.1
Spark version: 4.2

2

I don’t really understand what Databricks is, but I don’t think this is going to work like you think.

It looks like Databricks uses JDBC to take in data, but I don’t think you can use JDBC to get data out of it.

3

@Gaurav.Shitole I happen to work at the same company, and the protocols for token generation and connecting to the company’s Databricks environment, and gaining access to datasets will likely not be similar for others. I can send you some documentation specific to us.

https://docs.databricks.com/dev-tools/api/latest/authentication.html

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html