search

SAP / sqlalchemy-hana

SQLAlchemy Dialect for SAP HANA
Apache License 2.0
128 stars 56 forks source link

sqlalchemy dialect for SAP R/3 #40

Closed amarvin closed 6 years ago

amarvin commented 6 years ago

Is there any plan to make a similar sqlalchemy dialect for connecting to SAP R/3 systems? Sorry that this isn't the most appropriate location to request this, but I couldn't find a better place. Maybe it could be built on top of PyRFC.

jarus commented 6 years ago

I don't know about any concrete plans for such a dialect. Could you maybe explain what exactly do you have in mind? SAP R/3 systems are a layer above the database and SQLAlchemy operations only on databases.

amarvin commented 6 years ago

I'm not an expert on SAP R/3 systems, but I use data from it in many of my applications. It would be ideal to execute R/3 transaction codes from Python for accessing data -- do you think that's possible?

If transaction codes can't be accessed, then accessing the underlying table data (and later recreating the business logic of the transaction codes) would be the next best option. In that case, I was thinking remote function calls using PyRFC (e.g. READ_TABLE_DATA) could be an option, but it's tedious to read one table at a time with the appropriate filters. An ORM would be much better!

jarus commented 6 years ago

I'm sorry but there are no concrete plans to support your use-case in the near future. Especially not as part of this project.

I understand your motivation but the main goal of SAP systems is to provide functions and methods above your data. I amn't an expert but most functions and transactions are maybe wrappable with an RFC call and then usable via PyRFC.