Microsoft Dynamics AX (Archived)

Connect AX Data Source with Common Data Service

(0) Share

Report

Posted on by Lifeisbelieveful

363

Hi everyone.

I've developed power apps to connect AX 2012 data source.

I want to make app for any user to connect data source and create / edit / delete the data and want to use common data service not gateway.

If anyone knows how to connect SQL server for AX 2012 data source with common data service and how can I make an app including the function that enable not only select also create, update, delete for the data, please give any directions or steps.

Thanks, I've learned many things from all community post and materials.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Crispin John Augustine 37,081 on at

Like (1)

Report
Copy link

Link copied!

there are 2 safe ways in 2012 to allow create/delete data from external app

* Aif Services docs.microsoft.com/.../consuming-microsoft-dynamics-ax-services-from-an-external-client

* DMF Services ax2012dmfdataimport.blogspot.com/.../microsoft-dynamics-ax-2012-data-import_9.html

If you Need more detailed step by step guide, comment below, there are plenty of examples online.

Was this reply helpful? Yes No
Lifeisbelieveful 363 on at

Like (0)

Report
Copy link

Link copied!

Thanks Crispin,

Could I ask is it possible to use common data service with above services which you mentioned or is there any other service to use CDS?

Was this reply helpful? Yes No
b_radlyjames 3,157 on at

Like (0)

Report
Copy link

Link copied!

You can't connect AX 2012 using the CDS. It doesn't work. You can use a gateway, however, you did mention you don't want to do that.

Alternatively, as mentioned above, I believe you can use AIF.

Was this reply helpful? Yes No
Suggested answer

MikSAX 20 on at

Like (1)

Report
Copy link

Link copied!

Hi Daniel,

I think that it's possible to use CDS through Web API.

[View:https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/overview:750:50]

A possible scenario could be work with a C# application to get data from CDS through this API and then, send information to AX using a custom WebService.

Was this reply helpful? Yes No
Suggested answer

b_radlyjames 3,157 on at

Like (0)

Report
Copy link

Link copied!

MikS is correct. You can use C# and the AX AIF as described here:

www.axpulse.com/.../

However, if you are wanting to READ data, a On Premise Gateway works very well for that.

We are currently designing a Power APPS app to READ and WRITE data to//from AX 2012 R2 and are using the Gateway to read data into the Common Data Model and then using AX AIF via C# Web API to read data back from the Common Data Model into AX.

Was this reply helpful? Yes No
MikSAX 20 on at

Like (0)

Report
Copy link

Link copied!

Through gateway. you can read/write data directly from/to AX database or another SQL on premise database, without using the CDS.

So, if you are using the gateway, why you need also to use the CDS?

Was this reply helpful? Yes No
b_radlyjames 3,157 on at

Like (0)

Report
Copy link

Link copied!

Yes, you can write directly to the AX database, however, that would not be advised as you would miss all the business logic contained on the AX table methods (Insert, update, delete, modified field, etc.).

If you are going to write into AX, it would be better to do that via AIF.

Was this reply helpful? Yes No
MikSAX 20 on at

Like (0)

Report
Copy link

Link copied!

Fully agree with you. For this reason, in my case, I'm using gateway to read/write on a SQL on-premise database, not directly on AX.

Next, I'm using a C# application in order to read data from this SQL database (not AX), and then, on the same C# application, I call a custom WebService to write data on AX, and thanks to this I don't lose the business logic on AX methods.

I suppose you are using CDS with the same purpose that I am using on-premise SQL database, don't you? The main purpose here is not to use directly the Dynamics AX database.

Was this reply helpful? Yes No