cancel
Showing results for 
Search instead for 
Did you mean: 

SAP NI to MaxDB Protocol Document: updates with a PLC

Former Member
0 Kudos

Is there a definitive specification document for the SAP network protocol / SQLCLI used to communicate (command line) with a MaxDB database? Our aim is to directly UPDATE table data from a networked device such as am Allen Bradley or Siemens S7 1200 PLC running on the customeru2019s manufacturing plant. Note that a PLC does not run Windows etc. and therefore cannot use ODBC, OPC or any other driver. There are snippets of information on the Web but none fully explain the TCP packets as seen using Wireshark for queries such as u201Cupdate tablename set column=255u201D. Thatu2019s all we want to do!

(We can already do this with an Allen Bradley Rockwell CompactLogix PLC and a MySQL database.)

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

thorsten_zielke
Contributor
0 Kudos

No, we do not have a definitive specification document for the current MaxDB versions.

If anyhow possible, try using JDBC.

Other than that, you could search the web for 'MaxDB' and 'xorder7'. This should show a specification Word doc of about 150 pages. Not sure if that really helps, though...

Former Member
0 Kudos

Can you send to me a link/URL to the document? I couldn't find it.

As for using JDBC - PLCs do not run an OS like Linux or Windows so this is not an option: we are speaking ladder logic here.

Regards,

Edited by: Johnsonfamily38 on Nov 28, 2011 8:51 PM

thorsten_zielke
Contributor
0 Kudos

I have sent you an email with the doc attached, but please note that if you work with that document, I cannot give you any further support, so you would be on your own...

Hope it helps,

Thorsten

Former Member
0 Kudos

Thanks for the document. It contains some important clues to what the TCP network packets contain.

Regards,