Which Extension Should I Use?

This guide helps you choose between ERPL and ERPL-Web based on your SAP environment and use case.

Quick Decision

• On-premise SAP behind firewall → Use ERPL
• Cloud/web SAP with HTTP APIs → Use ERPL-Web

Extension Comparison

Feature	ERPL (On-Premise)	ERPL-Web (Cloud/Web)
Target Environment	On-premise SAP systems	Cloud/web SAP services
Network Access	SSH tunnel or direct network	HTTP/HTTPS APIs
Primary Protocols	RFC, BICS, ODP	OData, Datasphere, ODP Web
Installation	INSTALL 'erpl'	INSTALL 'erpl_web'
Use Case	Enterprise SAP ERP/BW	SAP cloud services, web APIs

Architecture Comparison

Protocol Deep Dive

🏢 ERPL Protocols

RFC (Remote Function Call)

• What: Direct access to SAP tables and function modules
• Use case: Read master data, call BAPIs
• Example: sap_rfc_read_table('KNA1')

BICS (BI Consumer Services)

• What: Execute SAP BW queries
• Use case: Analytics, reporting from SAP BW
• Example: sap_bics_open_query('ZQUERY_SALES')

ODP (Operational Data Provisioning)

• What: Delta replication from SAP systems
• Use case: Real-time data streaming, ETL
• Example: sap_odp_extract('VBAK', mode => 'DELTA')

☁️ ERPL-Web Protocols

OData

• What: RESTful web services for SAP data
• Use case: Cloud integration, web applications
• Example: odata_query('https://api.sap.com/Orders')

Datasphere

• What: Native connection to SAP Datasphere
• Use case: Cloud analytics, data modeling
• Example: datasphere_query('SALES_ANALYTICS')

ODP Web

• What: ODP via OData protocol
• Use case: Cloud delta replication
• Example: odp_web_extract('VBAP', delta => true)

Decision Matrix

Your Situation	Recommended Extension	Why
SAP ERP behind corporate firewall	ERPL	RFC provides direct table access
SAP BW on-premise	ERPL	BICS enables query execution
SAP Datasphere cloud	ERPL-Web	Native Datasphere integration
SAP OData services	ERPL-Web	HTTP-based OData protocol
Hybrid environment	Both	Use ERPL for on-premise, ERPL-Web for cloud
Real-time replication	ERPL	ODP provides efficient delta replication
Web application integration	ERPL-Web	HTTP APIs work better in web contexts

Interactive Decision Quiz

Not Sure Which to Choose?

Answer these questions to find the right extension:

1. Where is your SAP system located?

   • a) On-premise behind firewall → ERPL
   • b) Cloud/web-based → ERPL-Web

2. How do you access SAP data?

   • a) Direct network connection → ERPL
   • b) HTTP/HTTPS APIs → ERPL-Web

3. What's your primary use case?

   • a) Read SAP tables directly → ERPL
   • b) Query web services → ERPL-Web

4. Do you need real-time replication?

   • a) Yes, from on-premise SAP → ERPL
   • b) Yes, from cloud SAP → ERPL-Web

Installation Commands

ERPL (On-Premise)

INSTALL 'erpl' FROM 'http://get.erpl.io';
LOAD 'erpl';

ERPL-Web (Cloud/Web)

INSTALL 'erpl_web' FROM 'http://get.erpl.io';
LOAD 'erpl_web';

Next Steps

If You Chose ERPL (On-Premise)

1. Install ERPL
2. Quick Start Guide
3. Read SAP Tables
4. RFC Deep Dive

If You Chose ERPL-Web (Cloud/Web)

1. Install ERPL-Web
2. Quick Start Guide
3. Query OData Services
4. OData Deep Dive

If You Need Both

1. Install both extensions
2. Use ERPL for on-premise systems
3. Use ERPL-Web for cloud services
4. Integration Examples

Still Not Sure?

Need More Help?

• Check our real-world examples
• Browse use case scenarios
• Contact our support team

Pro Tip

You can install both extensions and use them together. Many enterprises use ERPL for on-premise SAP systems and ERPL-Web for cloud services in the same DuckDB instance.