web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Connect Dynamics Ax 20...
Microsoft Dynamics AX (Archived)

Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

(0) ShareShare
ReportReport
Posted on by Sathish Sivakumar 3,732

Hi,

I am trying to connect Dynamics Ax 2012 R2 with Magento. Magento is an e-commerce platform like Sharepoint. We are trying to integrate the Magento as the online store for Dynamics Ax 2012 [Magento will play the sharepoint role with Ax 2012 R2]. We are trying to make the real time sync. with Ax and Magento, for ex. If a product is created in Ax and it is assigned to catalog means, then I have to see the product in the Magento online store at front end [site]. Which is the best way to do this scenario?

Already I had completed the sync between Ax and Magento with Asynchronous process. In this scenario the Magento pulls the data from Ax using the AIF service [OOTB & Custom service]. Is it possible to do it on synchronize process? For example if a price adjustment is created in Ax that have to be automatically synced  to the Magento.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 236,297 Most Valuable Professional on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    Yes, you can connect to AX synchronously through web service calls. You can also call web services exposed by other systems from X++.

    Just be aware of performance, calling another system after every change may be much more expensive than doing batch updates.

    Also think twice about how you will call the external system, if you decide to trigger a sync from AX. I often see people executing synchronous web service calls from methods such as update(), which mean that they block the database transaction until the service replies or the call times out. It's generally a bad design. You should complete the transaction as soon as possible.

  • Community Member Profile Picture
    Community Member on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    Hi Martin,

    It is probably a newbie question, but I wonder how can you get a WSDL for the Real Time Service?

    Or in general, what would be the first step in exploring how to consume the AX Real Time Service from let's say a PHP or Java application?

    In the past, it was always easy to find the WSDL for me when I was consuming let's say exchange rate services.

    Thanks!

    Waldemar

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 236,297 Most Valuable Professional on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    Go to System Administration > Setup > Service and Application Intergration Framework > Inbbound Ports, find your port and check the WSDL URI field.

    You may also want to look for answers in the documentation.

  • SergeyP Profile Picture
    SergeyP 2,928 on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    If all you need is to replace SharePoint with something else you could use CRT in the same way SharePoint specific code uses it. Since you should have an access to the SDK you can see examples on how exactly CRT is used in case of SharePoint, then just replace SharePoint specific code with yours. This way, in contrast to directly consuming AX data/its services, you will get for free a lot of functionality needed for any online store and that functionality is in CRT. CRT makes an appropriate calls to Transaction Service when/if needed so you don't have to worry about that - that is encapsulated inside CRT.

  • Community Member Profile Picture
    Community Member on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    Sergey, thanks for that.

    For synchronous real time calls (i.e. redeem gift card, stock lookup etc.) I understand we can directly call Real Time Service? So CRT is not really involved in this scenario.

    For asynchronous data exchange (master data download, transactions upload), I understood that SharePoint doesn't have it's own database. It fetches the data from Channel Database via CRT on ad-hoc basis?

    However, I can imagine that many of the eCommerce solutions require to store the data in a native relational database. So does it make sense to still use CRT? Or would it be better to synchronise data directly between AX Channel Database and eCommerce database (with some transformation)?

    Thanks,

    Waldemar

  • SergeyP Profile Picture
    SergeyP 2,928 on at
    RE: Connect Dynamics Ax 2012 R2 with Magento [Real time sync]

    Since Real Time Service is a "Service", yes, you are right, you can technically call it by using any client - the only requirement is to use right settings in that client. In case of CRT the service's client is setup automatically based on information stored in CRT DB (which gets there from AX).

    As for when CRT calls that service - in fact it is done synchronously in several cases, some examples:

    Creating a Customer

    Creating an Order

    Changing Publishing status for Online Channel (this type of channel is used in ecommerce).

    As for where SharePoint ecommerce gets data in different cases - please find details here: community.dynamics.com/.../365279.aspx let me know if you have more questions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans