Forum Discussion

erezbenmoshe's avatar
erezbenmoshe
Advocate I
8 years ago
Solved

Connecting to MAGENTO (eCommerce platform)

Hello,   Has anybody tried to connect to https://magento.com/?  If anyone did, I would appreciate some reference.   Thanks
Need Help
erezbenmoshe's avatar
erezbenmoshe
Advocate I
8 years ago

This is very helpful.

Is there any tutorial specificially about how to use this API from PB? 

I am also looking for examples.

 

Thanks

  • Winedirect's avatar
    Winedirect
    New Member
    7 years ago

    Hi Eresbenmoshe

     

    Did you every get this working?  I am trying to figure it out myself at the moment.

     

    Mark B

    • erezbenmoshe's avatar
      erezbenmoshe
      Advocate I
      7 years ago

      Hi, 

       

      No, I didn't.  If you find a way, I would love to hear.

       

      Thanks,

      Erez

    • kost's avatar
      kost
      Frequent Visitor
      2 years ago

      I already did try this approach with connecting to Magento REST APIs. It takes significant efforts to get table by table being connected and data being extracted. It may put lot of presure on Magento (Adobe Commerce) server since API calls are not optimized for extraction of the whole history of data.

      The best way to integrate Magento or Adobe Commerce with Power BI is to use Power BI Sales Cube extension from BIM. This solution delivers optimal data model into Power BI and keeps it updated by sending delta of the data. It is also very performant and can handle large datasets without taking performance of the system. It just that first load takes longer and every consequent data update happens in seconds.

      As part of this extensions users may also add custom tables created based on Magento internal REST API endpoints, just to extend the core model. Such tables are taking longer to update and require manual data modeling, so they are used more to extend the model and not to replate it completelly.