1. Home
  2. Forum
  3. Dashboard Platform
  4. Changing datasource connection info

Changing datasource connection info

Hi 

We have a few dashboards which have multiple data sources in each, which we would like to point to our live environment.

Is there a way we can do this without having go into each datasource and manually change? 

It seems if we do it manually, we lose some of our calculated columns and we have to create some of our widgets from scratch, which is pretty painful and time consuming

Thanks in advance

Ross

6 Replies
VS Venkataprasad Subramani Syncfusion Team March 27, 2018 12:21 PM UTC

Hi Ross Macintyre,  

Thank you for contacting the Syncfusion support.  

Data retain and loss on Editing the data connection:  
Reconnection will persist the dropped table(s), table relationships, data filters, data configuration to widgets, unless the schema is different from the previous data connection. i.e., the reconnected database should have similar schema like the previously connected database, which may exist in same or different location. If the reconnected one don’t have a column that is available in previous one, reconnection will just ignore that column and its related settings alone and persist others. Beyond that level, reconnection will drop previous settings entirely.  

The following alert message will be shown if the schema information differs while you trying to connect to a different data source, if you click yes the existing data will be reset.
  

Please refer our user guide documentation on editing the data connection for more details:  

So please ensure whether your new data source and the old data source are same at your end.   

Editing the data source without dashboard designer:   
You can change the connection string of the dashboard report using the utility called “DataSourceSwitcher”. It will allow you to change the connection string of more than one dashboard reports placed in the folder.    

However if you have used more than one different data source in a specific  dashboard report , the single data source which will be passed as the new connection string to the tool will be used for all the data sources. The existing and the new connection type needs to be same. So please review the limitation, guidelines and usages of the utility tool from the attached document before proceeding with the tool.   

Online link for utility tool and document:  

Note: The tool supports only the SQL Server, PostgreSQL , ODBC ( SQL , MySQL and Oracle ) connection types for connection string switching. If you are using any other data source type , please let us know the connection type details.   

Please let us know if you have any further queries on this. If you have any other requirement please provide us more details and we will get back to you with better solution for your requirement.   

Regards,  
Venkataprasad S.  


MP Maulik Patel December 7, 2020 10:39 AM UTC

Hello Team,

We have multiple a few datasource in dashboard reports. We are open dashboard report in sync fusion then got below error msg in Sync Fusion designer tool and after click on Yes button then lost Datasource from dashboard report.

Can you please help me on how to fix this issue?



Thank You,
Maulik Patel.

RN Renuka N Syncfusion Team December 8, 2020 10:48 AM UTC

Hi Maulik, 

We suspect that you try to connect different database with different schema( which have different columns) in the dashboard report. While changing the connection, the configured database and new database should have same columns to retain data in the dashboard. If the new database has different columns, data will reset in the dashboard. We can not map columns in this scenario. 

Please ensure that your new database has same columns of the configured database in the dashboard and let us know if any further assistance need. 

Thanks, 
Renuka N. 


AD Amit Dey August 4, 2021 04:03 PM UTC

Is this utility still avaiable?

If so how can I download it as it says I don't have permissions


SK Sathish Kanniyappan August 5, 2021 04:24 PM UTC

Hi Amit, 
 
We are checking on this and update you further details on or before 9th Aug 2021. 
 
Regards, 
Sathish. K 


SK Sathish Kanniyappan August 9, 2021 06:40 AM UTC

Hi Amit, 
 
Thanks for your patience, you can download the utility from the below online link along with documentation. 
 
 
Please let us know if you need further assistance on this. 
 
Regards, 
Sathish K 


Loader.
Up arrow icon