We help IT Professionals succeed at work.

Sharepoint Question (Cost and Alternatives)

pepps11976
pepps11976 asked
on
328 Views
Last Modified: 2014-01-13
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
Comment
Watch Question

Justin SmithSr. System Engineer
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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 SmithSr. System Engineer
Top Expert 2012

Commented:
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 KlineLead Software Engineer
CERTIFIED EXPERT

Commented:
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.
Justin SmithSr. System Engineer
Top Expert 2012

Commented:

Author

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

JOhn
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
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.

Author

Commented:
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 SmithSr. System Engineer
Top Expert 2012

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

Author

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

And will it be able to be Real Time?
Justin SmithSr. System Engineer
Top Expert 2012

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

I do not believe it's real time.
CERTIFIED EXPERT
Most Valuable Expert 2013
Awarded 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.