Angular-SQL-Pivot Table

Question

HelloI wanted to know if there is an option to connect to an SQL table using SyncFusion and display the table as a pivot in the front-end. I use Angular 11 for coding. A variant of Angular - ASP net CORE C # - SQL would be better for me. If so, let me know how I can create a connection between SyncFusion and an SQL table.Any help in this regard is welcome.Thanks in advance.

Saranya Sivan · Accepted Answer

Hi Pepa Zdepa, 
 
The SQL database couldn't be connected directly to the pivot table component but can bind its resultant data to the component.  
  
Please refer the below UG to know about the supported data types. 
  
https://ej2.syncfusion.com/angular/documentation/pivotview/data-binding/ 
  
Meanwhile, you can also use WebApiAdaptor to bind pivot table with Web API created using OData endpoint. Please find  the UG for your reference. 
  
https://ej2.syncfusion.com/angular/documentation/pivotview/data-binding/#web-api 
  
Please let us know, if you need further assistance on this. 
  
Regards, 
Saranya S.