"[SOLVED] Using Macro in ReadDatabase connection"

JEdward
JEdward New Altair Community Member
edited November 2024 in Community Q&A
Hi all,

Does anyone know if I can safely use Macros in the names of predefined connections in the ReadDatabase operator?  
i..e. replace the name in the process XML with %{connection_name} so that it can be set by an earlier part of the process?  


Thanks,
JEdward.
Tagged:

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    yes, you can.

    Regards,
    Marco
  • JEdward
    JEdward New Altair Community Member
    Hi Marco,

    I get an error when I try this.  It says "Cannot find connection" and then gives the name of the connection that I passed with the Macro (this is exactly the same as the named connection on my setup).  I can see the Macro has passed the right value, but for some reason it isn't enough for RapidMiner to recognise the connection name. 

    Using RapidMiner 5.3.
  • JEdward
    JEdward New Altair Community Member
    An update.  I have it working now. 
    It seems that if I generate the Macro within the process using SetMacro it works, but if I pass it to the process via the context it doesn't. 

    Still investigating to find out why, but going to assume it's something I did with the setup. 
  • bkriever
    bkriever New Altair Community Member
    This worked for me when entering the Macro in the Context dialogue.
    One of the parameter lines in my XML disappeared for a Write Database operator,
    but I was able to paste in:  <parameter key="connection" value="%{DBConnectionName}"/> which worked fine.
    It was working for Read, Write and Update Database in my process, RM version 6.0.008.

    If it is still not working from the Context input you may be able to use Generate Macro and have the the value linked to the Macro in the Context.

Categories