Intelligent Query
A query environment providing data-access, query builders and distributed runtime utilizing strong-typed extensions to LINQ.
Intelligent Query for Aras Innovator
iQuery is an advanced LINQ .Net Core based query builder, query engine and runtime for Aras Innovator, Siemens Teamcenter and other data sources.
Design and build queries using drag and drop builder, then publish queries to Innovator directly or deploy distributed Docker-based runtimes.
Queries are converted from LINQ to Native database queries e.g. Innovator AML, Teamcenter POM_enq etc.
HOW IT WORKS
CONNECT
Connect to your data from Innovator, TeamCenter, SQL and other common data sources.
iQuery generates a fully LINQ Queryable Data Model with runtime query conversion to the native data-sources query language e.g. AML for Innovator, ITK (POM_enq etc.) for Teamcenter.
BUILD
Build your LINQ query using our advanced Query Builder. Drag and drop fields, use wizards to assign data.
Live query results allow drill-downs to further refine the query.
Desktop and Browser based versions are available.
LINQ queries and results are automatically converted to strongly-typed entities.
RUN
Run the query locally or publish to a REST server.
Results as json, xml, text.
Use your favorite reporting tools such as Microsoft Power BI or your tool of choice to work with the strongly-typed json data.
CONSUME
Use queries and data-sources in reporting tools such as Power BI, or develop your own queries in your favorite languages .Net/JavaScript etc.
