Changing connection from SQL Server to Oracle

[Cristian Filipe Fernandes]

Hi,

There is a way to change the connection string of the dashboards from SQL Server to Oracle?

Our application can be used with SQL Server or Oracle and we are looking for a solution which we do not need to create duplicate dashboards (one for SQL Server and other for Oracle).

Besides that, Oracle connection on Dashboard Designer never worked well. I use the dashboard designer since version 2.2.

Thanks,

Cristian

[Renuka N]

Hi Cristian, 

 

Please find below response for your queries, 

 

Query	Response
There is a way to change the connection string of the dashboards from SQL Server to Oracle?    Our application can be used with SQL Server or Oracle and we are looking for a solution which we do not need to create duplicate dashboards (one for SQL Server and other for Oracle).	You can change your dashboards from one connection (SQL) to other connection (Oracle) without duplication using “Edit Connection” option in Dashboard Designer. Please refer below documentation link for Edit connection, https://help.syncfusion.com/dashboard-platform/dashboard-designer/connecting-to-data/editing-a-data-connection    Note:  While reconnecting, the designed table schema name must be same with reconnected table name  otherwise it will reset all your dashboard settings.
Besides that, Oracle connection on Dashboard Designer never worked well. I use the dashboard designer since version 2.2..    Also, I have the following error when I'm trying to made the relation of two tables on dashboard designer using Oracle	“There is not enough quota to process this command” exception occurs only when the memory problem arises. So we suggest you to close some applications and ty to increase your virtual memory. Please refer below links,  https://forums.windowssecrets.com/showthread.php/163892-Not-enough-quota-is-available-to-process-this-command     https://www.codeproject.com/Questions/232481/ERROR-Not-enough-quota-available-to-process-this-c

 

Please let us know, if you have any queries. 

 

Regards, 

Renuka N.