SharePoint 2010

This topic refers to legacy products, components or features. Therefore, this topic is offered "as is" and will no longer be updated. This topic does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

This topic discusses how K2 integrates with SharePoint 2010 in various topologies, and explains what components are installed on what machines to integrate with SharePoint 2010.

Standalone installations are better suited for low-load environments such as a development or proof of concept environment. Since all components are installed on the same physical server as the K2 Server, there are no credentials passed between servers except to SharePoint Online.

Standalone Install with SharePoint 2010
User Machine N/A
Developer Workstation Client Tools:
  • K2 Studio
  • K2 for Visual Studio
Additional components:
  • K2 smartforms wizards
Single Application Server Internet Information Server (IIS):
  • K2 blackpearl websites and K2 web services
  • K2 smartforms runtime site
  • K2 designer site

Application Server:
  • K2 blackpearl server

SharePoint 2010 CA and WFE Server:
  • K2 for SharePoint 2010

SQL Server:
  • K2 database

All K2 components, IIS, SharePoint, and the database instance are installed on the same physical platform with connection to SharePoint Online if required.

Considerations for Standalone topologies

  • When all K2 components are installed on a single, standalone server there are performance related issues that need to be considered. Although all components on a single machine will mitigate security requirements, there will be an impact on the processing capabilities of the physical machine.
  • If this installation scenario is used for a development or proof of concept environment, it is recommended that additional RAM or a faster processor is used in order to maintain an acceptable level of performance.
  • The SmartForms Design Time and Runtime sites will be hosted on the same site.
  • There are no credentials passed between servers, except if SharePoint Online is being used.
  • Although all components on a single machine will mitigate security requirements, there will be an impact on the processing capabilities of the physical machine. To mitigate these concerns, and if the installation scenario is used for a development or proof of concept environment, it is recommended that additional RAM or a faster processor is used in order to maintain an acceptable level of performance.

K2 blackpearl installations can leverage existing infrastructure, for example installing the K2 databases on an existing SQL server. Alternative, it is common to install the K2 databases on a dedicated SQL server machine. This topology is suitable for smaller environments, such as Development, Test, Training or small-scale Production environments. If scaling for data availability is required, a SQL cluster would be best as this provides a redundant system for data availability.

Separate SQL Server with SharePoint 2010
User Machine N/A
Developer Workstation Client Tools:
  • K2 Studio
  • K2 for Visual Studio
Additional components:
  • K2 smartforms wizards
Single Application Server Internet Information Server (IIS):
  • K2 blackpearl websites and K2 web services
  • K2 smartforms runtime site
  • K2 designer site

Application Server:
  • K2 blackpearl server

SharePoint 2010 CA and WFE Server:
  • K2 for SharePoint 2010
SQL
  • K2 database

All K2 components, IIS, SQL Reporting Services, and SharePoint are installed on one server, and the database are located on a separate server, with connection to SharePoint Online if required.

It is important that the DTC component is configured properly in order for communications between the K2 Server and the SQL Server can function properly.

Considerations for separate SQL server topologies

  • If this installation scenario is used, it performs best as a development or proof of concept environment. It is recommended that additional RAM or a faster processor is used in order to maintain acceptable levels of performance.
  • Distributed Transaction Controller (DTC) must be configured properly for communications between the K2 Server and the SQL Server to function properly.
  • Network connection speed between the Application Server and the SQL server must be as fast as possible with as little latency as possible (physical servers should preferably be on the same Gigabit-backbone.)
  • It is not recommended to geographically separative the SQL Server from the application servers since this can introduce performance issues due to low bandwidth or latency between the K2 application servers and the SQL server.
  • The SQL Server can share physical resources with other SQL databases or SQL Server Instances on the same SQL server, or be located on an dedicated SQL server/instance, or be located on an Azure SQL DB.
    • K2 recommends that SQL administrators track performance of the SQL server and address performance issues through standard Microsoft SQL Server scaling approaches.
  • The SmartForms Design Time and Runtime sites will be hosted on the same site.
  • If you have SharePoint 2010 mode sites in your environment then the K2 components related to SharePoint 2010, (Web Parts and SharePoint Integration), need to be installed on the web front ends that host SharePoint.

A distributed environment consists of separate K2, IIS, SQL, and SharePoint servers. This topology provides scale-out capability as the K2 server is separated from all others which provides scalability.

While it is possible to distribute web components and the application server components on separate machines, for improved performance K2 recommends installing the K2 web sites (including SmartForms sites) and web services on the same physical machine as the K2 application server components, along with host file entries to ensure that communications between the sites and the application server remains on the same physical server. See the "Farm" scenarios for more information.

Distributed Install with SharePoint 2010
User Machine N/A
Developer Workstation Client Tools:
  • K2 Studio
  • K2 for Visual Studio
Additional components:
  • K2 smartforms wizards
Web Server Internet Information Server (IIS):
  • K2 blackpearl websites and K2 web services
  • K2 smartforms runtime site
  • K2 designer site
K2 Application Server Application Server:
  • K2 blackpearl server
SQL
  • K2 database
SharePoint 2010 Server SharePoint 2010 WFE Server:
  • K2 for SharePoint 2010

All of the K2 components are separated out from the SharePoint components, with a separate SQL server.

Considerations for Distributed topologies

  • For better performance, the recommended approach is to install the website components and application server components on the same physical machine, as described in Separate SQL Server and Distributed Environments.
  • The same version of K2 blackpearl must be installed on all K2 servers in the distributed environment.
  • The same version of K2 smartforms must be installed on all IIS servers in the distributed environment.
  • The same version of the K2 for SharePoint app must be installed on all K2 servers/Web servers in the distributed environment.
  • In a distributed environment, K2 Pass-Through Authentication (PTA) or Kerberos is required to pass user credentials between physical or logical servers.
  • Distributed Transaction Controller (DTC) must be configured properly for communications between the K2 Server and the SQL Server to function properly.
  • Network connection speed between the Application Server and the SQL server must be as fast as possible with as little latency as possible (physical servers should preferably be on the same Gigabit-backbone.)
  • It is not recommended to geographically separative the SQL Server from the application servers since this can introduce performance issues due to low bandwidth or latency between the K2 application servers and the SQL server.
  • The SQL Server can share physical resources with other SQL databases or SQL Server Instances on the same SQL server, or be located on an dedicated SQL server/instance, or be located on an Azure SQL DB.
    • K2 recommends that SQL administrators track performance of the SQL server and address performance issues through standard Microsoft SQL Server scaling approaches.
  • Clients access Workspace via the IIS Server operating from the K2 Server. If the user environment expands so that the performance of the K2 Server is affected by the number of users logging onto K2 Workspace, it is advised that the K2 Workspace be relocated to a different server.

The following section discusses the integration of SharePoint within a Farm environment. Due to the extensibility of a farm environment the following is an example of what can be achieved. The addition of extra servers can be done if desired.

For best performance, K2 recommends installing the K2 web sites and web services on the same physical machine as the K2 application server components. Furthermore, when the K2 web sites and services and the K2 application server components are installed on the same physical machine, K2 recommends adding a hosts file entry to force any network communication between the K2 Websites hosted in IIS and the K2 Application server components on the same physical machine to stay within the machine boundaries. Please refer to the K2 Knowledge Base article Modifying the hosts file to improve performance for more information.

Farm Install with separate SQL and SharePoint 2010 Farm
User Machine N/A
Developer Workstation Client Tools:
  • K2 Studio
  • K2 for Visual Studio
Additional components:
  • K2 smartforms wizards
NLB Application Server(s) Internet Information Server (IIS):
  • K2 blackpearl websites and K2 web services
  • K2 smartforms runtime site
  • K2 designer site

Application Server:
  • K2 blackpearl server
SQL
  • K2 database
NLB SharePoint 2010 WFE Server(s)

SharePoint 2010 WFE Server:

  • K2 for SharePoint 2010
SharePoint 2010 CA Server SharePoint CA Server:
  • K2 for SharePoint 2010

Considerations for Farm topologies

  • The K2 Workspace and Web Services, K2 Designer and SmartForms Runtime sites are hosted on a common IIS server. An option is to install K2 Workspace and the K2 Web Services on a separate web server farm. This will lessen the impact of client requests through Workspace on the K2 Application Server. However, it is always recommended and preferred to keep the K2 SmartForms websites on the same physical server as the K2 application server.
  • The same version of the K2 for SharePoint app must be installed on all K2 servers/Web servers in the distributed environment.
  • Distributed Transaction Controller (DTC) must be configured properly for communications between the K2 Server and the SQL Server to function properly.
  • Network connection speed between the Application Server and the SQL server must be as fast as possible with as little latency as possible (physical servers should preferably be on the same Gigabit-backbone.)
  • It is not recommended to geographically separative the SQL Server from the application servers since this can introduce performance issues due to low bandwidth or latency between the K2 application servers and the SQL server.
  • The SQL Server can share physical resources with other SQL databases or SQL Server Instances on the same SQL server, or be located on an dedicated SQL server/instance, or be located on an Azure SQL DB.
    • K2 recommends that SQL administrators track performance of the SQL server and address performance issues through standard Microsoft SQL Server scaling approaches.
  • K2 Pass-Through Authentication (PTA) or Kerberos is required to pass user credentials between physical or logical servers.
  • NLB can be configured by using either the operating system or specific hardware. In either case, NLB configuration should be completed before installing K2 smartforms. When installing components that will be load balanced, the installation must be performed on each machine independently.