Skip to main content

Use of Ai tools to extract production data for external BI tools

  • August 25, 2025
  • 3 replies
  • 72 views

Forum|alt.badge.img

We are looking at the use of Ai to extract data from our production orders and put out in a BI tool the work that each work centre is working on, the current amount of hours done, and whether they are on target or not.

Has anyone done this yet? and if so, what tools were found to be the best for doing it?

3 replies

Forum|alt.badge.img+8
  • Captain II
  • August 26, 2025

@davidmillstui 

 

You could use some fairly OOTB features of Claude via MCP such as Playwright to do it, although, I do not think AI would be your best option.

 

You would be much better off using an automation tool, Power Automate, Zapier, Make.com etc. which would draw out the data based on a REST call, then put the data in an external DB that you have linked to PowerBI.


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 26, 2025

Thanks ​@aiwan for this answer.

As it is early stage, I will investigate both options of Ai vs automation tools.

Cheers

David


Forum|alt.badge.img
  • Semi-Pro III
  • September 17, 2025

I’d also suggest including tools like AWS Lambda and Azure Functions in your research. The long-term costs of the other platforms mentioned could be high, depending on various factors.