You can do it manually by right clicking on the data source and choosing "replace data source". If you want an automated approach you may be able to manipulate the XML in the twb file. Can't remember if the InterWorks toolset lets you do this.
After Manipulating the XML .. I have to republish the report.
Is there any way of updating the Data Source without republishing ?
You could script the republish with tabcmd or the new API coming in 8.2.
I am facing the exact same problem: same query, same schema, but different connection string. Hopefully there will be a control on the dashboard for user to switch between datasources.
Now that 8.2 has been released. What does the NEW API do to fulfill this requirement? Could you point us to the NEW API (link, documention, etc..)?
any solution to this?