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