How to Connect to SQL Server 2008 Data

Discussion created by kanness on Nov 3, 2011
Latest reply on May 22, 2012 by tboewe
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!