is there any way to integrate SAP API to Metabase ?
Metabase officially supports 15+ databases with integrated drivers - and many more via third-party drivers for other databases.
There’s no definitive list of third-party drivers yet, so you have to search for them.
If you can use SAP API with SQL Server (or another database) as warehouse, then that’s currently the best solution:
Multiple databases in one question without a data warehouse- YES YOU CAN!
There’s a couple of SAP-related requests, but I haven’t seen any third-party drivers:
https://github.com/metabase/metabase/issues/9554 - WDSL
https://github.com/metabase/metabase/issues/5713 - HANA
But there’s not a request for SAP API specifically.