SAP MII How insert data to MDO throught illuminator

[rafi9393]

Hi Everyone,

I am trying pass arguments to my MDO throught illuminator. I create link like this:
http://<server>:<port>/XMII/Illuminator?server=MDOConnector&Mode=Insert&MDO=Project%2FMIIOBJ%2FMDOTest&Col1=Value1&Col2=Value2.

When I execute this link I recieve message in my browser that "Command Query Successful". After this when I check MDO in workbench I can see that It looks like this:

Why I can't see my values? Do I need to change anything in permissions?

Is there any different option to dynamically push data to MDO?

[murali_manohar · Accepted solution]

Hi Rafi,
when you are trying to pass the input values for a MDO insert query via illuminator services, make sure you have provided parameters correctly.
1. in the insert query mode of MDO, you can pass it directly as AttributeValue.1/2/3.. etc or you can pass them as parameters such as passing [Param.1] in the input field for Attribute.1, etc

2. once after you have created the MDO query ready with necessary parameters, build your url with illuminator services as below 
http://<server>:<port>/XMII/Illuminator?QueryTemplate=<Path of your insert MDO query>&Param.1=<value>&Param.2=<value>

now run the url in the browser with your values for the parameters, the data should be inserted in the respective MDO tables you have created.

you can try this and let me know if you have any questions.

[rafi9393 · Accepted solution]

Hi Murali_Manohar,
I have tried your solution and still nothing. Maybe I am doing something wrong. My MDO looks like this:

 And I have created MDOQuery in insert mode. It looks like this:

And my link looks like this:
XMII/Illuminator?QueryTemplate=My_Project/MDOQueris/InsertMDO&Param.1=MyValue1&Param.2=MyValue2
or:
XMII/Illuminator?QueryTemplate=My_Project/MDOQueris/InsertMDO&Col1=MyValue1&Col2=MyValue2
After runing the url in browser I recieve message like this:

And after this I have the same result like before:

[murali_manohar · Accepted solution]

Hi Rafi,
Did you provided the params in the insert query mode as below screenshot?

[rafi9393 · Accepted solution]

I didn't and that was a problem. Now works as it should. I have another question. Can I use illuminator services to update one record in my MDO? For example I have MDO with 100 existing records and want to update one of them. Is it possible with MDO query in update mode? If Yes, can you provide me with an example?

[murali_manohar · Accepted solution]

Hi Rafi,

Yes, you can use the update mode in the MDO query and in the attributes try to add only the columns of table you wanted to update. and as earlier assign the params accordingly.
once it is done, place the condition when you want to update those selected attributes. eg. [column.Name]=[Param.1]

and in the illuminator service just place the path of the update query and the associated params and pass the values.
It will work.