Part 3 of 3 in the SharePoint Server 2013 Advanced Solutions (70-332) series. This series focuses on the planning and implementing phases of all aspects of SharePoint 2013. This course is intended for advanced users who are looking to gain knowledge for the 70-332 exam. We will start with a bare bones environment, and begin to build and plan through SQL, SharePoint, and the Services, until our entire environment is configured; based on our demo company, Globomantics, requests.
Create and Configure a Secure Store Application Hi, and welcome back. In today's lesson what we're going to do is we're going to go over Create and Configure a Secure Store Application. This one's going to be a fairly short one today. Good news it's also a very important one. So we'll talk a little bit about it, but one of the things I wanted to hit right off the bat before I jump into slides, is you're going to hear me go back and forth between Secure Store Application and Secure Store Service. Now Secure Store Service is the service that's going to be running the Secure Store. The Secure Store Application, however, is the application that we're going to be using for our web application. Now if you remember way back, I know, I said it a lot, but it's getting farther back as we go along now, the Secure Store was set up on our application server. We already turned around and load balanced and moved things around, so at least we know where it is. Let's go check out what is this Secure Store Service that we're utilizing?
Create and Configure a Business Connectivity Service Hi, and welcome to today's lesson, and today what we're going to do is we're going to go over Create and Configure a BCS, Business Connectivity Services. So before we start talking about it, let's jump to the next slide and talk about what actually is BCS. So BCS, Business Connectivity Services, it allows us to pull information from other databases into SharePoint. And I want to define that for a moment, because when I say databases, we should be saying data sources. Now, databases is what we're going to hear all over the internet, and when we start looking at different books and things like that, we're going to see that it's about connecting to other databases and bringing that information in, but the truth is, it's only limited by us being able to map to it. To make the proper calls to pull that information in so that our columns and our rows are set equally. That way we can have our data brought in. So, databases sounds right, and that's what we normally think about when we think about these tables, but it doesn't have to be that. It can be any type of a data source that we can make the call to, to map it back to us to specific columns. So as long as we can set the model up to grab these, we're fine, we can bring in pretty much anything. Now there are certain databases, like Oracle, for an example. Oracle needs some modifications to be done because the way the calls are, but something like SQL, we can connect to it right out of the box, and map literally column for column, and choose which ones we want. These are both great in their own sense, but what else can I map to? Well, I can map to pretty much any database, I can map to a MySQL, I can get out there and map to a DB2, I could even, using the ADO/DAO calls, go over to a Jet Database. I mean, there's just a ton we can go, but before we talk about what we're going to do with these, we're going to sit down and we're going to talk about what are the scenarios for BCS, where do we use this?
SharePoint Solutions and Applications Hi, and thanks for joining me for today's lesson. What we're going to do today is we're going to go over SharePoint Solutions and Applications. Now if you remember back in lesson 16, we were talking about applications. And when we're talking about them, we turned around and we said that App Stores are new in 2013, and Solutions are deprecated. So I want to take a moment and just talk about Solutions, because of what we had talked about in 16. This is what I want to get through to everybody. SharePoint Solutions are now considered to be deprecated, but that doesn't mean they're gone. They're not gone. They still have purposes and fulfill specific needs. What this means in short is they're still there, it's all there. It's not just gone, Apps didn't just take over. They're considered deprecated, and deprecated is kind of a warning, we're not going to be upgrading them and there's a good possibility in the next version that they're going to go obsolete. So they're still here, we can still use them, and for those of us who are coming from SharePoint 2010 into the 2013 environment, we're not at a total loss. Now there are some times we're going to have to go into the Manifest and we're going to have to change and and tell it's a SharePoint version 15 and so on and so forth, but all in all, the Solutions themselves are still going to function as they functioned in 2010. Now, that doesn't mean that everything's going to work peachy keen and beautiful. I don't want to give you these illusions that it's all butterflies and unicorns when we bring this over. It's not. Just like everything else, when we upgrade, we're going to run into those nuances that turn around and basically kick us in the rear-end. We can't help that. That's part of upgrading, but the fact that Solutions still exist, still gives us some hope that we can run server-side code. So, I want to take a moment to talk about the Solutions themselves.
Plan and Configure PerformancePoint and PowerPivot Hi, and welcome to today's lesson. What we're going to be going over today is two features out of the BI. And by BI I mean Business Intelligence. The two we're going to look at is PerformancePoint and PowerPivot, and we're going to talk about planning and configuring these two. Now, one thing that these two have in common is they really both create some great dashboards for us, and dashboards are extremely important because they get our information out to the users as fast as possible. Let's break these apart for a moment and go over each one separately. Let's start with PerformancePoint.
Plan and Configure Reporting Service with PowerView Hi, welcome to today's lesson. What we're going to go over today is we're going to go over Plan and Configure Reporting Services with PowerView. Now, when I talk about Reporting Services PowerView, I want to actually split these two into two little separate groups for a moment. Now I want to talk about reporting services first, because this is the big guy of it all, this is the one that goes out there and does all the hard, heavy lifting. So let's talk about Reporting Service for a moment. So, what is Reporting Service? Well, the Reporting Services inside of SharePoint 2013, they basically sync directly to the SSRS, the SQL Server Reporting Service, and this allows us to use all the benefits of creating and configuring reports. We've got a lot of built-in tools, we've got APIs for Visual Studio projects, it becomes one of the most effective reporting systems possible, and this is because we can literally take the data, bring it into Visual Studio, and decide how we're going to parse that data. Are we going to be putting an algorithm on that data? What are the results going to be? So you can see we can grab mass amounts of data, and we can literally bring it down to exactly what we need. Now one new thing inside Reporting Services is that Reporting Services now runs as a SharePoint Shared Service instead of a Windows Service. So before we go talking about anything else, we can see that Reporting Service basically allows us to reach out, grab data, parse that data as we see fit, attach any algorithms we want to it, and get back the results we want, but there's no way to view it. We need to be able to give this to the end user in a way that they can see it, and that they can manipulate the data, which is easy for them. So that's where PowerView comes in. So let's jump over, and we're going to talk about PowerView for a moment.
Conclusion Well I want to say welcome back to your next lesson, I really do, we've said that a lot of times, but I can't. You did it. You've come to the conclusion. You've made it through absolutely everything. You made it through 25 lessons to get to this, and the only thing I can really say at that point in time is congratulations! You sincerely deserve this, you should be impressed with yourself, I'm impressed with you. If you made it through all 25 lessons, you wouldn't believe how many services, that's thousands of settings, the nuances we've discussed. That's just a lot of information, and you made it all the way through it to this end. I'm extremely impressed. So congratulations for doing that. Now there are a couple of things I just want to do which is kind of cross our T's and dot our I's that I want talk about for a moment, but the first thing I want to do is I want to go all the way back to the beginning.