SAP ECC (RFC) (Beta)
SAP ECC (ERP Central Component) is SAP’s core on-premise ERP system that integrates key business processes such as finance, logistics, human resources, and supply chain management. The RFC (Remote Function Call) interface enables communication between SAP ECC and external systems, allowing remote execution of SAP functions for seamless integration and data exchange.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- SAP ECC must be accessible from the iceDQ server.
- Valid credentials to access SAP ECC database.
- SAP ECC JDBC version 2.0 or above.
This connector is currently in Beta version and should not be used in production environments.
Authentication Mechanism
The following authentication mechanism is supported.
- Username and Password
Connection Properties
Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Prod_sales_conn |
| Driver * | Driver used to establish the connection. One driver is available by default. | SAP ECC Custom JDBC |
| Scheme * | The scheme type – either Application, or Group. | Application |
| Host * | The endpoint (hostname) of the SAP ECC server. | sap-ecc-server.acme.com or 194.186.53.47 |
| Gateway Host * | Hostname of the gateway server used for routing SAP connections. | gateway.sap-ecc.acme.com or gateway.194.186.53.47 |
| System Number * | SAP system number. Usually a two-digit number identifying the SAP instance. | 01 |
| System ID * | SAP system ID (SID). A unique 3-character code identifying the system. | ECC |
| Client * | SAP client number. A three-digit logical system identifier. | 100 |
| Type * | The connection type, either System Connection or User Connection. Refer Connections for more details. | System |
| Username * | SAP application login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | Admin@123 |
Custom Properties
The following optional connection properties can be configured based on user requirements.
| Property | Default Value | Possible Values | Description |
|---|---|---|---|
| ReadTableFunction | RFC_READ_TABLE | String | Name of the SAP function used to read tables. |
| Pagesize | 10000 | Integer | Number of rows fetched per request. |
Supported Datatypes
The following datatypes are supported.
- BIGINT
- DATE
- DECIMAL
- DOUBLE
- FLOAT
- INTEGER
- STRING
- TIME
- VARCHAR