Confluence vs SharePoint

27 November 2015

Contents

  • Purpose
  • Disclaimer
  • Overview
  • Key features
  • Summary

 

Purpose

The purpose of this document is to provide an overview of Atlassian Confluence and Microsoft SharePoint, and provide the capabilities, strengths and limitations of each tool for varied business needs.

 

Disclaimer

Information provided in this document is for reference use only. Information in this document is prepared based on prior projects experience, Confluence.com, Microsoft.com, and web research. The information in this document does not guaranty full accuracy of the items explained. For any questions or concerns please contact Nagaraj Yerram at nyerram@netpeach.com

 

 An overview

Feature/Context

SharePoint

Confluence

Overview

SharePoint is the business collaboration platform for the Enterprise and the Internet. It enables employees in an enterprise to work with other people, share content and information, or line-of-business data in a seamless manner. SharePoint comes with rich set of out-of-the-box integrated capabilities for most enterprise functions, and provides the tools and gadgets to customize for the extensive business needs.

Atlassian Confluence is the evolution of wikis designed to perform as an online collaboration and, document management product. Using Confluence connect your entire business in one place online to collaborate and capture knowledge – create, share, and discuss your documents, ideas, minutes, and projects. Confluence is an easy-to-use, user friendly and powerful tool.

 

Key features

Feature/Context

SharePoint

Confluence

On-premise and Cloud offering

Offers both. Part of Office 365 offerings. There are third party cloud offerings apart from Microsoft. Cloud plans start at $5 /user/month.

Offers both. Cloud offer costs ~ $2000 /2000 users / month.
https://www.atlassian.com/software/confluence/pricing

Supported browsers

Supports all major browsers

Supports all major browsers. (https://confluence.atlassian.com/doc/supported-platforms-207488198.html)

Mobile support

Can be accessed through mobile browsers.

Can be accessed through mobile browsers.

On-Premise Platforms supported:

Windows Sever OS

Supports window, Linux, and Solaris.
https://confluence.atlassian.com/doc/supported-platforms-207488198.html

Scalability

Can be scalable

Can be scalable

Pros

- SharePoint is a robust platform on which you can build on to suit your business needs.
-  SharePoint offers a wide range of possibilities as an integration platform, and comes with plenty of options/templates/Workflows to suit most complex business problems.
- SharePoint custom lists/libraries to capture any kind of information.

- Confluence is an easy-to-use, user friendly and powerful tool.
- Confluence Dashboard lets you practically browse through all the information on your portal.
- On premise version supports multiple platforms.

Cons

Share point’s out of the box user interface is not as intuitive as Confluence. Needs some user training. SharePoint 2013 version has improved UI.

Limited with Document management and wikis.
Custom list and Libraries to collect any kind of information.

 

Team Spaces

Feature/Context

SharePoint

Supports

Confluence

Supports

Remarks

Sites/Spaces

A SharePoint Site is a collection of pages, lists, and libraries. A site may contain sub-sites, and those sites may contain further sub-sites.  Sites can be created per pre-packaged functionality. Examples   Site templates in SharePoint include: collaboration (team) sites, wiki sites, blank sites, and publishing sites.

ü

Confluence Spaces are containers for pages and blog posts with related content and they come into two main varieties. 1.Site Spaces: Sometimes called 'global' spaces, these are areas where you can create content and collaborate with other users. 2.Personal spaces:  You, and other Confluence users, can set up a personal space. You can keep it private, or open it up for other users to view or edit.

ü

 

Dashboard

SharePoint does not have this feature as all.

û

The heart of Confluence is the Dashboard where you can practically browse through all the information on your intranet, at least the information you have permission to read.

ü

 

Site / Space Categories.

SharePoint comes with bundle of templates and options to start building your portal based on your business need.
E.g.: In Collaboration [Team, Blank, Blog, Group work, Visio…]
Enterprise:  Document, Records, Business Intelligence, Search,
Publishing, Wikis, Web database, etc.

ü

Confluence comes with: Team, Personal, Knowledge, Documentation, Wikis, Blogs, and Blank spaces.

ü

Though SharePoint leads in this context, but most users do not get the value right away. They need a training to get the most value of each site type.

Site / Space permissions.

 A SharePoint site can be set up to either inherit permissions from the parent site, or to allow unique permissions to be set for the site. Can grant permissions to users or SharePoint groups.

ü

A Confluence Space can set up its own set of Permissions which are granted to users and groups by a space administrator.

ü

SharePoint also lets you grants permissions to AD groups directly.

 Site / Space Directory

The Site Directory provides a central location from which administrators can view, manage, and access all the Web sites that are associated with a portal site. From the Site Directory, administrators can view both the portal structure and individual sites within the portal, approve or reject new sites, and edit or delete site links.

ü

The Space Directory, accessible from the global header, allows users to view spaces by category and add spaces to their favourites list.

ü

 

 

In General

Feature/Context

SharePoint

Supports

Confluence

Supports

Remarks

Notifications/Alerts:

Out of the box feature.

ü

Out of the box feature called page watches

ü

Both the tools provide good notification options.

Full-text search:

Out of the box feature.

ü

Out of the box feature. Can be accomplished using macros.

ü

Both SharePoint and Confluence have good search capabilities.

Security / User Roles / Permission Groups:

Out of the box feature.

ü

Out of the box feature.

ü

 

Single Sign-on

Supports LDAP integrations and User profiles

ü

Supports LDAP integrations and User profiles

ü

 

LDAP & Active Directory Support:

SharePoint Supports LDAP integration. Active Directory is the default supported LDAP.

ü

Confluence can delegate user authentication to LDAP and use LDAP group memberships to set the user's Confluence access permissions. This also allows Active Directory (AD) integration

ü

 

Branding / Customization:

Supports extensive customization. Including SPA (Single page application) integrations such as Angular JS, etc.

ü

Provides moderate customization. For more info: https://confluence.atlassian.com/doc/customise-space-layouts-139512.html

ü

SharePoint comes with basic look and feel, but lets you design any way you like.

Social features:

 

 

 

 

 

User profiles & Following other users:

In SharePoint, we can create our own personal site, and we can follow other users. We can give comments on their updates

ü

In Confluence, also we can create our personal space, we can update and follow others users

ü

 

Blog posts, discussing on forums, and commenting and liking posts, articles and other content:

Out of the box feature. Articles can be posted on chosen Sites or into your own blog with a connection to your Profile (My Site).

ü

Out of the box feature. Articles can be posted on chosen Spaces or into your own blog with a connection to your Profile (Personal Space).

ü

As SharePoint being a platform it comes with many options such as Discussion boards, Announcements, Survey, etc. SharePoint also has a Blog Site template.

Content export:

SharePoint provides several ways to export content to other formats depends on content.

ü

Confluence provides several ways to export content to other formats. You can export all or part of a Confluence space to various formats, including Microsoft Word, HTML, PDF and XML.

ü

 

Backup and Restore:

 

ü

 

ü

 

Administration:

Administration of SharePoint environment varies by the size of the farm, user base, integrations, and no of services usage.

ü

 

ü

Confluence administration can be simpler as there may not be that many services/integrations as in SharePoint.

 

Document Management

Feature/Context

SharePoint

Supports

Confluence

Supports

Remarks

Document Management and collaboration:

Supports very sophisticated document management and collaboration. 

ü

Supports very sophisticated document management and collaboration. 

ü

 

Support types of documents:

Supports all major file types

ü

Supports all major file types

ü

 

Co-authoring with Check-In/Check-out control:

It is out of the box feature.

ü

Needs a plugin called Arsenale Lock point from Atlassian Market place. It costs extra.

û

SharePoint leads in this feature. Confluence plugin costs approximately between $3 K to $5K per annum for 2000 uses.

Versioning:

SharePoint allows major and minor versions and default versioning is set to 500 versions.

ü

Scroll Versions enables you to manage different product variants in a single space. With Scroll Versions, you can use duplicate page titles within a single space. 
Scroll Versions you can manage and author multiple versions of your documentation in a single space.

ü

Both the technologies are good in context with versioning, file size, file types features.

Max File size allowed:

2 GB

ü

2 GB

ü

Max no of files allowed on in a library:

5000 files per document library. Though it has a limit we have seen cases where we had more than the limit.

ü

Not mentioned

ü

Tagging:

SharePoint supports tagging by adding metadata to describe what the content contains.  I have 2 primary types of Tagging: 1) Authoritative tagging 2) Social tagging.

ü

Labels are key words or tags that you can add to pages, blog posts, attachments and spaces. You can define your own labels and use them to categories, identify or bookmark content in Confluence.

ü

Confluence leads in this context and its tagging is more sophisticated.

Content approval and Workflows:

Out of the box feature.

ü

Need additional plugins from third party vendors. Here are few for additional price: 1) Approvals Workflow plugin 2) Content Publishing Plugin 3) page approval macro 4) Mark for Review plugin.

û

SharePoint provides out-of-the-box advanced workflows and as well as sophisticated content approval process.

File management:

Can map to windows explorer and manage collaboration right from windows explorer. Can create subfolders and copy subfolders etc.  Also, drag and drop files in the browser.

ü

Files are attached to Confluence pages. Can drag the flies in the browser to upload the files. Does not support folders. Can display the files with images

ü

While SharePoint provides just like windows file management system, and where as Confluence provides easy navigation of the files with configurable images.

Online office authoring/editing:

Needs office web app plug in.

ü

The Office Connector allows you to edit attached office files in their native application (such as Word, Excel, PowerPoint or OpenOffice) and save the file right back to the Confluence page. No need to download and re-upload the file.

ü

SharePoint leads in this feature. Confluence office connector has some limitations such as browser versions, file versions, etc.

Wikis:

SharePoint provides enterprise wikis, web application hosting, social media functionality and more. SharePoint is working its way towards offering the same functionality as Confluence, in a Microsoft way.

ü

Confluence is an enterprise wiki compared to SharePoint. Confluence page hierarchy, plugins, security, user macros, page alias, metadata macros, scaffolding and user interface offer a superior wiki platform over SharePoint. Confluence is a better wiki. 

ü

Confluence is still superior for information input and management of wiki pages. SharePoint is a Superior Document Management System. SharePoint's Site Collection / Sites / Subsites structure may be more suitable than Confluence's site structure for organizations 

Publishing:

SharePoint offers a Publishing template and Wiki page library for the most enterprises publishing needs.

ü

Confluence spaces are collection of pages where one can publish any web content.

ü

Confluence pages highly user friendly, whereas SharePoint comes with better control on data governance.

           

Document Management and collaboration summary:

Both the technologies offer sophisticated document management and collaboration. Both let you create, edit, share and manage documents. Each may lead in certain space. A benefit of Confluence is integration into Jira; of SharePoint integration into Exchange Calendar and task list, and better control on data governance.

If your organization prefer to write, take notes and save your thoughts easily, Confluence leads with its wiki features as a collaboration tool. Both Confluence and SharePoint do have the possibility to create a wiki site, but in practice, Confluence is the tool for wiki kind of writing. Its text editor is more intuitive, linking wiki pages to one another is simpler, and a deeper hierarchy of wiki pages is supported. It also has the Blueprints feature that allows you to create page templates easily for different purposes like meeting agendas or minutes.

if your organization is using and editing large amounts of office documents (Word, Excel and PowerPoint documents) SharePoint trumps Confluence as the collaboration platform of choice. In general SharePoint being a Microsoft product, it supports and integrates Microsoft Office files in a detail. Although Confluence recently introduced new features with office still not yet there.

 

Applications List and Services Integration 

Feature/Context

SharePoint

Supports

Confluence

Supports

Remarks

Apps and List Libraries

SharePoint comes with an out of the box option to create a List container to capture any type information.

These are like a database table or a spread sheet. All lists are CRUD enabled.

The following types of List templates are readily available:

- Tasks
- Site Mailbox
- Form Library
- Wiki Page Library
- Picture Library
- Links
- Announcements
- Contacts
- Calendar
- Promoted Links
- Discussion Boards
- Issue Tracking
- Survey
- Asset Library
- Custom List

ü

Confluence comes with an out of the box option to create a Task list. Task list can be customized.

 

For more info: https://www.atlassian.com/software/confluence/features/#tasks

ü

The magical feature of SharePoint that Confluence is missing is the lists (or libraries) function. You can create lists on SharePoint about almost anything and include data as if you were using a tiny database. You can collect information on the list (for example through web forms) and view information based on list attributes. For example, you could create different views to a single Document Library sorted by “modified by” or type of document, or you could bring up only some of the documents like those labelled with an “important” tag.

Business services

SharePoint comes with an out of the box option called BCS (Business Connectivity services). BCS is a view on external data—that is, data that is contained not within SharePoint but in external databases and systems. All list is CRUD enabled. 

ü

 

û

This feature is not an out of the box option for Confluence.

Web parts and third party solution integrations.

A standard SharePoint page contains text, images, Web Parts, and other elements. Content in Web parts can be customized. Most of the apps available in the server can be configured to view in a Web Part. An App can be native to SharePoint or an it could be completely a third part app to integrate their application into SharePoint portal.  Here is an example to integrate Tableau dashboard into a SharePoint portal. 

ü

In Confluence, also, integration can be achieved through customization and/or coding.Not the native feature. http://community.tableau.com/thread/140398?start=0&tstart=0

 

ü

As SharePoint being widely used as an enterprise intranet portal, most third party integration solutions are already developed. Confluence lacks this advantage.

 

Summary

Confluence and SharePoint two separate platforms for different purposes which do share similar functionality in some aspects. Both the tools are based on completely different technology. Great advantage of Confluence is easy-to-use, whereas SharePoint lets you design/build easy-to-use portal. Both the tools offer lots of options and choices.

Both Confluence and SharePoint are good alternatives for intranets. To make the choice, the most important thing is to first crystallize what you want from your intranet. What will it be used for? For an intranet concept combining published pages and documents, news, collaboration and social features, Confluence might be the more user-friendly option. For an Intranet do lot more than publishing news and manage documents, such as business process developments, application integrations, BI and reporting services, etc. SharePoint might be a better option.

Tags:
Categories: SharePoint

SharePoint 2013 On-Premise vs Office 365 Online

27 November 2015

Contents

  • Purpose
  • Disclaimer
  • Overview
  • Key features
  • Pros and Cons
  • Summary

Purpose

The purpose of this document is to provide an overview of SharePoint 2013 Cloud vs On-Premise.


Disclaimer

Information provided in this document is for reference use only. Information in this document is prepared based on prior projects experience, Microsoft.com, and web research. The information in this document does not guaranty full accuracy of the items explained. For any questions or concerns please contact Nagaraj Yerram at nyerram@netpeach.com

 

Key features…

 Context

 On Premise

 Online

Infrastructure deployment & maintenance

Internal IT Support team maintains the SharePoint farm on premise, and regularly applies Microsoft patches and updates.

Microsoft manages the environment and ensures all updates and patches are deployed.

Availability & Business Continuity (BC)

Varies by company's internal capabilities and SLAs.

Microsoft’s SLA ensures 99.9% availability. Data protection services are provided to prevent the loss of SharePoint Online  data. Backups are performed every 12 hours and retained for 14 days.

Authentication

On premise, Active directory is used for authentication.

Can be configured to authenticate with on premise Active Directory.

Look and feel customization

Full support.

Full support.

Custom App Development

Development of custom app has more control and take less time to develop.

Development of custom app is different form on premise, and could take more time to develop.

Cost Involved

Purchase/Maintain Hardware, Software licenses etc.

Annual subscriptions for Office 365 Plans billed on a per user basis.

Information Security

Dependent on internal capabilities.

Information in MDS meets industry-specific security standards

Compliance Standard

Dependent on internal capabilities.

Verified by third party authors

Storage needs

Expensive storage devices, Site Collection -More than 100GB, Scalable  Storage Size

Cheap storage cost, Site Collection- up to 100Gb, Maximum content in single tenant -O365 plan based

 

Product features compared 

 Features

On Premise

Online

 Product Features

Support for complete enterprise features.

Office 365 cloud version missing some    features.

 Content features

ü

Supports most of the Content features.

 Site features.

ü

Supports most of the Site features.

 Search features

ü

Supports most of the features.

 Social features

ü

Supports full Social features.

 Insights features

ü

Does not support all Insights features.  Missing features such as  Business Intelligence Center, Performance Point Services, Dashboards & Scorecards, and SQL Server reports integration.

For complete feature comparison visit: SharePoint Online Services Description.

 

On-Premise Pros and Cons 

Pros

Cons

Control Performance

Cost of internal resources (staff, hardware, software, etc.)

Scale Up and Scale Out

Additional Geographic redundancy costs

Reduces Bandwidth requirements

Disaster Recovery dependent on internal capabilities

Fully Customizable

Scale Up/Out Cost(SW/HW)

Full Server and SQL Database

Patching Servers/farms

Migrate as Needed

Extra configurations for External Collaboration

Uptime 99.99%

More ISP Bandwidth

Multiple Data centers

Limited Customizations

Geographically redundant

Possible Storage Costs

Shorted release cycle

Recovery SLAs

Managed Services (SaaS)

No Server access

Pay as you go (Low Cost)

 

Reduced impact on internal IT resources

 

Scalability

 

 

Summary 

SharePoint Cloud option was first introduced in 2010. In the past, there have been some major differences between SharePoint Online and SharePoint On Premise. Since then, Microsoft has been working towards release parity, meaning that SharePoint Online will be the equivalent of SharePoint On Premise. With the release of SharePoint 2013 that gap has come down significantly. With that said, there are still integration points and advanced functionality that are only available with SharePoint On Premise.

All Office 365 plans include the SharePoint Online service, but not all plans support all SharePoint features. E3 and E4 plans support most features. Cloud option is missing SharePoint’s some of the Business Intelligence features.

Could and On-Premise options come with its own advantages and disadvantages. Most of the information has been summarized in this document for reference purpose only.

 

Tags:
Categories: SharePoint

How to Scale Out a SharePoint 2010 Farm From Two-Tier to Three-Tier By Adding A Dedicated Application Server

23 September 2014

Many small to medium-sized organizations start using SharePoint in a “two-tier” server farm topology.  The two tiers consist of:

  1. Tier 1 – SharePoint Server with all web page serving and all Service Applications running on it
  2. Tier 2 – A SQL Server to store the SharePoint databases – the SQL Server could be dedicated to the farm or it might be shared with other non-SharePoint applications.

 

This farm topology can frequently support companies with hundreds of employees.  Of course, it depends a lot on the specifications of the hardware, but with late-model quad-core Xeons running on the two servers and 8 – 16 GBs of RAM on each one with RAID built with 15k RPM SAS drives in the SQL Server, this configuration with SharePoint Server 2010 can perform very well in many organizations that have less than 1000 users.

At some point, an organization that started with this two-tier topology may want to scale out to the next level which is a three-tier topology.  The three tiers would be:

  1. Tier 1 – SharePoint Server dedicated as a Web Front-End (WFE) with only the web application(s) and the search query service running on it
  2. Tier 2 – SharePoint Server dedicated as an Application Server with all of the other service applications running on it, but no web applications or query service
  3. Tier 3 – SQL Server for the databases

Visually, this topology looks like this:

1.     Scaling Out SharePoint 2010 Farm From 2-Tier to 3-Tier

Many small to medium-sized organizations start using SharePoint in a “two-tier” server farm topology.

 

The 2-Tiers consist of the main components:

1.       Tier 1 – SharePoint Server with all Web page serving and all Service Applications running on it.

2.       Tier 2 – A SQL Server to store the SharePoint databases – the SQL Server could be dedicated to the farm or it might be shared with other non-SharePoint applications.

  

 

This configuration with SharePoint Server 2010 can perform very well in many organizations that have less than 1000 users

 

At some point, Organizations that started with two-tier topology need to scale up to 3-Tier depending on the business need/requirement.

 

3-Tier components are broadly classified into the following segments:

1.       Tier 1 – SharePoint Server dedicated for Web Front-End (WFE) with only Web application(s) and Search Query running on it.

2.       Tier 2 – SharePoint Server dedicated for Application Server (App server) with all of the other service applications running excluding Web Applications and Query Service.

3.       Tier 3 – SQL Server for the Content DB/Search DB etc.

 

 

 

There are many different reasons why a company might want to scale out to 3-Tiers. Some kind of performance improvement is frequently what drives it. However, it may not be the obvious one of desiring better page serving times for the end users.  For instance, frequently companies do this to move the search crawling and index building process to a different server that is more tuned for its unique resource requirements and can do a more efficient job of crawling and indexing the company’s content. Perhaps in the two-tier approach their crawl\index component can’t get enough hardware resources to crawl through all of the content on a timely basis.

 

Services on Server page will have all of the service applications that run on the SharePoint 2010 server in a two-tier farm when you install SharePoint Server 2010 Enterprise edition and run the out-of-the-box configure Your SharePoint Farm Wizard and choose to provision all service applications.

  

 

Our goal is to add a third server to the SharePoint 2010 farm and have it take over running all of the service applications in the list Services on Server, with the exception of below three.

·         Microsoft SharePoint Foundation Web Application

·         Search Query and Site Settings Service

·         SharePoint Server Search

 

These three are the ones that are necessary for the original server to function as a dedicated WFE with query processing.

 

The Search Query and Site Settings Service and some of its associated functionality in the SharePoint Server Search Service are technically not required on a WFE, but it is the best place to put them. The reason is that this is the process that takes the user’s search query and looks it up in the indexes. The indexes are files that the query processor needs local access to and are stored on the file system of the server(s) that is running the query service, not in SQL Server.

 

So, for best performance it is recommended to run the Search Query and Site Settings Service on the WFEs that are serving the pages.  The crawling and index process is a separate process whose job it is to build the indexes and push them up to the query servers.

 

The Search Topology configuration settings in SharePoint 2010 dictate what functionality of the SharePoint Server Search Service runs on what server in the farm.  So, while the SharePoint Server Search Service needs to run on both the WFE and the Application Server, it will be possible break out the functionality that it performs on each.  We will want it to perform query-related functionality on the WFE and crawling/indexing functionality on the Application Server.

 

1.1   Build a new SharePoint Server with exactly the same software

Take a fresh physical or virtual server that has Windows Server 2008 (R1 or R2) running on it, and install all the same SharePoint Server 2010 software on it that is installed on the existing SharePoint 2010 server in your existing farm.  That includes the full RTM Enterprise edition, whatever patches have been applied in your farm since RTM, and any other separate products that have been installed on your existing server such as the Office 2010 Web Applications and its patches.

 

1.2    Run the SharePoint 2010 Products Configuration Wizard on the new server and join the existing farm

Install all RTM software and all patches that have previously been applied to the farm BEFORE running the SharePoint 2010 Products Configuration Wizard from the new server’s Start menu. This means that you will want to respond NO to the prompt to automatically run the wizard until you have installed all software packages on the new server.  This will save you from having to run the wizard multiple times.  Run it once – after you have installed all software and patches on the new server.

 

When you do run the SharePoint 2010 Products Configuration Wizard, you will run it on the new server that will be your application server.

 

 

 

A screen in the wizard asks you for the Farm passphrase. This is a special password you created when you originally created the farm.  You have to enter it here in order to join this server to the farm.

 

 

 

 

Now the server has been joined to the farm and is a full-fledged farm member.  But, the Configure Your SharePoint Farm Wizard in Central Administration needs to run to add the service applications that exist in the farm to this new server.  So, it automatically fires up your browser and asks you to run the Farm Configuration Wizard.

 

 

1.3   Verify that everything is running properly on the new server

Verify that the new server is showing up as a member of the farm with a healthy status.  To do that go to Central Administration > System Settings > Manage Servers In This Farm and find the new server and verify that it has a “No action required” status. This is now a three-tier SharePoint 2010 farm.

 

Next step is to ensure that the three-tier farm has only the web page serving and query processing services running on the WFE and all of the other service applications running only on the Application Server.

(Note: the farm will work and be fully functional if you stop here.  You will have the same Service Applications running on multiple servers and SharePoint 2010 will automatically use this topology as a load balancing technique for the Service Applications.  There may be some environments where this is desired.  But, most organizations will want to separate the web-serving services and the application-serving services to provide a better balance for the farm as a whole as opposed to just load balancing the Service Applications.)

 

1.4   Re-configure the servers to run the services that are appropriate for their individual roles

 

The Web Front-End should run these (and only these) services:

1.       Microsoft SharePoint Foundation Web Application (this is what turns IIS into a SharePoint “page-serving” machine)

2.       Search Query and Site Settings Service (the process that takes the user’s query string and looks it up in the index)

3.       SharePoint Server Search Service (but just the functionality that is necessary for the query processor)

4.       Central Administration (assuming it is not moved it to the Application Server)

 

The Application Server should run these (and only these) services:

1.       Access Database Service

2.       Application Registry Service

3.       Business Data Connectivity Service

4.       Excel Calculation Services

5.       Managed Metadata Web Service

6.       Microsoft SharePoint Foundation Incoming E-mail

7.       Microsoft SharePoint Foundation Workflow Timer Service

8.       PerformancePoint Service

9.       Secure Store Service

10.   SharePoint Server Search (but just the scheduled content crawling and indexing building functionality)

11.   User Profile Service

12.   Visio Graphics Service

13.   Web Analytics Data Processing Service

14.   Web Analytics Web Service

15.   Word Automation Services

16.   Word Viewing Service

 

 (Important Note: Step 1 above is really the only step in the process that can be done during normal working hours.  Everything else has the potential to impact the availability of the system to the users. Of course, it is highly recommended to have solid backups in place before starting Step 2.)

 

For the most part, the re-configuration of the services involves stopping a lot of services on the WFE server (using the Services on Server page in Central Admin) and verifying that they are running on the new server (which they probably are because the Configure Your SharePoint Farm wizard started them up when you ran it in Step 2).  Then, you will want to make one last pass over the list of services running on the Application Server and make sure that the Microsoft SharePoint Foundation Web Application Service and the Search Query and Site Settings are not running on it.

 

Adjusting the Search Application Topology

The exception to the statements of the previous paragraph is the search-related services:  SharePoint Server Search Service and Search Query and Site Settings Service.  Search is complicated enough that it has its own topology configuration settings. We need to use this capability to place the query functionality of the SharePoint Server Search Service on the WFE and to place the crawling\indexing functionality of the service on the Application Server.

 

Since this is a little more complicated than the other Service Applications, this must be done first.

Navigate to the Search Administration home page in Central Administration. Scroll down to the bottom of the page until you see the section titled Search Application Topology:

 

This part of the page shows you what servers the following four components of the Search service are running on:

·         Search Administration component

·         Crawling component (this is the crawling engine that crawls your content and builds full-text indexes from it)

·         Database component (as the crawling engine crawls through the content, it stores the full-text indexes in SQL Server.  It also compiles the full-text indexes into special non-SQL files that can be propagated up to the WFE)

·         Query component (this is the component that receives the user’s query and looks up the results in the special files that have been propagated to the hard drive of the WFE)

 

The Server Name column shows that the Search Administration, Crawl, and Query components are currently running on the existing server.  The search-related databases are running on the SQL Server.

You want to do the following:

1.       Move the Search Administration component to the new Application Server

2.       Move the Crawl component to the new Application Server

3.       Leave the Database component running on the SQL Server

4.       Leave the Query component running on the WFE

To accomplish this, click on the Modify button to go to the Topology for Search Service Application page

 

By hovering your mouse over the component lines, you can bring up a drop down menu and select Edit Properties for the components you want to move to the new server. 

Do this now for the Search Administration component.

 

Now do it the same way for the Crawl component. Once you have changed the server assignments for these two components, you need to kick of the actual transfer of responsibilities by clicking on Apply Topology Changes.

               

When it is finished, you will be returned to the Search Administration home page and you should see that the components have been transferred as directed and all of the search-related servers should have a status of “Online”:

 

Transferring the remaining Service Applications

All that is left is to use the Services on Server page in Central Administration to make sure the list of services running on each server matches your master list from above:

You want the Web Front-End to run these (and only these) services:

1.       Microsoft SharePoint Foundation Web Application (this is what turns IIS into a SharePoint page-serving machine)

2.       Search Query and Site Settings Service (the process that takes the user’s query string and looks it up in the index)

3.       SharePoint Server Search Service (only the functionality that is necessary for the query processor)

4.       Central Administration.

 

You want the Application Server to run these (and only these) services:

1.       Access Database Service

2.       Application Registry Service

3.       Business Data Connectivity Service

4.       Excel Calculation Services

5.       Managed Metadata Web Service

6.       Microsoft SharePoint Foundation Incoming E-mail

7.       Microsoft SharePoint Foundation Workflow Timer Service

8.       PerformancePoint Service

9.       Secure Store Service

10.   SharePoint Server Search (only the scheduled content crawling and indexing building functionality)

11.   User Profile Service

12.   Visio Graphics Service

13.   Web Analytics Data Processing Service

14.   Web Analytics Web Service

15.   Word Automation Services

16.   Word Viewing Service

To do this, you use the Server drop-down control to select the server you want to adjust, and then use the Start/Stop link in the Action column to turn on/off the services.

 

1.5             Testing and Verifying

Below are the steps to for testing:

1.       Browse to each of the SharePoint web applications and log in with your user account and make sure you can hit the home page of each of them.

2.       In the opened sites, try to open up and edit a document in the browser using one of the Office 2010 Web Apps (Word, PowerPoint, Excel or OneNote).

3.       Browse to your My Site and verify that everything is working normally.

4.       Add a unique phrase to a test page somewhere in one of your Sites and then go run an incremental Search crawl from Central Administration.  After the crawl completes, go back to your Site Collection and search for the phrase.  Verify that it comes up in the results.

5.       Run an incremental User Profile Synchronization from the User Profile Administration page.  While it is running, logon to the desktop of the new Application Server, and find this program and run it:  c:\program files\microsoft office servers\14.0\synchronization service\uishell\miisclient.exe.  This is the Forefront Identity Management (FIM) client application that you can use to see the details of the AD synchronization process.  Several jobs will be run by FIM.  Verify that they all complete successfully with no error messages.

6.       In Central Administration, go into Manage Service Applications and click on Managed Metadata Service and select Manage in the ribbon.  Verify that the Term Store management interface loads and that you can add/change/delete a Term Set and some Terms.

7.       Finally, reboot your WFE and Application Server.  When they come back up, check your Windows System and Application event logs on those servers and verify that there are no SharePoint-related critical or warning events that you haven’t seen before you scaled out to three tiers.

8.       Browse to your primary web application one final time.

 

There are many different reasons why a company might want to scale out to three-tiers from two.  Some kind of performance improvement is frequently what drives it.  However, it may not be the obvious one of desiring better page serving times for the end users.  For instance, I frequently see companies do this to move the search crawling and index building process to a different server that is more tuned for its unique resource requirements and can do a more efficient job of crawling and indexing the company’s content.  Perhaps in the two-tier approach their crawl\index component can’t get enough hardware resources to crawl through all of the content on a timely basis.

One more point.  Many organizations will also choose to add a second WFE when they scale out to a three-tier farm.  (I don’t show this in the diagram above).  The second WFE will be configured exactly like the first one and some type of network load balancing (NLB) mechanism will be put in front of the WFEs to intelligently route user traffic to the two servers to balance out the load.   In this scenario, the three-tier farm diagram above would be modified to add a second WFE and the total number of servers in the SharePoint farm would be four.

Categories: SharePoint

Hardware and software requirements for SharePoint 2013

28 March 2014

Hardware requirements—web servers, application servers, and single server installations

Installation Scenario

Deployment type and scale

RAM

Processor

Hard disk space

Single server with a built-in database or single server that uses SQL Server

Development or evaluation installation of SharePoint Server 2013 or SharePoint Foundation 2013 with the minimum recommended services for development environments.

8 GB

64-bit, 4 cores

80 GB for system drive

Single server with a built-in database or single server that uses SQL Server

Development or evaluation installation of SharePoint Server 2013 or SharePoint Foundation 2013 running Visual Studio 2012 and the minimum recommended services for development environments.

10 GB

64-bit, 4 cores

80 GB for system drive

Single server with a built-in database or single server that uses SQL Server

Development or evaluation installation of SharePoint Server 2013 running all available services.

24 GB

64-bit, 4 cores

80 GB for system drive

Web server or application server in a three-tier farm

Pilot, user acceptance test, or production deployment of SharePoint Server 2013 or SharePoint Foundation 2013.

12 GB

64-bit, 4 cores

80 GB for system drive

Minimum recommended services for development environments

The following are the minimum SharePoint 2013 services and service applications that are recommended for development environments:

  • App Management service application
  • Central Administration web site
  • Claims to Windows Token service (C2WTS)
  • Distributed cache service
  • Microsoft SharePoint Foundation 2013 Site and Subscription Settings service
  • Secure Store Service
  • User Profile service application (SharePoint Server 2013 only)

Minimum software requirements

This section provides minimum software requirements for each server in the farm.

Minimum requirements for a database server in a farm:

  • One of the following:
    • The 64-bit edition of Microsoft SQL Server 2012.
    • The 64-bit edition of SQL Server 2008 R2 Service Pack 1
  • The 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Standard or Datacenter
  • Microsoft .NET Framework version 4.5
  • The SharePoint parsing process crashes in Windows Server 2008 R2 (KB 2554876)
  • FIX: IIS 7.5 configurations are not updated when you use the Server Manager class to commit configuration changes (KB 2708075)
  • Hotfix: ASP.NET (SharePoint) race condition in .NET 4.5 RTM:
    • Windows Server 2008 R2 SP1 (KB 2759112)
    • Windows Server 2012 (KB 2765317)

Minimum requirements for a single server with built-in database:

  • The 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Standard or Datacenter
  • The SharePoint parsing process crashes in Windows Server 2008 R2 (KB 2554876)
  • FIX: IIS 7.5 configurations are not updated when you use the Server Manager class to commit configuration changes (KB 2708075)
  • Hotfix: ASP.NET (SharePoint) race condition in .NET 4.5 RTM:
    • Windows Server 2008 R2 SP1 (KB 2759112)
    • Windows Server 2012 (KB 2765317)
  • The Setup program installs the following prerequisite for a single server with built-in database:
    • Microsoft SQL Server 2008 R2 SP1 - Express Edition
  • The Microsoft SharePoint Products Preparation Tool installs the following prerequisites for a single server with built-in database:
    • Web Server (IIS) role
    • Application Server role
    • Microsoft .NET Framework version 4.5
    • SQL Server 2008 R2 SP1 Native Client
    • Microsoft WCF Data Services 5.0
    • Microsoft Information Protection and Control Client (MSIPC)
    • Microsoft Sync Framework Runtime v1.0 SP1 (x64)
    • Windows Management Framework 3.0 which includes Windows PowerShell 3.0
    • Windows Identity Foundation (WIF) 1.0 and Microsoft Identity Extensions (previously named WIF 1.1)
    • Windows Server AppFabric
    • Cumulative Update Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB 2671763)

Minimum requirements for front-end web servers and application servers in a farm:

  • The 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Standard or Datacenter.
  • The SharePoint parsing process crashes in Windows Server 2008 R2 (KB 2554876)
  • FIX: IIS 7.5 configurations are not updated when you use the Server Manager class to commit configuration changes (KB 2708075)
  • Hotfix: ASP.NET (SharePoint) race condition in .NET 4.5 RTM:
    • Windows Server 2008 R2 SP1 (KB 2759112)
    • Windows Server 2012 (KB 2765317)
  • The Microsoft SharePoint Products Preparation Tool installs the following prerequisites for front-end web servers and application servers in a farm:
    • Web Server (IIS) role
    • Application Server role
    • Microsoft .NET Framework version 4.5
    • SQL Server 2008 R2 SP1 Native Client
    • Microsoft WCF Data Services 5.0
    • Microsoft Information Protection and Control Client (MSIPC)
    • Microsoft Sync Framework Runtime v1.0 SP1 (x64)
    • Windows Management Framework 3.0 which includes Windows Power Shell 3.0
    • Windows Identity Foundation (WIF) 1.0 and Microsoft Identity Extensions (previously named WIF 1.1)
    • Windows Server AppFabric
    • Cumulative Update Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB 2671763)
Categories: SharePoint

Migration of a SharePoint 2010 Site to SharePoint 2013

21 February 2013

This is a step by step process to upgrade a SharePoint 2010 site to SharePoint 2013. Since this is a live migration, it is suggested to do proper backups of the server and the database before starting. During the live migration process anything that happens in between like adding new items to a list or deleting any page will not be captured after the copy database has been performed.

 

1. Install SharePoint 2013 on a new separate server.

 

2.  Run the Configuration Wizard.

 

3.  Choose “Create a new server farm”.

 

4.  Choose a server and a database name.

 

 

5.  Set a passphrase then store it in a secure location, this will be needed in the future.

 

6. Specify a Port Number if it is not set by default and choose a security setting.

 

7.  Verify if all the values are correct and then click Next.

 

8.  Wait till all the configuration tasks are performed.

 

 

9.  If all the tasks are completed then the "Configuration Successful" screen is displayed. Click Finish.

 

10. Go to the SharePoint 2013 Central Administration of the new SharePoint installation. If the below screen is displayed then the installation completed successfully.

 

11. Go to the old SharePoint database, then copy the WSS_Content database.

 

12.  Verify source server properties.

 

 

13.  Set the destination SQL Server.

 

14.  Select the Transfer Method, "Use the SQL Management Object method" if you want a live migration.

 

 

15.  Select a database to copy, you will only need WSS_Content.

 

16.  Configure the properties of Destination Database.

 

17.  Select Objects, you only need Logins here.

 

18.  Configure the package created.

 

 

19.  The package can be run immediately or can be scheduled to run later.

 

20.  To complete the wizard click Finish.

 

21.  Wait till the operation is complete.

 

 

22. Once the operation is completed, go back to SharePoint 2013 Central Administration and set your SharePoint instance to use the copied WSS_Content database. Go to Application Management -> Manage Web Applications.

  

23.  Create a new Web Application.

 

24.  Set the new web application properties.

 

25.  The new Web application is now created.

 

26.  The new web application has to be set to use the copied WSS_Content database. This must be done in SharePoint 2013 Management Shell.

 

27.  Test the database you just copied over by giving this command:

 Test-SPContentDatabase -Name WSS_Content -WebApplication http://YourNewSharepointServer

 

28.  Mount the database by giving the command.

Mount-SPContentDatabase -Name WSS_Content -WebApplication http://YourNewSharepointServer

 

 29.  After the new database is mounted, you need to delete the default WSS_Content database created during the installation process.

  


30.  Choose the default WSS_Content instance, if it's a fresh install usually it's the one with zero site collection items.

  

31.     Select remove, then click OK.

 

32.     Set the Manage Paths.

  

33.     Give the values same as the old SharePoint 2010 instance. 

  

 

34.     The SharePoint site is now upgraded, to get the latest look and feel, in the  pink ribbon on top, click on start now to start upgrade.


35.     Click the "Upgrade this Site Collection" button.

  

 

36.     Next click the "I'm ready" button.

 

37.     After some checks are done, the processing is completed.

38.     If there are any problems they will be shown in next screen. The issues in red have to be fixed before continuing. The orange ones are warnings.

 

39.     Click again on the start now ribbon when all in red are fixed, it will be by a case to case basis. After upgrading the page will refresh automatically.

 

40.     It will show the progress once it is refreshed.

41.     If everything is upgraded correctly the below screen is displayed.

 .

 

Categories: SharePoint

Feedback

Feel free to send us your comments, suggestions and insights on the Netpeach Blog to info@netpeach.com

*These blogs by Netpeach's employees reflect the opinions of the bloggers and may not reflect Netpeach's official opinions.

Netpeach Technologies on Facebook