Comparing OCI vs CI Datasources

Not sure if this information will be of any use to anyone, except if you're doing a fairly large OCI to CI migration, where it's not so straightforward as just running the migration tool to bring all your datasources across.

Here we bring together stuff from the previous posts. And it's fairly easy to compare OCI vs CI datasources and get a report. First run the OCI datasource export to CSV tool:

Cosonok's IT Blog: [OCI][Python] Collecting All NetApp OCI Datasources Across Multiple OCI Servers and Export to CSV

Then run the CI datasource export to CSV tool:

Cosonok's IT Blog: [CI][Python] Collecting All NetApp Cloud Insights Data Sources (Data Collectors) and Export to CSV (remember you might need to set your proxy as per this post)

Finally, with a little bit of excel manipulation, you can bring both sheets into the same excel workbook, turn the data into tables, and to compare use VLOOKUPS like the below.

For the OCI table to check if they are in CI (OCI is sheet 1 / CI sheet 2):

IFERROR(VLOOKUP(F2,Table2[@foundationIp],1,FALSE),"Not found")

For the CI table to check if they are in OCI (CI is sheet 2/ OCI sheet 1):

IFERROR(VLOOKUP(F2,Table1[@foundationIp],1,FALSE),"Not found")

Note: In both cases it is still worth manually checking the output (i.e. DNS FQDN may have been used in once but IP in the other and vice versa.)

And you might add in a little conditional formatting too.

THE END

Comments