RSS Feed
Latest Updates
New SharePoint Permissions Guide
Posted by Lightning Tools Support on 21 September 2016 11:34 AM

Our SharePoint Permissions Guide is back, updated for SharePoint 2013/2016!

Check it out at

It's a great resource for Site Collection Administrators and Site Owners especially!

Read more »

Product Tutorials
Posted by Lightning Tools Support on 03 July 2016 04:17 PM

We've recently added a Tutorials area to our website!

Tutorials are quick videos - most are under 5 minutes - which show you how to perform a specific task using one of our products.

Tutorials Home Page

DeliverPoint tutorials - permissions reporting and management

Lightning Conductor Web Part tutorials - content rollup

Lightning Conductor Add-in tutorials - content rollup for SharePoint Online

BCS tutorials - external data connections

SharePoint Chart tutorials - data visualization

Social Squared tutorials - discussion forum

Data Viewer Web Part tutorials

We'll be adding new tutorials all the time, so if you have a request for something you'd like to see, please email, and we'll work on providing it for you.

Read more »

SharePoint Permissions Management webinar
Posted by Sandy Ussia on 08 March 2016 09:50 PM

Please check out Brett Lonsdale's one-hour webinar about SharePoint Online Permissions Management good practices: - recorded March 8, 2016. The webinar includes a 10-minute demonstration of the Lightning Tools DeliverPoint Add-in at the end.

Read more »

Feature Requests
Posted by Lightning Tools Support on 06 January 2015 06:58 PM

Have an idea for a feature for one of our products?

Submit your idea, and we will review them each month. If we like your idea and it will benefit many of our customers, we will build it into the product.

Click here for the entry form!


Read more »

Lightning Tools to offer Business Connectivity Services SAP
Posted by Lightning Tools Support on 09 June 2014 01:02 PM

Lightning Tools has provided tools and web parts for SharePoint Business Connectivity Services (BCS) and the Business Data Catalog (BDC) since Microsoft Office SharePoint Server 2007 (MOSS 2007) was introduced. Currently Lightning Tools offers BCS Meta Man, which enables you to connect to many different external data sources such as Oracle, Microsoft SQL, OData, ODBC data sources, and WCF Web Services.

Lightning Tools is now proud to announce that through a new partnership with Theobald Software, we are able to offer Business Connectivity Services SAP, a new tool that provides code free Business Connectivity Services connections to SAP using the BCS Connector.

Why connect to your SAP data with SharePoint Business Connectivity Services?

Microsoft SharePoint Business Connectivity Services is a suite of SharePoint and Microsoft Office services that can utilize or present your data in many ways. Users of SharePoint will be able to search for information within the SAP ERP system using the standard SharePoint search site, lookup SAP data within SharePoint lists and libraries using the External Data Column, build business data dashboards using the Business Data web parts, and manipulate the data using External Lists. This functionality saves users valuable time and provides them with in-depth business knowledge through the use of SharePoint.

Why use the BCS Connector?

Using the Microsoft SharePoint Designer tool, you can create an External Content Type which allows you to generate the properties, methods and connections to Microsoft SQL, .NET Assemblies or WCF web services. This doesn’t help you if you want to connect to SAP. The BCS Connector is a code free tool that allows you to create the External Content Type, along with the Filters, Methods, Custom Actions, Field Types and Formatting which is required by BCS. All you will need is an understanding of which Table or Function from SAP you would like to connect to along with the credentials to access the SAP system.

clip image002 thumb2 Lightning Tools to offer Business Connectivity Services tooling for SAP

ERPConnect Services

The BCS Connector is part of ERPConnect Services which contains three products:

· BCS Connector

· Web Service Designer

· ERPConnect Services Runtime

clip image004 thumb Lightning Tools to offer Business Connectivity Services tooling for SAP

The BCS Connector works specifically with Business Connectivity Services enabling you to connect quickly to SAP and generate the External Content Type allowing you to get on with building the dashboards and user functionality within SharePoint.

The Web Service Designer is a similar tool, but enables you to connect to SAP data, and then generate a web service that returns SAP data without the need to write code. The data via the Web Service can then be used throughout SharePoint Web Parts, Apps or externally on devices such as Windows Phone.

The ERPConnect Services Runtime provides .NET developers with the ability to use SharePoint as a SAP data hub. Access to SAP data can be enabled through Visual Web parts, Silverlight and local .NET applications like for example MS Office Add-Ins.


If you would like to find out more about ERPConnect Services, please visit our page or download a 30 day trial:


Read more »