How to connect datasource(MySQL)? - OLAP.

[Park Gyu Hyun]

Hi, I have a question.

I saw this sample source and  try to test with database.

I didn't know SSAS.  I think MySQL DB is "Realational".

var pivotTableObj = new ej.pivotview.PivotView({
dataSourceSettings: {
        catalog: 'Adventure Works DW 2008 SE',
        cube: 'Adventure Works',
        providerType: 'SSAS',
        enableSorting: true,
        url: 'https://bi.syncfusion.com/olap/msmdpump.dll',
        localeIdentifier: 1033
}
});
pivotTableObj.appendTo('#PivotTable');

and... I have no idea. What can I do?

Does anyone have a sample that I can use as a "Relational" method other than "SSAS"?

If it can be used with MySQL, it will be the deciding reason for me to buy this product.

Please help me.

[Manikandan Murugesan]

Hi Park Gyu Hyun, 

 

We have prepared a simple pivot table sample by using SQL database as per your requirement. 

 

Sample: https://www.syncfusion.com/downloads/support/forum/168639/ze/PivotDemoMVC326999097 

 

If this is different from your requirement, then please let us know the more details with screen shot/video (if possible), so that we can work towards fulfilling your requirement. 

 

Regards, 

Manikandan 

[Park Gyu Hyun]

Hi  Manikandan.

Thank you for your kindness.

The source you sent me seems to be ASP.

Here is my Project.

Spring Framework, JAVA, JSP, Javascript , MySQL.

Thanks for your help

Regards, 

Gyu Hyun.

[Sastha Prathap Selvamoorthy]

Hi Park, 

 

We suspect that your requirement is related to load the data source(JSON or CSV) from remote. If so, you can provide the data source using URL under dataSourceSettings property. Please find the sample link below for reference. 

 

Online Demo: https://ej2.syncfusion.com/javascript/demos/#/material/pivot-table/remote.html 

For more details about binding data source via remote, please refer the document link below. 

Document:  

JSON data via remote: https://ej2.syncfusion.com/javascript/documentation/pivotview/data-binding/#binding-json-data-via-remote 

CSV data via remote: https://ej2.syncfusion.com/javascript/documentation/pivotview/data-binding/#binding-csv-data-via-remote 

Please let us know if you have any concerns. 

Regards, 

Sastha Prathap S.