C# .NET - Access database importing Excel file both in SharePoint

  Frank Daske replied to Mauricio Chacon

Bi tools that support sharepoint features. . . . . . . . . . . . . . Hi, can any one give me a list of Bi tools that support the features of share point 2010. . . . . . . . . . . . . . . . . . . . help me. . . . . . . . . . . . . . . . . . . Choosing a business intelligence tool in SharePoint Server 2010 Published: May 12, 2010 Microsoft has several business intelligence (BI) tools and applications will be overlap across these areas. For example, a company’s employees may use Microsoft Excel 2010 and Excel Services in Microsoft SharePoint Server 2010 to make relevant business decisions at the corporate level. PerformancePoint Services uses Excel, Visio Services, and Excel Services to complement its BI tools to deliver a corporate dashboard that may reflect elements have all products work together. The following diagram shows tools from both SQL Server and SharePoint Server to explain categories in which each tool is generally used. SharePtServer 2010 BI Areas

Sharepoiont 2010 features. . . can anyone please tell me the list the sharepoint 2010 features(just names) and various BI tools it supports? Hi Veni, Here r the feature list of sharepoint 2010 PublishingStapling Staple Publishing features BasicWebParts Makes the following Web Parts available in the site administrators to override content type retention schedules and set schedules on libraries and folders. BizAppsListTemplates SharePoint Portal Server Status Indicator List template EnhancedTheming Enable enhanced .thmx theming. OsrvLinks Links to the to create help libraries. PremiumWeb Features such as the business data catalog, forms services, and Excel Services, included in the Office SharePoint Server Enterprise License. FCGroupsList This feature provides support for Manage Resources list types. TenantAdminBDC Links within this site collection. PremiumWebApplication Features such as the business data catalog, forms services, and Excel Services, included in the Office SharePoint Server Enterprise License. ContentLightup Provides several standard user interface components and links. ObaFields Provides the the Central Admin. PageConverters Contains the converters used to convert documents to publishing pages. LocalSiteDirectoryControl SharePoint Portal Server Local Site Directory Capture Control IPFSTenantFormsConfig Enables tenant administration of InfoPath Forms Services

i am trying to call a performance point chart web part that is available in sharepoint . . . . . . . . . . . . can any one please help me on this. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . end of post The PerformancePoint team receives how to deploy (or activate) the product now that it lives within the confines of SharePoint. This is definitely a valid question because the “up and running” process is quite different compared to the experience from 2007. To help illustrate the process, I’m going to take you through the steps necessary the diagram below: Topology_thumb_4EF19788 Typical Farm Topology To deploy PPS in this type of environment, SharePoint Enterprise Edition must be installed on the farm. If you are upgrading from PerformancePoint 2007, you must use the import option on the PPS settings page to import 2007 data to V2. This tool neither facilitates upgrading your actual SharePoint environment nor your PPS V1 environment. It only moves data (e.g. existing dashboards, scorecards V2. Before this tool can be run, we recommend that you set up a clean SharePoint 2010 environment. But if you have data from your 2007 environment that you need in

What's New for Developers in SharePoint 2010 Object Model? SharePoint 2010 Object Model comes with new functionality and introduces a new Client API. In this article I will cover the main new components in SharePoint 2010 Object Model and will show the types of solutions that can be built using them. This week I was attending the SharePoint 2010 Connections Conference in Amsterdam. It is always exciting to hear what's new and what can we do with it. You probably know that SharePoint 2010 comes with lots of new features and tools for developers, like: Sandboxed Solutions SharePoint Ribbon, SharePoint Dialogs, Silverlight Web Part, List Lookups and Relationships, Business Connectivity Services, LINQ, Client Object Model, REST, Developer Dashboard, Visual Studio 2010 SharePoint tools extensibility, Visual Studio 2010 SharePoint Project Types and Items SharePoint Designer 2010 and more

someone here can help. We have a document library that only contains submitted forms in excel format. The completed forms may be e-mailed in, uploaded, or created within the document submitted, as all I'm doing is copying information that is already contained in the excel sheet into the metadata. I was hoping to write a quick little VBA routine that information from cells into the metadata properties automatcially. However, I'm finding I can't access the metadata fields from within VBA. I've tried "customdocumentproperties" and "builtindocumentproperties" (document property objects do I automatically populate metadata fields using the information found in known cells from the excel sheet? Thanks for the help! To access SharePoint list from excel you can use this Synchronizing Tables with SharePoint Lists Add-In . Here is an article (MSDN) that describes how to enable this add