Within this 10 minute video, we connect to Microsoft SQL via Business Connectivity Services. Selecting multiple columns from the external content type, we then apply data formatting and conditional formatting. The Data Viewer web part can be connected to multiple data sources including SQL, Oracle, SharePoint lists and more.
The Lightning Tools Data Viewer web part provides you with the ability to create views of data from almost any external data source, insert data, edit data, and delete data (assuming the user has the correct permissions). Users can configure the data viewer web part without the use of SharePoint Designer 2013.
Using the Data Viewer Web Part for SharePoint 2013, you can configure connections easily using the simple wizard. Simply select the provider and then complete the required fields such as the server name for the SQL server or the URL for the service containing the data.
The Data Viewer Web part allows for various authentication options such as windows authentication or mixed mode. If you are connecting to an SQL server database, you can browse the Tables, Views or Stored Procedures that you would like to connect to.
The Data Viewer Web Part provides the user the option of Inserting, Updating and Deleting Data which will write back to the external data source. Users can perform such operation depending upon their permission in the external data source and also as to whether Insert, Update, and Delete operations have been enabled in the Web Part properties.
The grid view for the web part is configured once the connection has been created. Simply check the columns from the external data source that you wish to display, provide a column alias, grouping, formatting, and alignment. Conditional formatting, aggregate functions and sorting are among the many features that can be applied without the use of SharePoint Designer 2013.
Conditional Formatting options allow the user to be able to highlight cells or rows in custom colors depending on a condition such as Units In Stock are below 6.