Cannot use SQL Server External Table

[rboreux]

Dear all,

I have an ArcGIS Enterprise 11.3 deployed in Azure with a geodatabase installed on SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8).  

In this database, we configured a External Data Source to access external tables in another SQL Server databse.

In Miscrosoft SQL Server Management Studio, I can query those external tables. I can also query it through Excel with an ODBC connection.

In ArcGIS Pro, I can see the external tables in the catalog but when I try to add it in the content pane, I get the following error :

"Underlying DBMS error[[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Internal Query Processor Error: The query processor could not produce a query plan"

Does someone knows if it's possible to achieve what we are trying to do ?

Thank you in advance,

Best regards,

Simon

[MobiusSnake]

I'm not really familiar with External Data Sources, but have you tried adding the tables from them to Pro using a Query Layer rather than directly from Catalog?

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm

[rboreux]

Hello MobiusSnake,

Thank you for your quick answser. Yes I did but I get the same error. I also tried to create a view directly from SQL Server Manager and query it in ArcGIS Pro, but I'm facing the same issue.