Can we multiconnect a single report using different connection sources.

[sourchandra]

Can we use a single report to connect to a SQL Server DB source & then change it to connect it to Azure SQL  DW  using Data Connections. I would be refraining from using QLIK Nprinting as we don't have the license for that.

The DB would change later on from SQL Server DB to Azure SQL DW so we have to make the similar change in the report.

But the fields would be same in both the DBs,as there would a one to one mapping between the 2 DBs while loading the data via ETL from SQL Server DB to Azure SQL DW.

[jwjackso · Accepted solution]

It seems like this would be similar to having a development and production database.

SET vDataConnection='SQL DB Connection String';

//SET vDataConnection='Azure DB Connection String';

LIB CONNECT TO '$(vDataConnection)';

[sourchandra]

Thanks I would check this for certain but please let me  know if there is no  one to one mapping once the model get migrated from SQL DB to Azure SQL DW, then would the only developed report crash & has to be redeveloped.