IngeniBridge SQL Reader

FREE
Active
Created By: Deagital
Created On: 22 May 2020
Overall Rating: Rating
Domain: IoT
Description:

This API flattens by denormalizing the internal hierarchical database for uses cases such as Business Intelligence.

API Endpoint:

IngeniBridge SQL Reader

FREE
Active
Features
  • Retrieve SQL Tables.
  • Retrieve where clauses availbale for each table.
  • Retrieve Select columns available for each table.
  • Perform actual Select extractions.
Benefits
  • Provide a connector for platforms such as Data Virtualization, Business Intelligence.



Frequently Asked Questions
  • How can I use this API?
    First request the table names, then you can execute EXECUTE SELECT API to retrieve the actual data. Output columns may be selected to reduce volume of data.
  • How is this API useful?
    SQLREADER is about Business Intelligence use cases. The IngeniBridge database is a hierarchical one. This hierarchical representation matches the metadata to describe Industrial assets and measures. Yet, Business Intelligence cannot accommodate with that kind of representation. Instead, Business Intelligence must consume flat matrix data. This is how this API is useful. It will flatten the database so to plug IngeniBridge to BI tools.

discussion

0

0

0

0

0

Loading Comments...