For making Pivot collections, there are 2 great tools
1. Excel add-in -- for beginners
2. Command line tool -- for advanced users
But these tools cannot directly create collections from SQL Server database. We need to manually copy and paste or export the data to excel. Here is a third party tool by Sysgain Inc., to generate collections from SQL Server using large data sets.
Collection Designer for SQL
http://www.getpivotdesigner.com/
This is an efficient tool to generate Pivot collections in minutes including downloading images, converting them into deep zoom format and making collection.
Future versions are coming with ODBC data connectivity also.
There is an enterprise version of this tool, which comes with a windows service, which can scheduled simply to re-generate / update collections without human intervention daily/weekly/monthly.
No comments:
Post a Comment