Can I use a trigger without RM server?

mtmtmtmtmtmtmtmtmtmt Member Posts: 5 Learner I
Hi everyone

I'm taking some data from MSSQL and writing again on SQL. I need a trigger, can I do that without using a server? Pls help

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,287 RM Data Scientist
    Thats what the AIHub is for.
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    mtmtmtmtmt
  • mtmtmtmtmtmtmtmtmtmt Member Posts: 5 Learner I
    thx, but I am a student now, What is the price of the AIhub?
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 863 Unicorn
    Hi @mtmtmtmtmt,

    check out the script "rapidminer-batch" in your RapidMiner/scripts folder. This can execute the RapidMiner engine from the command line with a process, instead of starting the graphical interface. 

    Your operating system certainly has a method for scheduling execution of command line processes regularly. So you can periodically execute a RapidMiner process using this method, although clumsily compared to AI Hub.

    A trigger is an event-based method execution. Would you want to react to database changes and execute the process then instead of periodic scheduling? This is a bit more complicated but would be better solved with a long-running RapidMiner process that loops and/or waits for the changes and then starts the process you'd like to execute.

    Regards,
    Balázs
    yyhuangmtmtmtmtmt
  • mtmtmtmtmtmtmtmtmtmt Member Posts: 5 Learner I
    edited September 19
    hi @BalazsBarany
    Thanks for your answer. Can you help me for the find scripts. I could not find.

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 863 Unicorn
    Hi!

    In my installation folder (where the RapidMiner-Studio.sh file is) there's a subfolder called "scripts". This might be in your C:\Program Files folder if you're using Windows.

    If you don't find it on your computer, you can extract it from the Linux download file of Studio:
    https://my.rapidminer.com/nexus/account/index.html#downloads

    (There is a Windows and a Mac file in the scripts folder in this archive, regardless of the name of the download link. This is actually the universal version of RM Studio that works on every operating system with a compatible Java runtime.)

    Regards,
    Balázs
  • mtmtmtmtmtmtmtmtmtmt Member Posts: 5 Learner I
    hi @BalazsBarany
    I found it. Thank you very much. I admire you. But when I clicked to rapidminer-batch folder It is closing suddenly. How can I fix it and what can I text to the command line for starting my rm design?

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 863 Unicorn
    Hi!

    Make yourself familiar with the command line of your operating system. MacOS and Linux are quite similar, Windows is a bit different. 
    Make sure you use the RapidMiner command line script matching your operating system. This is rapidminer-batch.bat for Windows, rapidminer-batch.sh for Linux and so on.

    Use your terminal or command line application to navigate to the RapidMiner scripts path. Then enter the RapidMiner command line script name, followed by the full path (including the repository name) to the process you'd like to start.

    This is how I run the program on Linux:
    bash ./rapidminer-batch.sh "//Local\\ Repository/processes/Reporting\\ Demo"
    As you can see, my repository name and also the process name have spaces in them. The entire path of my process is inside the "double quotes", and spaces are additionally escaped with \\. This will depend on your operating system and command line shell.

    When this works when called manually, you can use the command scheduler of your operating system (e. g. cron on Linux) to execute the command regularly, e. g. every day or every hour.

    Regards,
    Balázs


  • mtmtmtmtmtmtmtmtmtmt Member Posts: 5 Learner I
    hello @BalazsBarany
    I have taken a fault message: Access is denied. What I should do?
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 863 Unicorn
    Hi,

    you should provide better diagnostic information. Which operating system are you using, what did you enter, what was the command output etc.

    Regards,
    Balázs
Sign In or Register to comment.