Updation of data into SQL database from ECC

[Former Member]

Hi Friends,

I have a requirement to update the data from ECC to external SQL database.

Here is the requirement I am getting the XML file from third party vendor through PI. In inbound proxy I am extracting the XML and putting into local internal tables. Now my requirement is  instead of storing the data into ECC(due to  large high volume of data) I need to store the data into external SQL database. For this I need some logic how to connect SQL database and command to insert the data when I have the internal table.

Please provide me the solution and it would be highly appreciable.

Thanks,
Satheesh

[srinivasan_vinayagam]

Hi Satheesh,

Regards,

V Srinivasan

[Former Member]

Hi Srinivasan,

I am looking for the commands and syntax to insert the data into SQL database from ECC internal table.

Thanks for the reply,

Thanks,
Satheesh

[srinivasan_vinayagam]

Hi Satheesh,