SAP HANA
SAP HANA is an in-memory database platform that provides real-time analytics and data processing capabilities, enabling businesses to analyze large volumes of data quickly and efficiently for better decision-making.
Power end-to-end data operations for your SAP HANA API with Nexla. Our bi-directional SAP HANA connector is purpose-built for SAP HANA, making it simple to ingest data, sync it across systems, and deliver it anywhere — all with no coding required. Nexla turns API-sourced data into ready-to-use, reusable data products and makes it easy to send data to SAP HANA or any other destination. With comprehensive monitoring, lineage tracking, and access controls, Nexla keeps your SAP HANA workflows fast, secure, and fully governed.
Features
Type: API
- Seamless API Integration: Connect to any endpoint as source or destination without coding, with automatic data product creation
- Visual Composition & Chaining: Build complex integrations using visual templates, chain API calls, and compose workflows with data validation and filtering
- API Proxy: Expose curated slices of your data securely with a secure and customizable API proxy that validates and transforms data on the fly
- Request optimization with intelligent batching, retry, and caching to minimize API calls and costs
Prerequisites
Before creating a SAP HANA credential, you need to obtain your API key and identify your SAP HANA Cloud hostname from your SAP HANA account. SAP HANA uses API key authentication for all API requests, with the API key sent in the APIKey header.
To obtain your SAP HANA API credentials, follow these steps:
-
Sign in to your SAP HANA account using your administrator credentials.
-
Navigate to your SAP HANA Cloud account settings or API management section in the SAP HANA interface.
-
Look for the API or API Keys section in your account settings, or navigate to Settings > API or Developers > API Keys.
-
If you don't have an API key yet, look for the option to generate or view your API key.
-
Click Generate API Key or Create API Key to create a new API key.
-
Configure your API key settings:
- Enter a name for the API key (e.g., "Nexla Integration")
- Review and select the permissions or scopes for the key (if applicable)
-
Click Generate or Create to create the API key.
-
Copy the API key immediately after it's generated, as it may not be accessible again after you navigate away from the page.
-
Navigate to your SAP HANA Cloud account settings to find your SAP HANA Cloud hostname. The hostname is typically in the format
sandbox.api.sap.com/s4hanacloudor your custom hostname. You can find this in your SAP HANA Cloud account settings or on the account details page. -
Store both the API key and hostname securely, as you will need them to configure your Nexla credential. The API key is sensitive information and should be kept confidential.
The API key is sent in the APIKey header for all API requests to the SAP HANA API. The hostname determines which SAP HANA Cloud instance your API requests will be sent to. The API key authenticates your requests and grants access to SAP HANA resources based on your account permissions. If your API key is compromised, you should immediately revoke it in your SAP HANA account settings and generate a new one. For detailed information about obtaining API keys, hostnames, API authentication, and available endpoints, refer to the SAP HANA API documentation.
Authenticate
Credentials required
| Field | Required | Secret | Description |
|---|---|---|---|
| SAP HANA Cloud Hostname | No | Yes | SAP HANA Cloud Hostname |
| SAP HANA API Key | No | Yes | SAP HANA API Key |
Create a credential in Nexla
- To create a new SAP HANA credential, after selecting the data source/destination type, click the Add Credential tile to open the Add New Credential overlay.
New Credential Overlay – SAP HANA
-
Enter a name for the credential in the Credential Name field and a short, meaningful description in the Credential Description field.
-
SAP HANA uses API key authentication for all API requests. Enter your SAP HANA Cloud hostname in the SAP HANA Cloud Hostname field. This should be your SAP HANA Cloud hostname, typically in the format
sandbox.api.sap.com/s4hanacloudor your custom hostname. The hostname determines which SAP HANA Cloud instance your API requests will be sent to. You can find your hostname in your SAP HANA Cloud account settings. -
Enter your SAP HANA API key in the SAP HANA API Key field. This is the API key you obtained from your SAP HANA account settings (API or API Keys section). The API key is sent in the
APIKeyheader for all API requests to the SAP HANA API. The API key is sensitive information and must be kept confidential.Your SAP HANA API key can be found in your SAP HANA account settings under the API or API Keys section. The API key is sent in the
APIKeyheader for all API requests to the SAP HANA API. The hostname should match your SAP HANA Cloud hostname, which can be found in your SAP HANA Cloud account settings.If your API key is compromised, you should immediately revoke it in your SAP HANA account settings and generate a new one. The API key provides access to your SAP HANA account data and should be treated as sensitive information. Keep your API key secure and do not share it publicly.
For detailed information about obtaining API keys, hostnames, API authentication, and available endpoints, see the SAP HANA API documentation.
-
Click the Save button at the bottom of the overlay. The newly added credential will now appear in a tile on the Authenticate screen during data source/destination creation.
Use as a data source
To create a new data flow, navigate to the Integrate section, and click the New Data Flow button. Select the SAP HANA connector tile, then select the credential that will be used to connect to your SAP HANA account, and click Next; or, create a new SAP HANA credential for use in this flow.
Endpoint templates
Nexla provides pre-built templates that can be used to rapidly configure data sources to ingest data from common SAP HANA endpoints. Each template is designed specifically for the corresponding SAP HANA endpoint, making data source setup easy and efficient. Select the endpoint from which this source will fetch data from the Endpoint pulldown menu. Available endpoint templates are listed in the expandable boxes below.
Once the selected endpoint template has been configured, click the Test button to the right of the endpoint selection menu to retrieve a sample of the data that will be fetched. Sample data will be displayed in the Endpoint Test Result panel on the right, allowing you to verify that the source is configured correctly before saving.
Manual configuration
SAP HANA data sources can also be manually configured to ingest data from any valid SAP HANA API endpoint, including endpoints not covered by the pre-built templates, chained API calls, or custom query parameters. Select the Advanced tab at the top of the configuration screen, and follow the instructions in Connect to Any API to configure the API method, endpoint URL, date/time and lookup macros, path to data, metadata, and request headers.
The SAP HANA API typically uses the GET method for retrieving data from endpoints. The API endpoint URL should include your SAP HANA Cloud hostname (from your credential) plus the API path, for example /sap/opu/odata/sap/API_SALES_ORDER_WITHOUT_CHARGE_SRV/A_SalesOrderWithoutCharge. For the Response Data Path, use $.d.results[*] to extract all items from the results array, or $ to extract the entire response for single-record endpoints, depending on your endpoint.
Once all of the relevant settings have been configured, click the Next button to proceed with the rest of the data flow configuration, or click Save to save the data source configuration for later use.