Features

PREMEUSPronouncedpreme – us moves MV data transparently to and from a RDBMSDefinitionRelational Database Management Systems include SQL Server, mySQL, and Oracle.. PREMEUS is not intended to be a GUI report designer. It puts your data where it’s required so that any popular reporting tool can use it. Compare this to … “Ugh! That’s a great reporting tool but it doesn’t work with MV!” As an added bonus, it pulls relational data into standard MV items for processing like any other MV data.

• Create SQL tables and schema using MV dictionary items
• Initiate data import and export from TCL
• Query the RDBMS using SQL from TCL
• Perform above operations from code
• Tranparently perform operations using file triggers or background processes

Combining the above, some interesting options become available:

• Report on your MV data using tools that only work with RDBMS via SQL.
• Import RDBMS data as a part of your MV ERP application, to aggregate order data, sales, history, etc.
• The reverse of the above … allow your MV data to be easily aggregated and reported with data from other systems.
• Make your data readily available to common mobile applications.
• Use the RDBMS to re-index MV data, with complex SQL queries that return lists of item IDs.