1 / 7

Unlocking Enterprise Insights with SharePoint and SQL Server Integration

Discover the powerful features of SharePoint’s integration with SQL Server, including real-time data access and visualization through Excel Services and KPI dashboards. Leverage Business Data Catalog to read and write from multiple database sources while creating custom actions and web parts. Excel Services enables effortless data manipulation like in Excel, with easy charts and graphs for performance monitoring. Enhance your applications with Forms Services, allowing you to design user-friendly forms that resemble websites, perfect for power users to efficiently utilize their data insights.

zuzela
Télécharger la présentation

Unlocking Enterprise Insights with SharePoint and SQL Server Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Leveraging SharePoint Enterprise Features

  2. Powerful Features .SQL Server Reporting Services .Excel Services .BDC .KPI .Dashboards .Forms Services

  3. Excel Services .Excel Calculation Services .Display information from your Database . Handle data as you would in Excel . Easy charts and graphs . Real time data availability . Ability to narrow the view of the data from a larger source . Note: Excel Services must be enabled in the farm . Connections are stored in the SSP

  4. Business Data Catalog • . Read data from multiple sources • . Both read and write operations against the data sources • . Update requires more work than read • . Custom actions need to be written • . Multiple web parts • . Web part presentation of data can be customized via XSL

  5. Forms Services • . Leverage InfoPath without the client • . Create easy-to-use forms that look like websites • . Geared towards a power user to best utilize their knowledge • . Data connection library maintains connectivity to information

  6. Key Performance Indicators • . Indicators based on the data in the system • . See performance towards goals and danger levels • . Real-time monitoring • . Easy, one-glance graphical view of operations

  7. On to the Demo!

More Related