I researched on forums, and came across interesting thing: proxy could send all data to a stored procedure and stored procedure could handle to push data to multiple database/tables. This way any schemea changes on tables does not need to have a ripple effect on PI.
is my understanding correct?
I understand a stored procedure wil need to be developed in this case.
Are there any blogs which show a proxy to jdb /stored procdure scenario?
Yes, the understanding is correct. Using one stored procedure is an option for you. Ask your database team if they are ready to develop the SP. There won't be any direct blog. Instead search separate blogs about SP and client proxy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.