We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

SQL 2003 Statement

Thread ID:

Created:

Updated:

Platform:

Replies:

143830 Apr 7,2019 06:17 AM UTC Apr 9,2019 12:08 PM UTC Dashboard Platform 3
loading
Tags: Dashboard Datasources
Albert K
Asked On April 7, 2019 06:17 AM UTC

Does Syncfusion Dashboard support SQL:2003 command like cube and rollup in the query syntax ?

Thank you.

Renuka N [Syncfusion]
Replied On April 8, 2019 11:37 AM UTC

Hi Albert, 
  
Thank you for contacting Syncfusion Support. 
  
We support SQL Server from 2005 and above in Dashboard Platform. We cannot connect SQL server 2003 in Dashboard platform, but we can use the statements "Cube" and "Rollup" in the Code view by connecting any SQL server from 2005+ in Dashboard Platform. Please refer the following link to connect SQL server 
  
Syncfusion Dashboard supports CUBE and ROLLUP in Code View editor.  Please follow the below steps 
  
  1. Create SQL Server data source using Dashboard cloud and select table to which CUBE or ROLLUP function has to be applied
  
  1. Consider below sample and switch to Code View window as shown below.
  
 
  
  1. Under Code View editor the query can be modified to add support for CUBE or ROLLUP functions as shown below.
  
 
  
  1. Above query can be executed and data source can be saved for further operations.
  
Also modifying query in ‘Code View’ editor will be applied to entire data source. If a widget has to be filled with CUBE or ROLLUP queried data then this can be achieved by using separate data source only. 
 
Please let us know, if you have any queries. 
 
Regards, 
Renuka N.

Albert K
Replied On April 9, 2019 02:20 AM UTC

Thanks for the info.  But my question is more specific with regards to SQL standards,  ie the SQL2003 specification and not Microsoft SQL server.   

Also, Can the cube/rollup syntax be used against Postgres, Ansi SQL ODBC drivers?  Thank you.


Sabapathy K  [Syncfusion]
Replied On April 9, 2019 12:08 PM UTC

Hi Albert, 
 
Please below find the response for your query. 
 
But my question is more specific with regards to SQL standards,  ie the SQL2003 specification and not Microsoft SQL server.  
In all SQL Live mode connections, data will be queried directly from the connected server (e.g. Oracle, Postgres, MSSQL, MySQL). So the queries in code view will work as per connected SQL data sources. If your SQL data source supports SQL 2003 standard and connected in Syncfusion in live mode which will in our dashboard platform. 
Can the cube/rollup syntax be used against Postgres. 
Yes, cube/ rollup syntax can be used against Postgres data source. 
ANSI SQL ODBC drivers. 
No, currently we don’t have the support to connect the data bases using ANSI SQL ODBC driver on Web Dashboard Designer. 
 
Please let us know if you need further assistance on this. 
 
Regards, 
Sabapathy K. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon