You’re offline. This is a read only version of the page.
Announcements
932
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?
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
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.
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.
#1
André Arnaud de Cal...
294,033
Super User 2025 Season 1
#2
Martin Dráb
232,854
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
