We have a internal data where Power Bi Connects with SQL DB where we have built a solution for one accounting software which is connecting directly to the database (SQL) and is also locally available at the client. We want to able to fastly integrate with other accounting software and allow for scaling. Third Party accounting software like -Account software CEVI/Logins belgium (sql database) / Cipal Schaubroeck Oracle.
We also have a Data Model on PowerQuery and wants to perform column mapping to our existing datamodel OR want to build a new data model for every third-party-accounting software
What would be the most suitable? What services would be most optimal (data factory, synapse?) and also want to know how would the above options work out when the data is not accessible directly but through API's.
if the reply is helpful--
