So, maybe on the example.
I have developer and test enviroment.
On dev I have crystal report usign ole db connection to SQL Server (name sql1).
On test I need to have the same crystal report but using ole db connection to another SQL Server (name sql2).
Can I do this using LCM and Override settings?
yes, that is the intent of the override settings. The test system will have a list of source db connection details that will be updated to the new values.
eg: Report A in DEV connected to db1 on promotion (after editing the overrides) Report A in Test connected to db2 without any manual intervention.
I did everything as advised to apply an override for the universe connection object, even though there is no change in the connection settings from QA to PROD, I still get this during Test Promote:
Resolution Status=Copied, Dependency Status=All the required dependencies are included., Commit Status=Commit is successful., Promotion Status=Warning : Can't apply override; Override information is Not Available
When I do the actual promotion, the job fails for the connection object citing override issues. I don't know what's going on with LCM but is there any way to no be forced to use the override feature?
It looks like universe connections simply cannot be migrated from system A to B without creating override settings for it. What is the connection object being migrated doesn't need to change in terms of database settings...why would the LCM tool force (and fail if it doesn't exist) to create override settings?
We are on SP2 P12.
we have all BICS connections. when ever I try to scan over ride, it shows error as " NULL". we have this issue from patch 6. SAP confirmed that its an bug and it get resolved in patch 12. But I see same error message in P12 too.
Do any one are able to scan the connection and use the function on their enviorment?