Quickly aggregate data from CSV files and SQL databases, then map it to pivot tables which you can save in HTML format, with this tool #Data Aggregation #Pivot Table Report #Render Table #Aggregation #Aggregate #Cube
PivotDataTool is a simple, lightweight utility designed to process data extracted from CSV files or SQL databases and transpose it to HTML pivot tables.
The program runs as a Command Line utility and features a comprehensive documentation, which can help you get accustomed to the functions, arguments.
The tool allows you to load cubes of data from serialized data files (for example a pair of *.cfg and *.dat files), as well as aggregate information from CSV documents.
It can perform cube configuration, if required and aggregate the data returned by the selected database driver. Microsoft SQL Server and ODBC drivers are supported.
PivotDataTool allows you to define in-memory cube configuration details, which you can save as *.json files, as well as apply the value mapping rules for each input data row. However, certain cubefile arguments cannot be used for mapping rules.
After aggregation, the program can generate a pivot table report. You can control the pivot table report output handles with ease.
The output handlers that PivotDataTool supports allow you to save the aggregated data to the specified files.
Alternatively, the result may be displayed as dimension keys and the pivot table report can automatically be rendered to HTML.
Pivot table reports may also be rendered to CSV, PDF or Excel files. OLAP servers or Microsoft Excel are not required for exporting the pivot table reports.
PivotDataTool is a suitable tool that can help you aggregate data in a matter of seconds. It can come in handy when Microsoft Excel cannot manage particular data structures from CSV files or built-in memory data cubes.
The program can import data straight from Microsoft SQL or any ODBC-compliant database driver. Moreover, you can even load pre-aggregated data, such as SQL GROUP BY query.
System requirements
PivotDataTool 1.0.5
add to watchlist add to download basket send us an update REPORT- runs on:
-
Windows Server 2012
Windows 2008 R2
Windows 2008 32/64 bit
Windows 2003
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit
Windows XP 32/64 bit - file size:
- 748 KB
- filename:
- pivotdata_utility_free.zip
- main category:
- Internet
- developer:
- visit homepage
IrfanView
7-Zip
calibre
4k Video Downloader
Zoom Client
Context Menu Manager
Microsoft Teams
ShareX
Bitdefender Antivirus Free
Windows Sandbox Launcher
- ShareX
- Bitdefender Antivirus Free
- Windows Sandbox Launcher
- IrfanView
- 7-Zip
- calibre
- 4k Video Downloader
- Zoom Client
- Context Menu Manager
- Microsoft Teams