[memset]

Thank you for the encouragement! We think a lot about this problem as well. We think that within a specific vertical ("productivity tools", "finance software") there is probably a lot of opportunity to use an intermediate schema for a bidirectional mapping.

But, as you mention, we're also being careful to observe what kinds of integrations customers are asking for before trying to generalize the problem.

[tsthename]

Just thinking about the problem some more (from the perspective of the data owner), I wonder if instead of solving the problem at migration time the problem could be solved at the time of data creation.

What if data was routed to a) the Saas tool and b) to long term storage. So the act of migration becomes an act of moving raw historical data to the new tool instead of pull from service, transform and push to new service.

Oh, I think I just described a data lake..