FAQ
Q. How does the SharePoint CRM and SRM lists communicate with SQL Server?
A. We leverage and expand upon what SharePoint provides. SharePoint is much, much more than just lists and data. Microsoft has spent millions of dollars and a decade on creating a customizable framework that allows development companies like ours to provide a completely usable out-of-the-box application that can also be customized by clients. The CRM and SRM communicate with SharePoint communicates with .NET, which in turn communicates with SQL Server.
Q. Is there any issues running SharePoint CRM or SRM over HTTPS?
A. You configure authentication for Web sites based on Microsoft Windows SharePoint Services by configuring authentication methods in Internet Information Services (IIS). Windows SharePoint Services uses the authentication method you specify for a virtual server in IIS to control authentication for all top-level Web site and Subsites of that virtual server. Windows SharePoint Services works with the following authentication methods in IIS:
• Anonymous authentication
• Basic authentication
• Integrated Windows authentication
• Certificates authentication (SSL)
You can change authentication methods for virtual servers hosting Web sites based on Windows SharePoint Services, and you can change the authentication method used for the SharePoint Central Administration site. You can also enable Secure Sockets Layer (SSL) security in IIS to help protect your sites or the administration port for your server.
Q. Should SharePoint be installed in a farm or standalone?
A. SharePoint can be installed on a Stand-alone server (and the CRM Application can in turn run very well in this setup), however, on a mission critical corporate install a Server farm is more desirable for two main reasons: redundancy and throughput. The Topology of most farms has TWO Web servers and One Back-end SQL Server; this along with a good backup solution will suffice for most corporate needs.
The only drawback other than the extra hardware and software costs is the fact that CRM and SRM updates must be applied to both servers at the same time.
All these options will have to be measured against expected user activity.
Q. What should i know about list scalability?
A. List scalability is a hot topic in the WSS/MOSS arena, and for good reason. Pretty much everything in SharePoint is stored in a list. Knowing if you're likely to hit a wall with scalability is a proactive step that can save you a lot of time down the road (and help you decide if a List is an appropriate container in the first place).
RULES OF THUMB-DATA
When it comes to putting a tone of data into a SharePoint list you may wish to consider the following guidelines:
1. No more than 2000 items per view/container. That could be 1900 items and 100 folders but either way, no more than 2000 per view. A folder is an example of a container, so it is the "root" level of a list.
2. No more than 5 million items per list.
3. No more than 2000 lists per sub site (SPWeb).
Copyright © 2012 LookOut Software Inc. All rights reserved