JMP can connect to SAP through an ODCB driver.
I'd try using the Query Builder, (File/Database) to get started and then get the connection string from the resulting data table.
JMP puts a script in the data table that can be edited.
