Guidance on SAP S4/HANA Data Ingestion Configuration and Host/Port Settings

ingestion
1

Original Slack Thread

Hey, <@U06TM7M40RK>, Now looking to ingest from SAP S4/HANA for BW and have draft configured and tested the recipe.
tried a few ports as per sparse information I could find around the web
is there a background on prerequisites for SAP S4/HANA ingestion ie:
• How does the configuration align to SAP HANA Eclipse Modeling Tool
• How to find the Host and Port for the ingestion
Thanks!

2

It seems likely that you’re looking to ingest data from SAP S4/HANA into DataHub and are seeking guidance on configuration, particularly regarding the host and port settings. Based on the available data sources, here are some insights that might help:

  1. Configuration Alignment with SAP HANA Eclipse Modeling Tool: The ingestion process for SAP HANA in DataHub uses the SQLAlchemy Dialect for SAP HANA, which is compatible with HANA or HANA express versions since HANA SPS 2. This dialect is not an official SAP product and is not covered by SAP support, but it is actively maintained by SAP SE (https://datahubproject.io/docs/0.13.1/generated/ingestion/sources/hana#integration-details|source).

  2. Finding the Host and Port for Ingestion: The default configuration for SAP HANA ingestion in DataHub uses localhost:39041 as the host and port (https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/sql/hana.py|source). However, this might not be applicable to your setup, especially if you’re working with a remote SAP S4/HANA instance. You would typically need to obtain the correct host and port from your SAP system administrator or through the SAP HANA Eclipse Modeling Tool, which might provide connection details.

  3. Starter Recipe for Ingestion: There is a starter recipe available for setting up SAP HANA ingestion in DataHub. This includes specifying the host, port, database name, username, and password in the configuration (https://datahubproject.io/docs/0.14.0/generated/ingestion/sources/hana|source).

If you need more detailed steps or have specific questions about the setup, please let me know!

Sources:

3

Hi :slight_smile: ! Did this interaction resolve your issue or do you still require assistance ?

Please tag @ RunLLM if you still need further assistance !

Or tag @Datahub Community Support if you require a person to take a look :slight_smile:

Hope this helps ! ><