topic Re: SAP to JMP in Discussions

SAP to JMP

tom_abramov — Sun, 21 Aug 2016 14:26:23 GMT

Is there any way to import/export data between JMP and SAP?

Re: SAP to JMP

Jeff_Perkinson — Mon, 22 Aug 2016 22:03:44 GMT

It looks like SAP HANA has an ODBC driver. JMP can import from any database that supports ODBC. That means you can use the Query Builder.

-Jeff

Re: SAP to JMP

vkessler — Mon, 14 Jan 2019 13:10:06 GMT

Hi Jeff,

is there a solution using BAPI or IDocs to get data out of SAP and into JMP, if SQL queries are prohibited ?

It seems, that Java, C# etc. is usually used for BAPI or IDocs...

Thank you

Victor

Re: SAP to JMP

Jeff_Perkinson — Mon, 14 Jan 2019 15:18:25 GMT

I'm not familar with those two structures/methods but if BAPI is a REST API then you can use the HTTP Request() object in JMP 14 to connect to it and retrieve data.

Re: SAP to JMP

singhan — Tue, 17 Dec 2019 23:07:26 GMT

Hi Jeff,

I have a couple of challenges here.

1. The SAP table accesses are available to me through a 32bit ODBC driver. I am struggling with 'how do I frame my question to get them create an oracle database link for me on 64bit-ODBC?' so I can connect to the tables.

2. The tables are huge. I dont need all of that data. So is there a way I can only pull "an existing transaction from SAP" into JMP ?

(a transaction in SAP is pretty much a saved query)

Re: SAP to JMP

vkessler — Sat, 11 Jul 2020 07:38:22 GMT

If a query via ODBC, BAPI or IDocs is not an option for you, or if you only want data from specific transactions in SAP, I finally found a solution using SAP GUI Scripting.

The procedure is as follows:

1. Generate a VBS script with SAP GUI Scripting, where you run the transaction and export the data to an excel data table (XLSX)

2. Include the VBS script in your JSL code

3. Import the data from the excel table to JMP

4. Do your data analysis in JMP

This of course only works, if SAP GUI Scripting is enabled.

If you want full automation, you need to automatically login to SAP.

I hope this helps! It worked for me :)

Best

Victor