cancel
Showing results for 
Search instead for 
Did you mean: 

SAP MII How insert data to MDO throught illuminator

rafi9393
Explorer
0 Kudos
508

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

Ok, I got it, but what if I have table like this:
Col 1                   Col2
Value1              Value5
Value2              Value6
Value3              Value7
Value4              Value8

And I would like to update value3 in Col1 to different value. Is it even possible throught illuminator service?

murali_manohar
Participant
0 Kudos

 

yes,

That is possible, all you have to do is add only the attributes you want to update and the update condition in the query as below

murali_manohar_0-1716038966278.png

for e.g., here i have only add 3 columns to get updated and the value will be updated based on the condition provided such as empid= param.1. and the update column values as param.2/3/4.

once your query is working fine here(from the workbench. test providing values in parameters tab, execute and see if the values are getting updated as expected or not.). then using the illuminator services, create a url and execute the url as below:

http://<server>:<port>/XMII/Illuminator?QueryTemplate=<your query path>&Param.1=<empid>&Param.2=<salary>&Param.3=<Designation>&Param.4=<Location>

 

murali_manohar
Participant
0 Kudos

Hi Rafi,

You can also refer to this video, which might answer your questions: 

this video clearly explains the MDO object creation, MDO query creation, consume the queries using url & parameters via illuminator services.

Thank You!