Ian Woodgate is Managing Director of PointBeyond Limited, the UK’s leading SharePoint Business Application specialists. Ian has a background in financial services and and IT. He has worked with SharePoint since its first release as a developer and subsequently as a solution architect. Ian regularly speaks at events around the country, focusing on the subject of delivering business applications using SharePoint, and recently wrote PointBeyond’s white paper ‘Delivering Maximum Business Value With A SharePoint Based Application Strategy’. He also runs the SharePoint UK user group meetings in Southampton. You can contact Ian at firstname.lastname@example.org or follow him on twitter @IanWoodgate.
This is the first of a series of articles in which we discuss how you can use InfoPath 2010 to quickly create and deploy business applications in the cloud with SharePoint Online, part of the Microsoft Office 365 platform. We’ll show how to publish a simple InfoPath form to SharePoint Online, and future articles will build upon this example.
For those not familiar, InfoPath is a Microsoft application that allows users to easily create and publish forms for collecting structured information. The InfoPath application ships with Microsoft Office Professional 2010, and is also available for separate purchase.
InfoPath solutions can be created by both developers and IT professionals, as well as tech-savvy business users such as analysts and information workers. Users can take advantage of the powerful combination of InfoPath and SharePoint 2010 to quickly create complete browser based applications without the need for custom code.
InfoPath ships with templates for common business forms such as Absence Request, Change Order, and Status Report. You can extend the sample forms or create new forms from a blank canvas.
InfoPath allows you to add business rules to validate data being entered (e.g. data must be a number) or to allow data entry on certain conditions (e.g. only an approver can view the approvals section). Rules are added using menus and configuration, so no coding is required, though InfoPath does support custom coding to enable more advanced customisations. Information that is collected when forms are filled out is saved as XML.
You can add your own custom branding and formatting so that your forms reflect your overall corporate style. And you can interact with data located on premise or in the cloud by creating connections to SQL Server, Access, web services, or SharePoint lists.
When forms are published to SharePoint, InfoPath Forms Services, a component of SharePoint 2010, renders them as HTML web forms, so end users do not require any extra software in order to access forms and submit data. Browsers supported by InfoPath Forms Services includes Internet Explorer 7 and upwards, as well as other modern browsers such as Google Chrome and Apple Safari.
It’s no secret that with InfoPath and SharePoint, you can quickly create and deploy business applications without the need for custom code and long, costly development cycles. Perhaps less known is that you can get the same benefits with Office 365 and SharePoint Online. You do need Office 365 plan E3 or E4, or SharePoint Online (Plan 2) if you want your forms to be browser enabled though, since only these plans include InfoPath Forms Services.
InfoPath forms provide more than enough power for creating data-focused applications such as absence reporting, expense approvals, and IT help desk requests. You wouldn’t want to use InfoPath and SharePoint to replace your current ERP system, but the combination is more than acceptable for a wide range of basic applications that are on most organisations’ development backlogs.
Let’s have a quick look at how to create, publish, fill, and submit a simple InfoPath form. In this demo, we’ll use a basic purchase order request form with a simple approval process. For the purposes of this article we have kept the form self-contained and it is therefore very simple. There are many ways in which it could be extended, some of which will be mentioned later.
The form used in this demo can be downloaded from here, along with instructions on the changes that are needed for deployment to your environment or SharePoint online site.
Using the InfoPath Office client we have placed controls on the form to enable the capture of the following information:
The form allows the application of sophisticated rule-based validation and formatting options. These can all be seen on the downloadable form. For example, the Request Approval section is configured to only be displayed when the form has been submitted for approval and is only shown to the specified approver.
The form is shown open in InfoPath below. The data structure and the rules applied to the ‘Submit for Approval’ button can be seen:
Before attempting to publish the form go to site settings in SharePoint and ensure you have the ‘SharePoint Server Enterprise Site Collection features’ feature activated under Site collection features. Also be sure to make the changes in the instructions that accompany the download.
Once the form is ready you can publish directly from InfoPath to your Office 365 SharePoint site. This will create a new form library in your chosen site. From the File menu in InfoPath, select the Publish tab. Click on ‘Publish form to a SharePoint Library’:
In the publishing wizard, enter the URL to your Office 365 SharePoint site and click ‘Next’:
Enter your Office365 credentials:
In the next screen ensure the ‘Enable this form to be filled out by using a browser’ checkbox is selected and select the Form Library radio button, then click ‘Next’:
In the next screen, choose to ‘Create a new form library’ to host your form or update the form if you have an existing Form Library:
Enter a suitable name and description and click ‘Next’:
Click ‘Next’ on the following screen leaving values as default:
Click ‘Publish’ on the summary screen:
The form is now available at the SharePoint Online address specified. InfoPath Forms Services will render the form as HTML, so that users can fill it in from their browser. When viewing the Form Library, clicking on the ‘Add document’ link will open the form in the browser. A user can now fill this in and submit it:
Once submitted the approver can open and review the form in a read-only view and approve/reject as appropriate:
If a form has been submitted and a non-approver attempts to open the form, the rules result in the following view being displayed:
This example demonstrates the power that InfoPath and SharePoint Online provide to quickly create form-based business applications in the cloud. This example, while quite basic, could easily be extended to accommodate more real-world scenarios. For example, you could:
We hope that this simple example demonstrates how you to quickly build and publish powerful business applications on the SharePoint Online platform using InfoPath and without needing custom code.
In a future article, we will present more advanced features such as additional workflow capabilities and integration with web services and SQL Azure data.
Chris Testa-O'Neill is a Senior Consultant for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, sole author of the MCTS SQL Server 2008 Microsoft E-Learning courses and technical reviewer for SQL Server 2012 BI Official Microsoft courses for Microsoft Learning. He is heavily involved with the SQL Server community as a speaker and an organiser of SQLBits, a Regional Mentor for SQLPASS and he runs his own user group in Manchester, UK. As well as being certified as a SQL Server MCDBA, MCTS and MCITP in all tracks.
This blog is part two of a series of blogs about implementing a SQL Server 2012 highly available BI environment. Part one can be found here
Three worlds to consider when embarking on this journey is:
To setup a SQL Server 2012 highly available BI environment you should establish the hardware and software that is required to support the architecture. As stated in the first blog, you may have to liaise with another team in order to resource these servers. Understanding the requirements will help you have meaningful conversations with the right people. The software includes:
So what is the end game? In this example we are assuming that your organisation has a requirement to use PowerView and/or PowerPivot for SharePoint. This software and hardware is collectively used together to create the following environment.
Network Load Balancer Layer
The Network Load Balancer (NLB) layer is there to accept client requests for a SQL Server 2012 Business Intelligence feature such as PowerView or PowerPivot for SharePoint that is hosted within a SharePoint 2010 farm. These requests are then directed to the first available web front end server to service the request. You should first establish with the network infrastructure team if a NLB already exists. Making use of an existing NLB will speed up the deployment of this infrastructure and can be managed by the infrastructure team. Should you require a NLB, Windows 2008 R2 Server or a hardware based solution can be used to fulfil this requirement. It is important to ensure that the NLB contains dual network cards that provides resilience should one card fail.
Conversations with the infrastructure team should also establish the IP address of the NLB. This is important as this address will be used to map to the hostname address that is decided for the SharePoint Farm which is discussed later in this article.
A second aspect that should be explored is the capability of the NLB to “probe” the web front end servers. “Probing” is a feature of NLB that is used to check the availability of servers that the NLB is directing requests to. The NLB will check to see if a server is available before forwarding requests to it. Should “probing” be employed on the NLB, make sure that the NLB does not just check for the availability of the Windows server. There could be a situation where Windows is working fine, but the SharePoint software installed on the web front end server has stopped. Check with the infrastructure team to see if the NLB can probe for the existence on running services such as SharePoint Foundation Service or other services so that there is a more realistic test of availability.
Web Front End Layer
The SharePoint Web Front End (WFE) is the layer between the applications that are stored in the SharePoint farm and the client requests to the applications. The WFE will direct requests for SharePoint services to the appropriate application server. A minimum of two WFE servers are required to facilitate a High Availability BI solution and the recommended hardware requirements for the WFE layer are:
Ensure sufficient space for the base installation and additional space for diagnostics such as logging, debugging and creating memory dumps.
The following software should be installed on each of the Web Front End servers
Additional WFE servers can be added to support higher concurrent connections to the SharePoint Farm or to provide dedicated servers for specific services such as Reporting Services or SharePoint Search Service.
Although WFE servers can be setup on dedicated hardware, they are typically setup within Hyper V. The key point when virtualising the servers is to ensure there is enough resources to host the virtual machines that are to be used within the virtualised environment. The virtualised environment can also have its own availability features to provide further resilience. Discuss these options with the team responsible for managing virtualised environments.
The application layer hosts the applications that are consumed by users of the SharePoint farm. From a SQL Server perspective this will include SQL Server Reporting Services, PowerPivot for SharePoint and Powerview. For the purpose of this article, a minimum of two application servers will be required to provide high availability. This is achieved by duplicating services on each server. It should be noted that you can add additional application servers for non-high availability reasons. An example could include offloading an application to a dedicated server that requires more power than other services. So you should consider which services require high availability and which services that do not.
The recommended hardware requirements for the application layer are the same as the WFE:
Note that you may require additional resources dependent upon the services you run on the application servers. As an example, the Visio Graphics Service in SharePoint may require additional memory should this be extensively used.
The following software should be installed on each of the application servers
Like the Web Front End layer, the application layer can too be virtualised and should be resourced appropriately to ensure the application servers do not suffer from resource contention
SharePoint Database Backend Layer
The SharePoint Database backend layer is used to host the SharePoint configuration databases from the SharePoint Farm. At the time of writing it is not clear if these databases can be stored or supported using SQL Server 2012 Always On availability groups. As a result the SQL Server Instance on which the SharePoint databases are installed can use an Active Passive cluster to ensure high availability. Keep an eye out for developments in this area.
Also ensure that the firewall ports are opened up to enable inbound communication from the SharePoint Service. As applications are installed and enabled within the SharePoint farm, SharePoint will create databases within the SharePoint backend layer.
While not strictly within the scope of the high availability BI infrastructure, you should make a note of all the Database Engine, Multi-Dimensional and Tabular SQL Server instances and the associated service accounts that Reporting Services, PowerPivot and PowerView will use as data sources for the creation of reports. This will become important should you enable Kerberos authentication and delegation within the SharePoint farm, discussed in part three of this series.
For a complete high availability solution, you should also ensure that the identified data sources are also configures in a highly available solution. Otherwise the data sources could be the source of a loss of service that reflects badly for the BI environment
What’s in a name?
To use features such as SQL Server 2012 Power View, there is a requirement to setup a SharePoint 2010 SP1 Farm. If your organisation does not have one already, give serious consideration to the url name that the users will type in a web browser to access the SharePoint environment. This is a decision that you will want to involve the business in as well. The name should reflect the purpose of the environment. As many of my engagements involve setting up a BI platform, customers will choose a name such as CompanyBI, an example being coeobi. Ultimately, this means that the users will type in http://coeobi in order to access to SharePoint 2010 platform.
From a technical perspective, the name must be registered in Domain Name Services (DNS) so that communication can happen seamlessly within your infrastructure. DNS is a name resolution service. Its primary purpose is to resolve a hostname to an IP address, similar to searching for the telephone number for an individual within a telephone directory. There are many other features that can be discussed about DNS. There is however a key point that is very important to the setup of your SharePoint name in DNS.
Ultimately the name you have chosen for your SharePoint Farm, in our example coeobi, must be mapped to the IP address of the Network Load Balancer. When discussing the creation of the DNS record, stress to the infrastructure team that the DNS record registered is either an A Resource Record that maps the name to the IP address if using IP version 4 or an AAA Resource Record that maps the name to the IP address if using IP version 6. Experience has shown that an assumption is made to create CNAME Record in DNS instead. This causes problems within the SharePoint farm in terms of authenticating users as the Kerberos protocol does not work well with CNAME records.
So in summary the following points should be established to get the foundation of the high availability BI farm up and running
In part three we will look at the impact of Active Directory and Kerberos on a high availabilty architecture
Until the end of June 2012, Microsoft Learning are offering IT Professionals the opportunity to maximize their investment in current Microsoft Certifications with a 2-4-1 offer on exam vouchers.
When you purchase and take a qualifying exam for a current Microsoft product between April 11, 2012 and June 30, 2012, you will be emailed a voucher valid for the next version exam of your chosen technology path, at no additional cost.
The offer covers the following Microsoft Technologies:
Next Version Product
Windows Server 2008
Windows Server 2012
SQL Server 2008
SQL Server 2012
For more information and to request your voucher(s), please click here.
Chris Testa-O'Neill is a Senior Consultant for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, sole author of the MCTS SQL Server 2008 Microsoft E-Learning courses and technical reviewer for SQL Server 2012 BI Official Microsoft courses for Microsoft Learning. He is heavily involved with the SQL Server community as a speaker and an organiser of SQLBits, a Regional Mentor for SQLPASS and he runs his own user group in Manchester, UK. As well as being certified as a SQL Server MCDBA, MCTS and MCITP in all tracks. Chris is also a Microsoft Certified Trainer, and a Microsoft Certified Systems Engineer in Windows 2000 and Windows 2003. In his spare time Chris loves playing in a band as a guitarist/lead vocalist. You can contact Chris at email@example.com or on twitter as @ctesta_oneill.
Over the last 5 years I have observed Microsoft persevere with the notion of Self Service BI over a series of conferences as far back as SQLBits V in Newport. The release of SQL Server 2012, improvements in Excel and the integration with SharePoint 2010 is making this a reality.
Business users are now empowered to create their own BI reports through a number of different technologies such as PowerPivot, PowerView and Report Builder. This opens up a whole new way of working; improving staff productivity, promoting efficient decision making and delivering timely business reports.
There is, however; a serious question to answer.
What happens should any of these applications become unavailable? More to the point, how would the business react should key business users be unable to fulfil reporting requests for key management meetings when they require it? While the introduction of self-service BI will provide instant access to the creation of management information reports, it will also cause instant support calls should the access to the data become unavailable.
These are questions that are often overlooked when a business evaluates the need for self-service BI. But as I have written in other blog posts, the thirst for information is unquenchable once the business users have access to the data. When they are unable to access the information, you will be the first to know about it and will be expected to have a resolution to the downtime as soon as possible.
The world of self-service BI is pushing reporting and analytical databases to the tier 1 application level for some of Coeo’s customers. A level that is traditionally associated with mission critical OLTP environments. There is recognition that by making BI readily available to the business user, provisions also need to be made to ensure that the solution is highly available so that there is minimal disruption to the business.
This is where High Availability BI infrastructures provide a solution.
As there is a convergence of technologies to support a self-service BI culture, there is also a convergence of technologies that need to be understood in order to provide the high availability architecture required to support the self-service BI infrastructure. While you may not be the individual that implements these components, understanding the concepts behind these components will empower you to have meaningful discussions with the right people should you put this infrastructure in place.
There are 7 worlds that you will have to understand to successfully implement a highly available BI infrastructure
1. Server/Virtualised server hardware/software 2. DNS 3. Network Load Balancing 4. Active Directory 5. Kerberos 6. SharePoint 7. SQL Server
I have found myself over the last 6 months reaching out to knowledge that I learnt years ago when I studied for the Windows 2000 and 2003 (MCSE) Microsoft Certified System Engineer. (To the point that I am resuming my studies for the Windows Server 2008 equivalent to be up to date with newer technologies). This knowledge has proved very useful in the numerous engagements I have undertaken since being at Coeo, particularly when dealing with High Availability Infrastructures.
As a result of running my session at SQLBits X and SQL Saturday in Dublin, the feedback I have received has been that many individuals desire to understand more of the concepts behind the first 6 “worlds” in the list above.
Over the coming weeks, a series of blog posts will be put on this site to help understand the key concepts of each area as it pertains to a High Availability BI Infrastructure. Each post will not provide exhaustive coverage of the topic. For example DNS can be a book in its own right when you consider that there are so many different configuration options with Forward Lookup, Reverse Lookups, AD Integrated Zones and DNA forwarders to name some examples. What I want to do is share the pertinent points as it pertains to the BI infrastructure that you build so that you are equipped with the knowledge to have the right discussion when planning this infrastructure.
Next, we will focus on the server infrastructure that will be required to support the High Availability BI Infrastructure, from both a physical box and virtualised perspective.
For those of you who haven’t yet heard. The Windows Azure conference is coming up and if you building or considering building applications for the cloud, then the 22nd June is a date for your diary.
It’s a big day for Windows Azure as it will be the first full day, multi-track conference supported by Microsoft and London Windows Azure User Group, featuring content for .NET, PHP, Java and node.js developers as well as device support in Windows 8, iOS, Windows Phone and Android.
Not to be missed is the keynote speaker Scott Guthrie, the Microsoft Corporate Vice President in charge of the development platform for Windows Azure.
Tickets are free until 20th May so get them whilst you can.
Register for the conference here: http://azureconference2012.eventbrite.com/
Due to popular demand we will be running 2 versions of the Windows Azure Bootcamps online! This is a great opportunity for those of you who were interested but unable to attend the live Windows Azure Bootcamps or anyone else who is interested in learning more about building applications on the cloud.
The Windows Azure Online Bootcamp will take you from knowing nothing about the cloud to actually having written some code, deployed it to the cloud service and made a simple application available on the public Internet.
There are 2 options for you to choose from:
One day session on the 21st May 2012 – Register now at http://aka.ms/azureonedayonline
Lunch time multi-day session from the 22nd – 25th May 2012 – Register now at http://aka.ms/azureonlinemultiday
During the Online Bootcamp there'll be experienced people available online to guide you through each exercise. Once you have the basics in place, you'll be up and running.
After much deliberation and over 20 entries, the judges have reached their decision in our ‘Convince your boss to send you to TechEd’ competition. You offered countless brilliant suggestions that would undoubtedly have resulted in a ticket to Amsterdam, as well as some beer-focused ones that we’re not sure would quite wash! But in the end there can only be one winner of our ticket to TechEd Europe in June, and that winner is…
Many congratulations to Patrick who will soon be joining us at TechEd in Amsterdam for a packed week of sessions and hopefully taking lots back to his business as a result. The judges particularly liked that his entry was very current, taking into account the financial pressure that we’re all seeing at the moment. Not only that, we loved his plan to use the trip away as a proof of concept for implementing DirectAccess, here’s hoping it works like a dream! Check out Patrick’s full entry below.
“My boss always wants us to do more for less, including less training budget >:/
Well I say to him that, same as in previous years, attending TechEd means I can do lots more for much less as a week spent at TechEd is worth at least two weeks spent in more traditional classroom environments. The event format enables me to pick & choose the content relevant to my/our business needs and interests, as well as providing access to a unique combination of Microsoft & industry experts, interactive sessions and hands-on labs.
On top of this, the location means it makes economic sense as well (MMS being in Vegas does stretch credibility a bit ;)
Besides, I can still be productive while I'm there as it'll be a perfect opportunity to prove our upcoming DirectAccess implementation!”
Of course Patrick wasn’t the only person that impressed us, oh no. In fact we were so impressed that we picked out an additional runner up because it was just too close to call! Second place goes to Samuel Roach, who will be receiving a shiny new Nokia Lumia 800 Windows Phone. The judges were impressed with his enthusiasm for cloud computing and that he was actively promoting Office 365 to customers, as well as the fact that he was already taking part in our IT Camp events.
“As we're a small IT solution provider whose customers are mostly on the various versions of SBS, it's easy to become complacent and think we don't need to take a serious look at Hyper-V & the cloud in general. Unfortunately, sometimes it's easy to think cloud solutions like Office 365 aren't relevant for our small clients. However, my boss' interest in persuing cloud solutions began to change not only when one of our clients (though one we didn't mind losing) switched providers in favour of a cloud solution but also when he received an unexpected cheque in the mail for being the Partner on record for an Office 365 client I set up! Surprise!
Today, I'm at a Microsoft IT Pro Camp showcasing Hyper-V, SCVMM and other virtualisation solutions and realising just how many tools Microsoft has out there to make creating and managing VMs so much easier, efficient and flexible. Tools such as the Microsoft iSCSI Software Target and other remote management tools either built into Windows Server 2008 R2 or Windows 7, or readily available and free from Microsoft online.
When I get back to the office tomorrow and show the boss some of the things we can do with Microsoft tools to make our jobs easier and cut down on time spent on the phone with client issues, he'll have to send me to Microsoft Tech Ed. Maybe this would be a good time to get another client up and running on Office 365 so he gets another [surprise] cheque in the mail! :-)”
Third place and the lucky recipient of a bag of Microsoft Swag is Martin Milne! We were thrilled to see that he’s pushing full adoption of Microsoft technologies in his business and actively updating their legacy applications. His willingness to use underhand tactics also made us laugh, and would definitely convince his boss to send him to TechEd!
“My employer has just moved from Lotus Notes to the Microsoft Platform. I would use the sense of unease with the technology and simply advise them of the benefits of TechEd. Complete immersion in MS technologies that would provide the starting point for building fantastic solutions with the product suite.
Failing that the Christmas office party photo's may be used as leverage. Let's hope it doesn't come to that.…”
Our runner up was Randy Perkins, who will be receiving a mini swag bag for his entry. He highlights what a great networking opportunity TechEd is and how there is so much you can learn not only in the sessions but also through talking to others who may have been in the same position as yourself.
“Being a contractor means I am my own boss. When justifying training I have to not only think of the cost of the course but the lost income if I attend one. So I would convince myself by saying it is one of the best IT related networking and training events in the world. One that will enable me not only to learn about a wide range of products but understand the vendor space that helps fill the gaps. Also I will able to discuss challenges with likeminded people who may have been in my position.”
Thanks a lot to everyone who entered, we really enjoyed reading through all of your very persuasive arguments, if we had our way we’d send you all to TechEd! Unfortunately we can’t do that, but at least you can now pinch our winners’ ideas for the next time you pitch a trip to your boss. Good luck!
Robert Chapman is CEO and co-founder of Firebrand Training. The fastest way to learn since 2001.
Microsoft has announced a fundamental change to its certification program, heralding a ‘return’ for the MCSE, MCSA and MCSD certifications.
Microsoft has introduced a set of ‘new’ certifications, to meet the growing skills gap in the technology industry. There will be no more MCITP, MCTS and MCPD certs released in the future – but they remain current and relevant in the meantime. These will be replaced with MCSE, MCSA and MCSD certifications. These familiar acronyms are back, but now have a slightly different meaning:
What it meant before
What it means now
Microsoft Certified Systems Engineer
Microsoft Certified Solutions Expert
Microsoft Certified Systems Administrator
Microsoft Certified Solutions Associate
Microsoft Certified Solution Developer
Microsoft Certified Solutions Developer
All future Microsoft exams will be technology- and version-specific, and will lead to the new certifications. The new certs are version-neutral, but they will expire - at least every three years.
Learn What’s Hot and New in Windows Server 2012!
A Microsoft Windows Server 2012 Community Road show event will show you how to:
The primary audience for this event is IT Professionals and partners who are excited about the upcoming release of the Windows Server 2012 technology.
This event will showcase presentations and demos from Microsoft MVPs on the following topics
Storage and Availability
If you’re interested in attending or you would like to share this information with your user group or add it to your blog or Twitter, please use this link https://ws2012rocks.msregistration.com/
London, Thursday 14th June 2012 – 17:30 – 21:15 with Damian Flynn , Aidan Finn , Alex Juschin – Click To Register
Edinburgh, Friday 15th June 2012 – 13:00 – 17:10 with Damian Flynn , Aidan Finn , Alex Juschin – Click To Register
Become a ‘Cloud Ninja’ and help lead your IT organisation to the cloud, by obtaining Microsoft’s new flagship certification, the Microsoft Certified Solutions Expert (MCSE). These certifications recognise those IT professionals who have broad and deep skill sets across whole Microsoft solutions. The Microsoft Certified Solutions Associate (MCSA) is the certification for aspiring IT professionals and is also the prerequisite certification necessary to earn an MCSE, while the Microsoft Certified Solutions Master (MCSM) is the ultimate destination for the most experienced MCSEs.
Securing these essential technical skills will allow you to grow your career and make yourself indispensable as the industry shifts to the cloud. For more information about how Microsoft Certifications have been reinvented for the cloud, watch this video.
Are you ready to test your skills against our experts? Here’s your chance! Get your 2 for 1 certification exam offer now. It’s only open until the 30th June so what are you waiting for!