SQL Reporting

0
Our business is new to the Mendix platform and two of us are trying to push the technology to replace ageing systems.   One area we are weak on is reporting, we build a product which is tracked via serial number, the data is kept on multiple SQL servers with individual DB's. Occasionally there is a need to report on a serial number and pull back all data associated with that serial of which the business is currently using 3 different system returning differing values.   I want to create an application in Mendix 10.6 that can replace these system and be our one source of truth moving forward but were not really sure were to start if someone could point us in the right direction please.    
asked
2 answers
0

Some modules in the marketplace are suitable for this Database connector, External database connector and Database replication

answered
0

Thank you for the reply,

 

Im looking at it now and have a connection to a single external Db but is it possible to to have more than one connection for the query as the data is spread over different DB's.

answered