topic Can you connect to non-spatial SQL-database table into ArcMap? in Data Management Questions https://community.esri.com/t5/data-management-questions/can-you-connect-to-non-spatial-sql-database-table/m-p/571494#M32383 <HTML><HEAD></HEAD><BODY><P>When I connect to a certain SQL database using ArcMap I get a total of 3 spatial layers brought in. </P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/415166_Scr.JPG" /></P><P></P><P>However when I connect to the same database&nbsp;with the same credentials&nbsp;using&nbsp;Excel or Power BI I get a large amount of tables instead (non-spatial data).</P><P></P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/415167_Scr2.JPG" /></P><P></P><P>Is it possible to connect to these tables somehow using ArcMap or Catalog?</P><P></P><P>Thanks, Rob</P></BODY></HTML> Thu, 26 Jul 2018 00:16:02 GMT RobWilson 2018-07-26T00:16:02Z Can you connect to non-spatial SQL-database table into ArcMap? https://community.esri.com/t5/data-management-questions/can-you-connect-to-non-spatial-sql-database-table/m-p/571494#M32383 <HTML><HEAD></HEAD><BODY><P>When I connect to a certain SQL database using ArcMap I get a total of 3 spatial layers brought in. </P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/415166_Scr.JPG" /></P><P></P><P>However when I connect to the same database&nbsp;with the same credentials&nbsp;using&nbsp;Excel or Power BI I get a large amount of tables instead (non-spatial data).</P><P></P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/415167_Scr2.JPG" /></P><P></P><P>Is it possible to connect to these tables somehow using ArcMap or Catalog?</P><P></P><P>Thanks, Rob</P></BODY></HTML> Thu, 26 Jul 2018 00:16:02 GMT https://community.esri.com/t5/data-management-questions/can-you-connect-to-non-spatial-sql-database-table/m-p/571494#M32383 RobWilson 2018-07-26T00:16:02Z Re: Can you connect to non-spatial SQL-database table into ArcMap? https://community.esri.com/t5/data-management-questions/can-you-connect-to-non-spatial-sql-database-table/m-p/571495#M32384 <HTML><HEAD></HEAD><BODY><P>Yes, you can, as long as some rules followed by ArcGIS are met.</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/databases-and-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/databases-and-arcgis.htm">Databases and ArcGIS—Help | ArcGIS Desktop</A>&nbsp;</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/view-data-in-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/view-data-in-arcgis.htm">View data from a database in ArcGIS—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Thu, 26 Jul 2018 08:35:14 GMT https://community.esri.com/t5/data-management-questions/can-you-connect-to-non-spatial-sql-database-table/m-p/571495#M32384 Asrujit_SenGupta 2018-07-26T08:35:14Z