4 weeks ago
Are there any recommended methods for extracting large table data from ECC / S4H via a remote connection?
Function Module RFC_READ_TABLE is available but not release for customer use and therefore not recommended. What would be a suitable alternative (SAP, custom, or 3rd party) for extracting large tables (million+ records)?
My understanding is that CDS views are also not recommended for extracting large volumes of table data?
Never use RFC_READ_TABLE nor bypass the ABAP system and access the data directly in the underlying database. Instead write a dedicated remote enabled function module that does proper authorization checks and is well-defined for the concrete use-case.
In case your ABAP system is new enough you can also access CDS views via SQL Services and the ABAP ODBC driver, see https://help.sap.com/docs/btp/sap-business-technology-platform/accessing-abap-managed-data-from-exte.... Also with that approach security aspects can be considered in a proper way
Best regards,
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello,
maybe you can use odbc connection for remote db? Otherwise r3trans can also extract tables from data on os level
br
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandra,
Extract to something like a sql db, external to SAP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
11 | |
10 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.