[Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 401, Error message: Unknown.

Oracle no esta configurado para manejar una URL de conexion, en CBC nos conectamos solo con una url, no como las bases de datos normales

jdbc:databricks://adb-LOCDELUSER.17.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=/sql/1.0/warehouses/6b8LOCDELWAREHOUSE;AuthMech=3;UID=token;PWD=dapi5ePWDde-3

Al momento de configurarlo solo con la url, sin user ni password, el agente de conecta a Azure pero devuelve el siguiente error

Aug-17 10:45:13:297 :: --------------- Executing Custom Event :BefExtract ---------------

Aug-17 10:45:13:592 :: Error: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 401, Error message: Unknown.

Aug-17 10:45:13:593 :: Error: java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 401, Error message: Unknown.

at com.databricks.client.hivecommon.api.HS2Client.handleTTransportException(Unknown Source)

at com.databricks.client.spark.jdbc.DowloadableFetchClient.handleTTransportException(Unknown Source)

at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)

at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)

at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)

at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)

at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)

at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)

at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)

at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)

at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)

at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)

at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)

at oracle.epm.aif.agent.queryprocessor.QueryProcessor.executeQuery(QueryProcessor.java:117)

at oracle.epm.aif.agent.service.JobsServiceExecutor.call(JobsServiceExecutor.java:119)

at oracle.epm.aif.agent.service.JobsServiceExecutor.call(JobsServiceExecutor.java:42)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.base/java.lang.Thread.run(Thread.java:834)

La solucion para resolver este tema es ir a navegador/Intercambio de datos/Acciones/Aplicaciones y seleccione la aplicacion en conflicto, luego en opciones y en el password, debe borrar el punto que el sistema coloca por defecto

Luego de borrar el punto, la unica manera de modificar la conexion es desde DM, ya que por la opcion de aplicacion de intercambio de datos, ya no aparece la pesta;a de opciones en la opcion de detalles de la aplicacion en cuestion.