cancel
Showing results for 
Search instead for 
Did you mean: 

SAP MII How insert data to MDO throught illuminator

rafi9393
Explorer
0 Kudos
501

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:
MDO.png

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?

View Entire Topic
murali_manohar
Participant
0 Kudos

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
Explorer
0 Kudos

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

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

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:
msedge_jhnFMcxvhU.png
And after this I have the same result like before:
java_9tAiztQ3gx.png

murali_manohar
Participant
0 Kudos

Hi Rafi,
Did you provided the params in the insert query mode as below screenshot?WhatsApp Image 2024-05-07 at 3.24.10 PM.jpeg

rafi9393
Explorer
0 Kudos
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
Participant
0 Kudos

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.