topic Re: can i install pyrfc library in Fabric notebook in Data Engineering

can i install pyrfc library in Fabric notebook

sreekanthreddy — Wed, 22 Jan 2025 07:17:06 GMT

Can I install the Pyrfc library in fabric notebooks?

To establish a connection

between SAP ECC and Fabric notebooks to read tables from SAP ECC and load them into one lake house

by using this code

# Define SAP ECC connection parameters

sap_connection_params = {

'user': 'your_username',

'passwd': 'your_password',

'ashost': 'your_sap_host',

'sysnr': 'your_system_number',

'client': 'your_client_number',

'lang': 'EN'

}

govindarajan_d

Re: can i install pyrfc library in Fabric notebook

nilendraFabric — Wed, 22 Jan 2025 07:41:31 GMT

Hi sreekanthreddy

If you have administrator access, you could potentially create a custom Fabric environment that includes the necessary SAP NWRFC SDK and PyRFC library.

https://learn.microsoft.com/en-us/fabric/data-engineering/environment-manage-library

Pip install wont work in you case because PyRFC requires the SAP NWRFC SDK, which is not pre-installed in Fabric environments. The SAP NWRFC SDK is not publicly available and requires SAP credentials to download

Re: can i install pyrfc library in Fabric notebook

govindarajan_d — Wed, 22 Jan 2025 08:13:49 GMT

Hi sreekanthreddy,

Spark in Fabric supports installing new libraries and working with them. But from the Github URL of the package (https://github.com/SAP-archive/PyRFC), I see that it is no longer maintained. And also it asks for Cython to be installed in the environment for using it. (there is a possibility you might have to build it from source). It would be difficult to setup Fabric Spark environment with all the pre-requisites to use PyRFC.

Apart from that, your Fabric environment should be configured to be in the same network as your SAP ECC network, so that when the script runs, it can access your SAP machine.

https://learn.microsoft.com/en-us/fabric/security/security-managed-vnets-fabric-overview

Considering the effort to setup and the complexity of maintaining this, I would recommend using an ETL tool that supports SAP connector to bring data. Check ADF once where you have the option to connect SAP ECC in different ways.

Re: can i install pyrfc library in Fabric notebook

v-prasare — Tue, 28 Jan 2025 12:22:09 GMT

Hi sreekanthreddy, Thanks for actively participating Fabric community support.

govindarajan_d, nilendraFabric Thanks for your promt response.

sreekanthreddy, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution we have provided for your issue worked? or let us know if you need any further assistance here?

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

Re: can i install pyrfc library in Fabric notebook

v-prasare — Fri, 31 Jan 2025 06:23:44 GMT

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

Re: can i install pyrfc library in Fabric notebook

v-prasare — Fri, 07 Feb 2025 05:56:51 GMT

Your feedback is important to us, Looking forward to your response.

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.