# Connect Ignition with SAP **URL:** \ **Category:** Ignition\ **Created:** [November 3, 2022, 9:57am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051 "2022-11-03T09:57:59Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Post date:** [November 3, 2022, 9:58am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/1 "2022-11-03T09:58:00Z")
I got steps to configure Ignition with SAP JCo Jar file I am not getting where we need to write the python scripts in Ignition and how to run. please can you send the steps. ....................................................................................................................... sapSystem="QAS" from com.sap.conn.jco import JCoDestinationManager destination = JCoDestinationManager.getDestination(sapSystem) function = destination.getRepository().getFunction("RFC\_READ\_TABLE") ``` inputTableParam = function.getTableParameterList().getTable("FIELDS") inputTableParam.appendRow() inputTableParam.setValue("FIELDNAME", "CHECT") inputParamList = function.getImportParameterList() inputParamList.setValue("QUERY_TABLE", "PAYR") inputParamList.setValue("DELIMITER", ";") optionsTableParam = function.getTableParameterList().getTable("OPTIONS") optionsTableParam.appendRow() optionsTableParam.setValue("TEXT", "CHECT = '436396'") function.execute(destination) table = function.getTableParameterList().getTable("DATA") print table ``` .............................................................................................................................. I have written this code in Script console, I am getting error as below: ![MicrosoftTeams-image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/f/2f9e861a3ca1c38ff98f8fc5627d85d812c08df5.png) ---
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [November 3, 2022, 10:26am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/2 "2022-11-03T10:26:51Z")
Hi, May be a bit off topic, but why not use the Sepasoft SAP Certified Business Connector? See [Interface for SAP ERP is certified by SAP Labs | Sepasoft MES Solutions](https://www.sepasoft.com/products/interface-for-sap-erp/) ---
**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Post date:** [November 3, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/3 "2022-11-03T10:31:26Z")
In our company they dont want use Sepasoft. we want to get data from SAP to Ignition. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 3, 2022, 11:58am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/4 "2022-11-03T11:58:56Z")
You have python syntax error from improper indentation. Nothing to do with your library or SAP. Fix your syntax. (Learn how python uses whitespace and follow the rules.) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [November 3, 2022, 1:10pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/5 "2022-11-03T13:10:31Z")
Tip: use the \ code formatting button when posting code. It will indent properly (important for Python) and give syntax highlighting. You can use the 🖉 edit link to fix your post. Select the code block and press \. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [November 18, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/6 "2022-11-18T18:05:24Z")
Did you get your code to work? I very much want to read data from SAP as well. ---
**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Post date:** [November 21, 2022, 6:06am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/7 "2022-11-21T06:06:49Z")
few steps we succeeded, still getting error. You can get some details in the below link. > [@Connecting to SAP with 3rd party Python lib or SAP JCo jar](https://forum.inductiveautomation.com/t/connecting-to-sap-with-3rd-party-python-lib-or-sap-jco-jar/40712/22): > > This is your problem. The Designer Script console does not run your script in the gateway process. You need to put your SAP code into a gateway message handler, or better, in a script module called from a message handler. In the designer's script console, use system.util.sendRequest() to cause your code to run in the gateway process. (And retrieve any return value.) ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [December 13, 2022, 9:03pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/8 "2022-12-13T21:03:03Z")
How is your progress @kavya_shree? @gnguyen I think Sepasoft is slower than custom SQL and not as effective with Perspective. ---
**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Post date:** [December 14, 2022, 4:09am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/9 "2022-12-14T04:09:25Z")
we are able to call BAPI from Ignition without using Sepasoft. ---
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [December 14, 2022, 9:40am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/10 "2022-12-14T09:40:48Z")
Sure, using JCO lib helps. But for whom is not a developer, using third party modules (and certified) is a real accelerator. And what about updates... Maintenance of system can be a nightmare. Also, think that end user are likely to want low or no code solution... ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [December 14, 2022, 2:22pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/11 "2022-12-14T14:22:20Z")
What is BAPI? business application interface? I don't know how you mean. Do you mean that you have a perspective page that shows the SAP BAPI Explorer? I was wondering about running queries on data in SAP to use in my graphs and tables on perspective pages. Do you have some links to help me? Can I request somewhere to get videos on implementations accessing SAP from Ignition without Sepasoft or do the videos exist, and I don't know it? ---
**Author:** ![kavya\_shree](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kavya\_shree](https://forum.inductiveautomation.com/u/kavya_shree)\ **Post date:** [December 15, 2022, 8:18am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/12 "2022-12-15T08:18:14Z")
BAPIs are the primary method through which customer code and third-party applications interact with SAP products. I didn't find any videos on this, we tried using Forum Help only. U can refer all the steps in the previous links. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [November 1, 2023, 7:04pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/13 "2023-11-01T19:04:33Z")
Supposed to be some prebuilt connectors and webhooks in SAP HANA. I can find them for a ton of services, but not Ignition yet. [https://www.youtube.com/watch?v=OuTDEjFBvP4](https://www.youtube.com/watch?v=OuTDEjFBvP4)] [SAP Business Accelerator Hub](https://api.sap.com/api/sqlserver/resource/Query)] There is one for MS SQL. I don't know enough about how to implement it yet. ---
**Author:** ![raj\_patel4041](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@raj\_patel4041](https://forum.inductiveautomation.com/u/raj_patel4041)\ **Post date:** [May 1, 2025, 5:00am UTC](https://forum.inductiveautomation.com/t/connect-ignition-with-sap/66051/14 "2025-05-01T05:00:17Z")
kavya\_shree - Can you please share the complete code and where you write that code to talk to Bapi without Sopasoft?