SharePoint Pivot View Web Part

SQL table

Go to “Data source settings” block and click “Add new”. 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” block.

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.

Note: free version of Virto Pivot View allows up to 300 items in the list

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