Massive replace of Data Reader source

Sergi Fernández
Sergi Fernández Active Partner, Community Captain
100 Up Votes 10 Comments Second Anniversary Year 2 Community Captain

Hello everyone,

It would be really useful to have the following functionality implemented in Board, as we would be able to have more flexibility and easily maintain the data models.

Massively replace the source of non-text Data Readers.

Why?
The connection between a Data Reader and its Source is currently based on the name of the Data Source defined in System Administration / Data Sources. So if the name of the Data Source changes, then all Data Readers using that source, become unusable as they are pointing to a Data Source name that no longer exists.

After using Board for many years, clients can suddenly have the necessity to make certain changes in the Data Sources that end up "breaking" the Data Readers. For example, changing a connection type from OLE-DB to ODBC in an existing Data Source, will prevent the user from customizing the name, and forcefully replace the name to the ODBC Source name upon saving.

This becomes an issue specially in large Board solutions, that can have thousands of Data Readers.

Useful applications:
Switching between production and test Data Sources.
Changing the SQL connection type from OLE-DB to ODBC.
Connecting to new data providers while keeping existing/previous Data Sources intact.

Implementation Idea:
That functionality could be implemented as a button on the Data Reader's page, and similar to the "Replace Data model" option we have in Capsule Properties.

Thank you for considering this idea to improve Board,
Best regards,

15
15 votes

Open For Voting · Last Updated