Menu
SharePoint Pivot View Web Part

Virto HTML5 Pivot. SQL table

Go to “Pivot view settings” section and click “Add new” or use Quick Data source wizard.

Select SQL table as a data source.

Define name of SQL table. Check the box “Use trusted connection” if you need. Connect to SQL server by entering user name and password. Click “Connect”.

Then define database name, SQL table name and select primary key field.

Now match fields of SQL source and facet categories in “Mapping fields” section.

Note: “Name” field is required.

Then you need do define image settings for Pivot View. Define width and height of images (in pixels).

Note: page load time depends on image size. Do not define too large size for images in the Pivot View.

Then go to image settings section and define parameters of displayed images. The settings can be customized in the same way as it is described in “SharePoint list” chapter.