Avatar of pepps11976
pepps11976
 asked on

Sharepoint Question (Cost and Alternatives)

We have a Customer that would like the ability to Control Documents etc.
They would also like to be able to show Graphical Charts pulled from SQL Server to show on SharePoint Pages.

Please can somebody Suggest Licence Requirements and Costs that will be needed as I have no idea.

Also I know that share point Foundation is Free but does no have the ability to use Business Intelligence, so if the Cost for them to implement SharePoint Enterprise is to much are there any Alternatives.

Also am I correct in saying that SharePoint Installed on the same machine As SQL does not require a License?

John
Microsoft SharePoint

Avatar of undefined
Last Comment
Rainer Jeschor

8/22/2022 - Mon
SOLUTION
Justin Smith

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pepps11976

ASKER
The customer Already has SQL Installed.

They like the idea of SharePoint for Document Management etc., but they would also like to Build Graphical Charts And Graphs which I assume You need to have SharePoint Enterprise installed??

So I was after an idea of license Costs and if there were any Cheaper alternatives
Justin Smith

To get costs you need to speak to a vendor like CDW or Dell.

If they already have an SSRS instance and have developers to make reports, you can house them in Foundation, you don't need the full version.

However, if they are looking to do any development or drill down within the browser, they will likely need the full Enterprise edition
Shaun Kline

Just add clarification, SharePoint Foundation (at least the 2010 version) has specific requirements for the server it is installed on and the SQL Server that it interacts with. The server that will run SharePoint must be at least Windows 2008 R2 64-bit or greater and paired with SQL Server 2008 R2 on a 64-bit server (or greater). To my knowledge, SharePoint will not work with an Express version of SQL Server. Also, take are to read the licensing for SQL Server as you may incur CAL requirements, both for SQL Server and the Windows machine running it.

You can also build custom pages / components for SharePoint using Visual Studio, but this is not as simple as doing web page development.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Justin Smith

pepps11976

ASKER
So just to clarify then, You cant show nice Bar Graphs etc using the Foundation Version?

JOhn
Justin Smith

You can display a static report that was made in SSRS, sure.  But if you are looking to create stuff in the browser based on data in SharePoint (Performance Point), you will need full version.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
pepps11976

ASKER
Ok Thanks so by Saying Static Foundation would not be able to automatically update it without user integration?

Or do you mean Static as in no Drill Downs?

John
Justin Smith

No real drilling.  Also, everything would be designed outside of SharePoint.
pepps11976

ASKER
So is there a Web App Or something to plug Into sharepoint?

And will it be able to be Real Time?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Justin Smith

It's called the SSRS add-in.  Download and install on web servers.

I do not believe it's real time.
ASKER CERTIFIED SOLUTION
Rainer Jeschor

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.