Skip to Content
0
Mar 15, 2011 at 04:24 PM

Reading and comparing remote database entries

56 Views

Dear experts,

I have a requirement to connect to a remote database from PI (I will probably use a JDBC adapter CC), read out data records there and compare them to data that I get from R3 in XML format (RFC R3 to PI). After getting rid of duplicates PI will send this data from R3 to the remote database.

I do not know how to start. think getting the records from the remote database will not be a big problem. I assume I get those into PI in XML format. But where do I compare those database records with the XML that I get from R3?

Has anyone ever done something like that? Thank you for any hints!

Best regards,

Peter