Is it possible to make the data source dynamic when integrating the dashboard into a winform?

[Mohamad]

I am using the dashboard designer to create my dashboard and I want to integrate it to my winform and i don't plan to use the dashboard server. I am using the web data source in the dashboard designer. Is it possible to make the dashboard get the datasource from connection string in my app.Config file? note that even if data source is difference I will be receiving data with the same schema or structure, the difference is that i will be getting data from different server and maybe different link.

note: I will not connect to database directly i will use an SP to get data as JSON objects. 

[Mehala Palanisamy]

Hi Mohamad, 

 

We can able to change the connection string for the dashboard using Web API. Refer the below KB link for how to change the on demand connection string, 

 

https://www.syncfusion.com/kb/9205/change-the-dashboard-connection-on-demand-for-non-net-applications-using-the-web-services-web-api  

 

We are checking how to pass the Web Data Source connection string from our end. We will get back to you further details in two business days. 

 

Regards, 

Mehala Palanisamy 

[Mehala Palanisamy]

Hi Mohamad, 

 

Thanks for your patience. 

 

Use the below code snippets to get the Web Data Source connection string. 

 

 Connection connection= new Connection { DataSources = new List<DataSourceConnectionString>()}; 

ConnectionStringBuilder genetator =new ConnectionStringBuilder(); 

ConnectionParameters connectionParameter1 = new ConnectionParameters  

            {  

                  Url=””, // Your web data source url 

                AuthenticationType = 1, //Server or Windows Authentication Type. Mostly on demand connection should be Server Authentication.  

            }; 

connection.DataSources.Add(new DataSourceConnectionString  

            {  

                Name = "DataSource1",  

                ConnectionString = generator.GetConnectionString(connectionParameter1, ConnectionProviderType. WebDataConnector, OdbcDbmsType.None)  

            });  

 

 

Check the below KB document for your reference. 

https://www.syncfusion.com/kb/9205/change-the-dashboard-connection-on-demand-for-non-net-applications-using-the-web-services-web-api  

 

Regards, 

Mehala Palanisamy