For users who have existing BI tools that they want to integrate with, Stibo Systems offers the following methods of extracting data from STEP that can be sent to downstream BI tools:
-
Audit Message Framework: The Audit Message Framework (AMF) is a powerful message delivery solution that sends configurable messages to an external system of the users' choice, allowing data in STEP to be extracted and exposed so it can be processed for statistical analysis. The AMF includes an out-of-the-box Audit Message Receiver JDBC Delivery Plugin, which utilizes message queues that correspond to tables in the external JDBC database into which user-specified audit messages are written. The analysis of workflow data is the typical focus for users of the AMF.
-
JDBC Delivery Method: The Java Database Connectivity (JDBC) delivery plugin feature can be configured to automatically (or manually) make STEP data available to an analytics platform, typically Tableau or Qlik. This feature effectively closes the loop of data and visualization by making master data viewable in a data analytics dashboard, which is in turn viewable in the Web UI. The analysis of product data is the typical focus for users of the JDBC delivery method. For information regarding proper setup of JDBC in conjunction with data analytics integration with the Web UI, refer to the Analytics using JDBC Example topic. For additional information on JDBC data delivery, refer to the following topics:
-
Exporting Data via JDBC with CSV Format in the Data Exchange documentation
-
JDBC Delivery Method in the 'Export Manager' section of the Data Exchange documentation
-
JDBC Delivery Method in the 'OIEP Delivery Methods' section of the Data Exchange documentation