Can I add the sql file like usage in XAMPP,mysql,PHP to do it in Pivot format instead of JSON file or CSV file format.
Thank you for your question.
Our team would like to kindly inform you that WebDataRocks only works with JSON and CSV data formats. In such case we recommend preprocessing the SQL data into CSV or JSON format on the server side.
We would like to kindly draw your attention to Flexmonster Pivot, which is the premium product developed by the same team. Flexmonster uses the Data Compressor allowing to fetch the SQL formatted data from the database.
Please contact us in case of additional questions.