Forum Discussion
SAP HANA CLOUD CONNECTION
Hello, I am trying to get data from SAP HANA CLOUD by using dataflow gen 2. also I have tried with SAP HANA Database connector. I want end to end connection setup guidelines. Anyone Help ?
To set up an e2e connection from SAP HANA Cloud to Fabric Dataflow Gen2, you need to get three things right: connectivity, authentication, and connector choice. First, ensure your SAP HANA Cloud instance is accessible from the internet or via a secure tunnel (IP allowlist or SAP BTP Cloud Connector if it is private). For OData, expose your HANA data via an XSODATA service or CAP service and confirm the service URL works in a browser with auth (usually Basic or OAuth). In DataflowGen2, use the OData connector, provide the service root URL, and configure credentials (Basic is most common). If using the SAP HANA database connector instead, you need the host, port (typically 443 for HANA Cloud), and user credentials, and ensure outbound connectivity from Fabric is allowed. OData is simpler and more reliable for Dataflow Gen2, while direct HANA connection is better for large volume ingestion but requires stricter network setup. Finally, validate by previewing data, then publish and schedule refresh; if it fails, the issue is almost always network access or auth mismatch.
1 Reply
- Vinodh247
Super User
To set up an e2e connection from SAP HANA Cloud to Fabric Dataflow Gen2, you need to get three things right: connectivity, authentication, and connector choice. First, ensure your SAP HANA Cloud instance is accessible from the internet or via a secure tunnel (IP allowlist or SAP BTP Cloud Connector if it is private). For OData, expose your HANA data via an XSODATA service or CAP service and confirm the service URL works in a browser with auth (usually Basic or OAuth). In DataflowGen2, use the OData connector, provide the service root URL, and configure credentials (Basic is most common). If using the SAP HANA database connector instead, you need the host, port (typically 443 for HANA Cloud), and user credentials, and ensure outbound connectivity from Fabric is allowed. OData is simpler and more reliable for Dataflow Gen2, while direct HANA connection is better for large volume ingestion but requires stricter network setup. Finally, validate by previewing data, then publish and schedule refresh; if it fails, the issue is almost always network access or auth mismatch.