Component Features

SQL/CSV database Gets data from SQL database or CSV sheets

The component will connect to any database: MS SQL, MySQL, Oracle, PostgreSQL - using simple script generating CSV output to enable real-time business analysis. Pivot Component is full browser-side component, thus you can use any desired server-side to generate CSV data: ASP, PHP, ASP.NET, JSP, ColdFusion, Ruby on Rails, JavaScript or simple HTML pages.

You can even use usual static CSV files with exported business data to create a simple business intelligence report to demonstrate the power of Pivot tables and charts.

Alternatively Pivot Component can work with OLAP cubes via XMLA, which is a standard method to work with really huge data volumes.

Pivot Component allows additional control by providing meta-data to the reports. You can define which columns are dates, currencies or parts of tree hierarchies, links or icons for the desired visualization.

See also: