Migrate BI Report from One Server to Another Server via OIC
This is just a POC I was doing , when I did not do the CICD implementation following Richard Poon’s method. However, this technique can be used for migration too with more customization , possibilities are endless. Here I have used these physical connections but we can create these connections easily using rest api on fly too .
High level Steps:-
a) login to Source Server — download Object — logOut from Source Server
b) login to Destination Server — upload Object — logOut from Destination Server
Created connections :-
**Please note its better in the integration you can create and destroy these connections on fly for an environment where multiple SaaS are present.But for POC Sake I created these connections physically.
Security Service WSDL for creating connections:-https://<SourceServer/DestinationServer>.oraclecloud.com/xmlpserver/services/v2/SecurityService?wsdl
Catalog Service WSDL for creating connections:-https:// <SourceServer/DestinationServer> .fa.us2.oraclecloud.com/xmlpserver/services/v2/CatalogService?wsdl
Security Policy we can put “No Security Policy” for all connections.
Get Session from Source Server:-
Mapping
Download Object
Store the object in Global Variable:-
Logout:-
Flow will look like this :-
Similarly create another scope for uploading object to Destination Server like below :-
Thanks for reading.