Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

(0) ShareShare
ReportReport
Posted on by 30

Currently, I am working on skyvva integration app in salesforce and I'm making new adapter for integration with Microsoft Dynamics AX 2012 to transfer data like accounts,contact,etc.. and I ant to know that how can i get username and password for authentication with dynamics ax.

also how many type authentication can i use like SOAP,REST,Auth2.0 etc. currently I'm using soap with is basic authentication and use xml.

So Please Help me to find the solution.

Here the sample of the Adapter and it's properties.

pastedimage1646198757410v1.png

  • Martin Dráb Profile Picture
    231,782 Most Valuable Professional on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    Please look at the documentation - I gave you the link again in my last reply.

    Which pages you should read depends on what you want to learn. Definitely go through some intriduction, such as Services, service operations, and service groups and Developing with Services and AIF. Then look at more details about what you're interested in, such as document services.

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    Okay first i read your recommendation and for web services which Document you think I have to read?

  • Martin Dráb Profile Picture
    231,782 Most Valuable Professional on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    I'm confused. You explicitly said that you "need Document Services" and now you're asking again what you could use (which we discussed before).

    I thought you already got enough information about available services and you made your decision. If not and you still don't know what you can use, please look again at the link I gave you (Services and AIF development) and read my recommendations once more.

    AX 2012 uses SQL Server and it's technically possibly to connect directly to it, but it's not a good idea. It has several problems:

    1. You need to open your database servers for inbound connections from internet.
    2. You would bypass all AX security.
    3. When you want to insert data to database, you need to generate record IDs. That's not easy.
    4. You'd need to deal with DataAreaId and Partition in all queries by yourself.
    5. You can't use any existing business logic (code, queries, table relations, delete actions etc.). You would have to replicate a lot of logic and you mustn't make mistakes.
    6. Also, don't expect alerts, DB logging and such things to do their job.
    7. You may get into problems with caching if you make changes that the application isn't aware of.

    And so on... In short, don't do it. Instead, use web services -they don't bypass application servers.

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    I can use web services too.

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    My question is that I have to import and export the data like records n all. So what type of authentication and integration i can use? I'm using skyvva integration app to integrate with Microsoft dynamics ax. and Which type of database is dynamic ax is using and can i connect directly like using password, username, endpoint URL n all or some other way?

    My main aim is that i have to import and export the data from dynamics ax to my skyvva app through an adapter which I'm building. It's the same as the inbound and outbound adapter which ax is using. That's why i need the username, password, endpoint n all.

    so can you tell me how can i get username password endpoint url n all for the authentication to import and export data  n records from dynamics ax to skyvva integration app through adapter call and also perform crude operation too.

  • Martin Dráb Profile Picture
    231,782 Most Valuable Professional on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    What's your question?

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    hey can you help me?

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    And also import and export this data(Like Records).

  • Hardik_0212 Profile Picture
    30 on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    Yes I need Document Services.

  • Martin Dráb Profile Picture
    231,782 Most Valuable Professional on at
    RE: How to integrate with Microsoft Dynamics AX 2012 with Our Integration App?

    You should always choose the technology based on your requirements. We can't just guess what would be the best for your particular situation.

    There are three services that you probably want to consider:

    • Document services (complex documents, such as sales orders, CRUD)
    • Custom services (remote procudure calls)
    • Query service (querying tables directly)

    You'll find more details in documentation.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,916 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans