Today is not going to be enjoyable.
I'm going to attempt to change hundreds/thousands or connection strings for SSRS shared Data Sources and embedded report Data Sources using my least favorite development tool of all time: PowerShell.
(*SQL Server Reporting Services)