on 05-24-2011 6:16 AM
Hi All,
Can anyone let me know how to edit the metada which i have imported from sql server(table structure) in sap xi. Here my receiver is MySql server for that i have configured JDBC CC and imported the structure of the table. Now i want to edit the structure to place elements like Action,Access& statement fields.
Can someone plz help me regarding this.
Thanking you in Advance
Regards,
Cj
Hello,
It is not possible to edit the schema in PI. The sql metadata is designed for lookups only. Use XML SQL for inserting/updating and deleting data.
http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm
If you want to add columns, you can do it using a db tool and then reimport the changes (the table) into PI.
Hope this helps,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your valuable input Mark. It got resolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai!
I agree with the Point Mention by Mark.
For doing the JDBC Lookup we can use External Definition.
With the Help of the Blog given by Mak, U can Design the Rceiver DT with Statement,Action,Table Access Elements.
Regard's
Preethi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.