I'm connecting to Azure Synapse from an external service.
When I try to access the DB, I get the following error:
Address node: Couldn't retrieve data from external source for object 'CustomerAddress': WCA Error. Received http '500'. {"errorMsg":"Internal Error: Adapter InitDataSession failedException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'HADOOP'.\n\tat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)\n\tat com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729)\n\tat com..adapter.azuredw.metadata.adapter.DWUtil.execSqlQuery(DWUtil.java:80)\n\tat com..adapter.azuredw.metadata.adapter.DWUtil.createExternalDataSource(DWUtil.java:189)\n\tat com..adapter.azuredw.runtime.adapter.read.AzureDWNativeReader.readDatafromSourceToStage(AzureDWNativeReader.java:239)\n\tat com..adapter.azuredw.runtime.adapter.read.AzureDWNativeReader.init(AzureDWNativeReader.java:213)\n\tat com..adapter.azuredw.runtime.adapter.AzureDWTableDataAdapter.initDataSession(AzureDWTableDataAdapter.java:175)\n\tat com..cci.runtime.impl.CDataAdapterImpl.init(CDataAdapterImpl.java:71)\n\tat ...
I don't know what settings are missing.
If you have any information, please let me know.