Pivot Grid: how to connect to SQL Server with and without OLAP Service?

[Biagio Paruolo]

How to connect to SQL Server with and without OLAP Service?

[Tamilarasu M]

Hi Biago,    

Thanks for contacting Syncfusion support,  

  

Can you please confirm us which platform you are using now either EJ1 PivotGrid or EJ2 PivotGrid? So that,we can provide exact solution for your requirement. Please find the EJ1 and EJ2 PivotGrid control documentation link below . 

 EJ1 PivotGrid:    

https://help.syncfusion.com/aspnet-core/pivotgrid/getting-started    

 EJ2 PivotGird:    

https://ej2.syncfusion.com/aspnetcore/documentation/pivot-grid/getting-started-core.html    

Please let us know if you have any concerns.   

Regards, 

Tamilarasu M 

[Biagio Paruolo]

EJ2 PivotGrid

[Tamilarasu M]

Hi Biagio, 

Sorry for the delay, 

Query	Response
Relational Data Source (without OLAP)	We have prepared sample to bind SQL table data with PivotGrid Control. Please find the sample and video in the below    Sample:  http://www.syncfusion.com/downloads/support/forum/139584/ze/Pivot-578066464    Video:  http://www.syncfusion.com/downloads/support/forum/139584/ze/PivotGrid-499819744
OLAP Data Source Support	Currently, we don’t have support to bind OLAP data source with PivotGrid control in EJ2 platform. Meanwhile, we have already logged this as a feature request and it will be available in any of our upcoming release.    Meanwhile you can make use of EJ 1 PivotGrid until OLAP support for EJ2 PivotGrid is rolled out. Please find the documentation link below for EJ1 PivotGrid.    https://help.syncfusion.com/aspnet-core/pivotgrid/getting-started#olap

 

Please let us know if you have any concerns. 

Regards, 

Tamilarasu M 

[Biagio Paruolo]

I'll try to use with Vue.JS

[Suriya]

Hi Biagio, 

Thanks for your reply with platform details. As mentioned in previous update, this feature, ‘Biding OLAP data in EJ2 PivotGrid’ will be available in any one of our upcoming releases. 

We appreciate your patience. 

Regards, 

Suriya