Write in a database from MII

[Former Member]

Hi, someone could tell me how to write to a database from SAP MII

Regards, Victor

[Former Member]

Hi Victor,

First you need to add the database parameters on the XMII page:

     http://<host>:<port>/XMII/Menu.jsp

Go to 'Data Services' -> 'Data Servers'.

Here you can define the connection parameters for your database. Check the internet for a detailed explanation.

When your connection is successfully set up you can create an SQL query in the MII Workbench.Select the SQL query --> Data Source. If the connection with the database is ok; it should be listed under the available servers. Also set mode as 'FixedQuery' since your query won't be returning any result.

Write your Insert/Update statement in 'Fixed Query Details'.

Hope this helps!