Integrate model with third party tool

Swati
Swati New Altair Community Member
edited November 5 in Community Q&A
I want to deploy my model and use it with a third party tool like excel or so, that increases the ease of use for the end user.

Best Answer

  • jacobcybulski
    jacobcybulski New Altair Community Member
    edited June 2019 Answer ✓
    Unfortunately, RapidMiner does not have a general-purpose single user support for integration with other tools such as Excel. I imagine each vendor of an external product has to write an extension to help us here. For example, there is a really good interface with Tableau, which you could investigate for what you have in mind.
    If you use a RapidMiner server, you have to rely on an enterprise solution, which may involve Real-Time Scoring Agent. You can also create a server-side web page which accepts some data and generates a table of results and possibly some charts. This web page can be distributed within an organization. You could also feed live data from such a web page into Excel for further calculations and processing.
    Jacob

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Hi,

    the way you deploy your model depends on many factors. Some hints:

    - Simple models like linear regression, GLM, decision trees (check out Tree to Rules) can be easily translated into a programming language or an Excel formula.

    - The recommended way to deploy complex models (and entire model application processes) is RapidMiner Server. On the Server you can define services that call your RapidMiner process on data provided by the client and return the results.

    - If you need the highest available processing speed, you can look into the Real-Time Scoring Agent

    Regards,

    Balázs
  • jacobcybulski
    jacobcybulski New Altair Community Member
    edited June 2019 Answer ✓
    Unfortunately, RapidMiner does not have a general-purpose single user support for integration with other tools such as Excel. I imagine each vendor of an external product has to write an extension to help us here. For example, there is a really good interface with Tableau, which you could investigate for what you have in mind.
    If you use a RapidMiner server, you have to rely on an enterprise solution, which may involve Real-Time Scoring Agent. You can also create a server-side web page which accepts some data and generates a table of results and possibly some charts. This web page can be distributed within an organization. You could also feed live data from such a web page into Excel for further calculations and processing.
    Jacob
  • SGolbert
    SGolbert New Altair Community Member
    Hi @Swati

    You can connect Excel to RM Server by using web services. I have covered the topic in a post not long ago:


    The same goes for other 3rd party software, web services is the way to go!

    Regards,
    Sebastian