You have no easy way to tie it together because your systems are all so different. Your options to figure it out will take days, weeks, maybe even months:
- You can export records from all your systems into spreadsheets and CSV files, chew up a ton of time manually comparing fields, create new corrected CSVs, and import them back into all your systems. (And hope it’s all accurate and nothing breaks!)
- You can work with a data expert to analyze your needs and databases and write a custom application that ties it all together. (And hope you never need to change it or add a new data source!)
- You can purchase and spend months configuring expensive data movement software to connect your existing systems. (And hope it offers all the options you need!)
You could do this work in your operational systems, your marketing database, or your data warehouse. But, wherever you do it, tying this data together will be a major challenge.