If I want to connect to SAP BW/4HANA from Denodo, I would try creating a [Multidimensional data source](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/multidimensional_database_sources/multidimensional_database_sources) in Virtual DataPort and retrieve the data from SAP. To connect to a Composite data Provider, you could do the following steps:
* Create a BExQuery over the composite provider.
* Then try to create a base view accessing the BExQuery.
You could take a look at the [Denodo and SAP Best practices](https://community.denodo.com/kb/view/document/Denodo%20and%20SAP%20Best%20Practices?category=Data+Sources) Knowledge Base Article for more information.
Hope this helps!