Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level V

SAP to JMP

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

5 REPLIES 5
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: SAP to JMP

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

-Jeff
Highlighted
vkessler
Level IV

Re: SAP to JMP

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

 

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: SAP to JMP

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.

-Jeff
Highlighted
singhan
Level I

Re: SAP to JMP

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)

Highlighted
vkessler
Level IV

Re: SAP to JMP

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

Article Labels

    There are no labels assigned to this post.