first of all, i'm biginner in Bi Consulting with Microsoft tools.
I want to compare two databases : Oracle Database and Sql Database
both of databases have the same data but not the same naming of Table or Columns for sure !
I thought to create a linked Database in SSMS, but i'm not administrator and i can't modify the Production Database
May be i can use PowerPivot in Excel but I don't know how ?
so any idea please ?