on 10-01-2012 11:59 PM
Hi, someone could tell me how to write to a database from SAP MII
Regards, Victor
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.