Quote from bsdinsight on 14 November 2023, 19:07

Tài liệu sau đây hướng dẫn kết nối Power Query Online vào SAP HANA

To connect to SAP HANA data from Power Query Online:

1. From the Data sources page, select SAP HANA database.

2. Enter the name and port of the SAP HANA server you want to connect to. The example in the following figure uses SAPHANATestServer on port 30015.

3. Optionally, enter an SQL statement from Advanced options. More information, Connect using advanced options

4. Select the name of the on-premises data gateway to use for accessing the database.

    Note: You must use an on-premises data gateway with this connector, whether your data is local or online.

5. Choose the authentication kind you want to use to access your data. You’ll also need to enter a username and password.

    Note: Currently, Power Query Online only supports Basic authentication.

6. Select Use Encrypted Connection if you’re using any encrypted connection, then choose the SSL crypto provider. If you’re not using an encrypted connection, clear Use Encrypted Connection. More information: Enable encryption for SAP HANA

   

7. Select Next to continue.

8. From the Navigator dialog box, you can either transform the data in the Power Query editor by selecting Transform Data, or load the data by selecting Load.