nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

747842_de-DE

liliconcom

Any customers connecting to SAP databases?

Hi All,

I have a customer interested in purchasing JMP and are curious about using it to access their data on their SAP database. I know that there are SAP HANA and SAP ODBC drivers are available, but curious to see if anyone has any practical experience with customers setting up connections/database queries?

Cheers,

Ben

Re: Any customers connecting to SAP databases?

Hi Ben,

Sorry, I do not have real feedback about SAP database usage in JMP.

But Minitab made this annoucement today and if your customer is interested by SPC, you may have a competitor...... https://www.minitab.com/en-us/products/real-time-spc/?locale=en-US

Florence

Re: Any customers connecting to SAP databases?

hi @Benben,

good question? could open a lot of use cases.

At my time in EM I struggled a lot on this and I was not able to connect JMP with SAP HANA.

Back in the years I found a discussionin the community about that :

SAP to JMP - JMP User Community

I think that JMP 17 and 18 simplified a bit this process so would be helpful to reassess it, but at that time I was not able to find a solution (probably there where other problems like access, security, etc).

Re: Any customers connecting to SAP databases?

With a robust API (I am assuming this customer is using HANA), they should be able to use HTTP Request (); to build an interface to their data and subsequently refresh it on JMP Live:
https://help.sap.com/docs/SAP_HANA_PLATFORM/52715f71adba4aaeb480d946c742d1f6/0e5335b66a9e4c64993605fc24ccd6d1.html

Have they tried that?

Re: Any customers connecting to SAP databases?

Hi Ben,

here is another old post where you get some driver information: https://community.jmp.com/t5/JMP-SE-Discussions/Connecting-JMP-to-SAP/m-p/12318 . I know that Peter Bewerunge from Accantec wrote a C# wrapper to be able to pull data from SAP. And some customers extract an Excel sheet from SAP.

I wonder if the new options in our connectors allow better access to SAP. As SAP is used very often on our customer side and with the new information on Minitab Real-Time SPC with SAP partnership it might be something to investigate further from our product management @Daniel_Valente or development @briancorcoran . Also with regard to JMP Live @dieter_pisot accessing data directly from SAP Hana?

Martin

Betreff: Stellen irgendwelche Kunden eine Verbindung zu SAP-Datenbanken her?

@Daniel_Valente, der Kunde möchte an dieser Stelle (hoffentlich in der Zukunft) lediglich eine Verbindung zu JMP auf Benutzerebene herstellen, um Daten individuell im Vergleich zu JMP Live einzubinden. Ich gehe davon aus, dass derselbe Prozess einer HTTP-Anfrage für Standard-JMP verwendet werden kann?