It always astounds me what Microsoft are willing to bundle with their software, Analysis Services or SSIS (SQL Server Integration Services) with SQL Server for example! They haven’t stopped, they bundle Windows Sharepoint Services with Windows Server 2003, with is basically a fully functional SharePoint Server, however they still have SharePoint Server 2007 as a product. So what are the differences? At first glance it doesn’t appear to be much, however for tight integration into the enterprise, it seems that MOSS 2007 (Microsoft Office SharePoint Server) is a must! I will highlight the most interesting bits that MOSS 2007 has over and above WSS 3.0 (Windows Sharepoint Services) :
- User Profiles support – Allows each user to store profile information
- Site Manager – Manage Navigation, Security and look and feel with drag an drop functionality
- Enterprise Search Tools – numerous tools to search Sharepoint Sites and Portals across entire enterprises
- Business Data Catalog – The Business Data Catalog (BDC) tightly integrates external data, providing access to external data residing within other business applications, and enabling the display of, and interaction with external data
- Business data search – Search data residing in your business applications using the BDC (See Above)
- Business Data Web Parts – Used for viewing lists, entities, and related information retrieved through the Business Data Catalog
- Business document workflow support – Automate document review, approval, signature collection, and issue tracking using workflow applications
- Retention and auditing policies – Allows customized information management policies to control retention period, expiration, and auditing
- Browser-based forms – Integration with InfoPath, allows integration on to SharePoint of created forms and surveys.
- Integrated, flexible spreadsheet publishing – Allows information workers to easily choose what they want to share with others and determine how others can interact with published spreadsheets.
- Share, manage, and control spreadsheets – Provides access to spreadsheet data and analysis through server-calculated, interactive spreadsheets from a Web browser. Can help to protect any sensitive or proprietary information embedded in documents, such as financial models, and audits their usage.
- Web-based business intelligence using Excel Services – Allows spreadsheets to be broadly and easily shared. Fully interactive, data-bound spreadsheets including charts, tables, and PivotTable views can be created as part of a portal, dashboard, or business scorecard.
- Data Connection Libraries – Document Libraries storing ODCs (Office Data Connections), Making one single location for all data connections.
- Business Data actions – Easily create actions that open Web pages, display the user interfaces of other business applications, launch InfoPath forms, and perform other common tasks.
- Integrated business intelligence dashboards – Rich, interactive BI dashboards that assemble and display business information from disparate sources by using built-in Web parts, Excel spreadsheets, Reporting Services, or a collection of business data connectivity Web Parts.
- Report Center – Provides consistent management of reports, spreadsheets, and data connections.
- Key performance indicators – A KPI web Part can connect to Analysis Services, Excel Spreadsheets, SharePoint Lists, or manual entered data.
- Notification service – Improved allowing workflow users to receive emails by default, and improved triggering and filtering
- Single Sign-On (SSO) – Allows the User to log onto a variety of applications with a single user name and password, therefore integrating back office applications, and helps pre-population with integration to the Profile part of MOSS 2007.
- Social Networking Part – Connect to Public My Site pages to help establish connections between colleagues with common interests
- Personal Site Support – Allows Users to create Personal Web Sites
- Content syndication – Use RSS feeds to syndicate content managed in a portal site.
This is just a few of the extras you get in MOSS 2007, and I have highlighted those that are more angled to Business Intelligence! As for the cost, you can find that here: (In USD$ I am afraid) http://office.microsoft.com/en-us/sharepointserver…
MOSS 2007 sits centre stage in Microsoft’s BPIO (Business Productivity Infrastructure Optimisation) vision for the “People Ready Business”… Lets see what it can do!
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr