Reporting & Analytics with ODBC integration
How do I get my existing data from my database into real-time dashboards?
With the X10 Industrial Gateway or Actyx VM you can easily interface with your existing SQL servers through the Actyx ODBC integration. These are then processed in real time in the Actyx Ada architecture and played into the Reporting & Analytics application. The application can then be used cross-device on your mobile phone or at your office. This gives you access to real-time information, push notifications and reports such as daily status, OEE or Job change reports wherever you are.
How does data translation with ODBC work?
Data from existing SQL servers is integrated into the Actyx Ada Architecture through the Actyx Industrial Gateway, which is based on the Hilscher netPI. Data translation from the SQL data scheme can be configured via the graphical configuration interface. This enables the data to be utilized throughout the shopfloor and in the digital environment of your manufacturing process. The gateway also supports further integrations with glass manufacturing machines through protocols such as OPC UA, OPC DA (classic) or Flex IS.
Easily collect machine data:
- Plug & Play, no installation
- Fully managed, no need for your IT to operate it
- Industry best practices, no risks
Leverage Reporting & Analytics for data-driven improvements
Within the Actyx Reporting & Analytics application, extracted data can be analyzed interactively and intuitively. Filter and drill-down functionalities enable quick access to critical information. This leads to data-driven process improvements, newly identified optimization potentials and continuous evaluation of measures to enhance the productivity of your manufacturing shop floor and process. Of course, all reports can also be exported to Excel.
Benefits of Reporting & Analytics at a glance:
- Increase productivity and OEE
- Stay in the loop from anywhere
- Effective shopfloor machine management
Factory Software Made Simple
Analyzing and leveraging machine data with reporting and analytics comes with a new kind of service, that eliminates all traditional problems of IT projects. Consulting is included and you only pay once the solution is up and running. All software and hardware components are installed in less than 8 weeks and completely operated by Actyx, with 100% cost control. Learn more about the Actyx All-Inclusive Package.
Extend at the click of a button: send machine data into your ERP or to mobile worker terminals
If you use SQL databases to collect your manufacturing process information, you have many options for using it. To avoid the creation of parallel systems, with Actyx the collected data can be easily played through ERP interfaces or the existing database to maintain your source of truth. The combination of historic data provided through the ODBC integration with other Actyx applications provides and easy way to add further value allowing context-sensitive worker assistance, intelligent quality inspections or real-time data communication to become even more useful tools. In this case, the Reporting & Analytics application can be leveraged to provide insights into the production process; increasing OEE, reducing machine downtime and identifying bottlenecks.
Data and transparency only become useful if they are leveraged through deriving, formulating and measuring operational initiatives to add value.
Let us calculate your ODBC/Reporting and Analytics Business Case together!