topic Re: How to Connect to SQL Server 2008 Data in ArcGIS for SharePoint Questions https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36471#M89 <HTML><HEAD></HEAD><BODY><SPAN>you can also serialize in json esri format so you can use api client.</SPAN><BR /><SPAN>See an example </SPAN><A href="http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93">http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93</A></BODY></HTML> Mon, 09 Jan 2012 05:39:44 GMT nicogis 2012-01-09T05:39:44Z How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36467#M85 <HTML><HEAD></HEAD><BODY><SPAN>We recently implemented ArcGIS for Sharepoint (2.0) and have a need to display some data that is stored in some SQL Server 2008 data tables. Its obvious how to reference a "list" of data that has been "imported" from an Access DB, but we want to display data directly from our SQL DB. Is there a way to do this or do you have to implement ArcGIS Spatial Data Services (SDS) in order to make this work. You'd think that doing an ODBC connection to any DB would be possible from within Sharepoint. Thanks for any thoughts or guidance!</SPAN></BODY></HTML> Thu, 03 Nov 2011 16:36:40 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36467#M85 KentAnness 2011-11-03T16:36:40Z Re: How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36468#M86 <HTML><HEAD></HEAD><BODY><SPAN>I think one primary question would be is the data from SQL Server using a spatial data type? </SPAN><BR /><BR /><SPAN>If no... you might look into the BDC Service which can make external lists from various database platforms. But using this service successfully really depends on which level of SharePoint you are using. </SPAN><BR /><BR /><SPAN>If data redundancy is not an issue the SSIS Integration Services sharepoint adapters can push/pull data from any database into/out of a sharepoint list in an unattended automated fashion.</SPAN></BODY></HTML> Fri, 16 Dec 2011 00:47:55 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36468#M86 RonnieRichards 2011-12-16T00:47:55Z Re: How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36469#M87 <HTML><HEAD></HEAD><BODY><SPAN>The data we want to leverage is just a standard SQL table that happens to have Lat/Lon values. Our Sharepoint folks did use BDC to connect create the list as it is rendered directly from the SQL table. The problem we're seeing now is that when we try to connect to the BDC rendered list we get the following error:&nbsp; Geographic Data Not Found �?? No geographic lists found in the specified site. Does the list need to reside in a table specifically setup for spatial data types???</SPAN></BODY></HTML> Wed, 04 Jan 2012 11:04:42 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36469#M87 KentAnness 2012-01-04T11:04:42Z Re: How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36470#M88 <HTML><HEAD></HEAD><BODY><SPAN>If I were to make a guess, I would say the ArcGIS connector is looking for an "ArcGIS Location" field in the lists on whatever SharePoint site it's searching on... as it can't find one, it thinks there are no spatially enabled lists...</SPAN><BR /><BR /><SPAN>I'm not sure if you would be able to create a ArcGIS Location field on a business data connectivity based table though - it seems unlikely... but I haven't tried... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Thu, 05 Jan 2012 03:40:31 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36470#M88 LeathMuller 2012-01-05T03:40:31Z Re: How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36471#M89 <HTML><HEAD></HEAD><BODY><SPAN>you can also serialize in json esri format so you can use api client.</SPAN><BR /><SPAN>See an example </SPAN><A href="http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93">http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93</A></BODY></HTML> Mon, 09 Jan 2012 05:39:44 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36471#M89 nicogis 2012-01-09T05:39:44Z Re: How to Connect to SQL Server 2008 Data https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36472#M90 <HTML><HEAD></HEAD><BODY><SPAN>Is it possible to server spatial data directly out of SQL Server?&nbsp;&nbsp; I have a shapefile that I have imported into SQL.&nbsp; I would like to make that available to the Web Part.&nbsp; How is this process accomplished?</SPAN></BODY></HTML> Tue, 22 May 2012 17:32:55 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/how-to-connect-to-sql-server-2008-data/m-p/36472#M90 ToddBoewe 2012-05-22T17:32:55Z