Building a Reporting Tool in ThingWorx or Navigate which can help build reports from any 3rd Party Software like SAP/Sales Force etc. which has discover-able REST API Endpoints and Services.
The idea is to build a reporting tool in Navigate or as a separate product line, where we can give any REST endpoint of the system from where we need to pull the data and build report. The tool will then discover the Services and Domain and generate the data models available. Then in the working area, we can drag and drop the fields from the data models generated previously and create a customize report on the fly. We can also define a common field based on which we can combine data from 2 data models.
Additionally we can provide custom connection to other system using which we can connect the systems and generate data models which can be then used to build the reports.
With REST API, we have ability to discover the available endpoints which can be used to discover the services and this gives us ability to generate data models by just providing the REST Endpoint. It very similar like working in a DBMS System with a Primary and Foreign Key defined, where we can build an aggregated report very easily.
- This is very beneficial for small and medium size companies which are looking for a easy to use and scale-able reporting tool to generate and publish reports for several stake holders.
- Often in an Organization there are leaders who find it difficult to generate a high level reports and usually lean on others for the same data. ThingWorx Navigate has a proven simple interface that can be easily used by anyone and if we have this capability, it will be a huge value add or the organization as they don't have to fish for the data they want.
- Similar to ThingWorx Navigate principal, it will eliminate dependency and can provide role based access to the required reports and data to relevant stake holders.