idea The ability to connect from ArcGIS Desktop to an SQL Warehouse. in Data Management Ideas https://community.esri.com/t5/data-management-ideas/the-ability-to-connect-from-arcgis-desktop-to-an/idi-p/923675 <P><SPAN>Currently we are able to create a database connection <SPAN>in ArcCatalog&nbsp;</SPAN>to an SQL Database in Azure, and&nbsp;<SPAN>successfully display the data in ArcMap</SPAN>, but we can not connect from ArcCatalog to an SQL Warehouse in Azure. The connection issue appears to be specifically related&nbsp;to ArcCatalog <SPAN>querying </SPAN>functions unsupported by an SQL Warehouse.</SPAN></P><P><SPAN>.</SPAN></P><P><SPAN>The idea is to be able to create a database connection in ArcCatalog to connect to a View in the Azure SQL Warehouse containing data with coordinates X Y and Lat Long. (</SPAN><SPAN>not geodatabase in Azure, just a plain SQL Table</SPAN><SPAN>). O</SPAN><SPAN>nce connected, we could&nbsp;</SPAN><A href="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/make-xy-event-layer.htm" target="_blank" rel="noopener">make and xy event layer</A><SPAN>, display it in ArcMap, and publish the map as a map service in ArcGIS Server. &nbsp;</SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 13 Sep 2022 18:08:31 GMT LemuelMarquez 2022-09-13T18:08:31Z The ability to connect from ArcGIS Desktop to an SQL Warehouse. https://community.esri.com/t5/data-management-ideas/the-ability-to-connect-from-arcgis-desktop-to-an/idi-p/923675 <P><SPAN>Currently we are able to create a database connection <SPAN>in ArcCatalog&nbsp;</SPAN>to an SQL Database in Azure, and&nbsp;<SPAN>successfully display the data in ArcMap</SPAN>, but we can not connect from ArcCatalog to an SQL Warehouse in Azure. The connection issue appears to be specifically related&nbsp;to ArcCatalog <SPAN>querying </SPAN>functions unsupported by an SQL Warehouse.</SPAN></P><P><SPAN>.</SPAN></P><P><SPAN>The idea is to be able to create a database connection in ArcCatalog to connect to a View in the Azure SQL Warehouse containing data with coordinates X Y and Lat Long. (</SPAN><SPAN>not geodatabase in Azure, just a plain SQL Table</SPAN><SPAN>). O</SPAN><SPAN>nce connected, we could&nbsp;</SPAN><A href="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/make-xy-event-layer.htm" target="_blank" rel="noopener">make and xy event layer</A><SPAN>, display it in ArcMap, and publish the map as a map service in ArcGIS Server. &nbsp;</SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 13 Sep 2022 18:08:31 GMT https://community.esri.com/t5/data-management-ideas/the-ability-to-connect-from-arcgis-desktop-to-an/idi-p/923675 LemuelMarquez 2022-09-13T18:08:31Z Re: The ability to connect from ArcGIS Desktop to an SQL Warehouse. https://community.esri.com/t5/data-management-ideas/the-ability-to-connect-from-arcgis-desktop-to-an/idc-p/923676#M206 <HTML><HEAD></HEAD><BODY><P>That will be great. I have a same problem with Microsoft SQL Data Warehouse.</P></BODY></HTML> Mon, 06 Feb 2017 19:48:58 GMT https://community.esri.com/t5/data-management-ideas/the-ability-to-connect-from-arcgis-desktop-to-an/idc-p/923676#M206 RobertoLabaut 2017-02-06T19:48:58Z