Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"[SOLVED] Using Macro in ReadDatabase connection"

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.

Find more posts tagged with

AI Studio

MacOS

Macros

Accepted answers

All comments

Marco_Boeck

Hi,

yes, you can.

Regards,
Marco

JEdward

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

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

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.