using IN-DATABASE tool to write data into a shared path in databricks

[Katy]

I try to use IN-DATABASE tool to move data from oracle db to a shared path in databricks. Tried the 3 Options “create a new table”, "create a temp table", "insert an existing table" but got error

Error: Data Stream In (16): Error SQLDriverConnect: [Simba][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.

End:

My ODBC connection is OK. And rest of settings in Alteryx looked ok to me. I can access and write data to the path via databricks UI but not Alteryx in-database tool.

[BrandonB]

Have you followed the guide here to configure your read and write driver settings? https://help.alteryx.com/current/designer/databricks

 

[Katy]

yes, I followed the guide configured the read and write driver settings.