Notifications
Announcements
No record found.
Hi,
I want to use some tables from ax in another external application(web application).
so , I'm looking for connectors that do this job.Have you any idea about this task or documents?
Dynamics AX database runs in SQL Server.
So actually your question is: "how to connect to SQL Server from the outside?".
- The database must be accessible by the external application (firewall rules)
- The external application must authenticate with the database (using Windows authentication or SQL Server authentication)
You should find plenty of info in SQL Server documentation and SQL Server forums.
Quite often it's not preferred to open up your prod database directly to external applications. So you should also consider building some different kind of integration than direct SQL connection. For example developing some web services in AX.
Hi Basma,
There are plenty of options on how you can connect the external application to AX. The recommended approach is not to give access to DB directly but use AIF or web services to get data from AX.
But I saw a couple of implementations where 3rd party application had direct access to AX DB, but you need to restrict access properly to only needed data (use sql views with different schema) and restrict write access to DB from 3rd party side.
Thanks for reply ,
without going through the database, do you have examples of how to use web services or AIF to use metadata in an external application
What exactly does the external application want? Data or metadata?
You can find plenty of documentation and examples about AIF and custom services by web search.
I have some tables in AX , then I want to use these tables in external application.
Ok so you want to share the data - not metadata.
You can start by checking following documentation:
docs.microsoft.com/.../services-and-application-integration-framework-aif
docs.microsoft.com/.../using-custom-services
Thanks Nikolaos,
I will check theses documents
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 456 Super User 2025 Season 2
Martin Dráb 429 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
