Connect Ignition with SAP

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:

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

In our company they dont want use Sepasoft. we want to get data from SAP to Ignition.

1 Like

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.)

1 Like

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 </>.

Did you get your code to work?

I very much want to read data from SAP as well.

few steps we succeeded, still getting error.
You can get some details in the below link.

How is your progress @kavya_shree?

@gnguyen
I think Sepasoft is slower than custom SQL and not as effective with Perspective.

we are able to call BAPI from Ignition without using Sepasoft.

2 Likes

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...

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?

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.

1 Like

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]

SAP Business Accelerator Hub]
There is one for MS SQL.
I don't know enough about how to implement it yet.