Microsoft Dynamics 365 for Finance & Operations OData (MS Dynamics AX)
Support for MS Dynamics AX using OData. Both reading data and writing (insert and update) is supported.
We support both OnPremise and Azure-based installations and also Microsoft hosted (Dynamics 365 online) deployments.
The following versions of MS Dynamics AX are supported
- Microsoft Dynamics 365 for Finance & Operations (MS Dynamics AX 2018)
- older version - please contact us.
Additional installation (only for local installations or if you control the Azure instance)
- In order for Rapidi to connect to your local database server, you need to download and install a small service, that we call the
Please Note: The OData Connection is by default created with an attached RapidiConnector. If you don't need the RapidiConnector - if you want Rapidi to connect directly to your OData system - you need to delete the RapidiConnector from the Connection (click the trashcan icon (Delete RapidiConnector) all the way to the right on the RapidiConnector header).
Below is a description of the fields on the Connection:
- Code: The unique code for this connection (cannot be changed)
- Description: Enter a text describing the Connection.
- Authentication Type: Choose howto authenticate with your MS Dynamics 365 system. Normally you would choose "OAuth2 (Azure AD)" here and specify the connection parameters and credentials as described below.
- Server Connect: Specify the full path to your Dynamics 365 EE system - like "https://testing123.cloudax.dynamics.com/data/Customers"
- Company: Specify the AX company that this connection should use - like "usmf". You need to create a Connection for each Company in AX that you want to read or write data from/to. Rapidi will automatically handle to filter and specify the Company when sending data and requests to AX (so you don't need to worry about setting the dataAreaId).
- UserID: Here you specify the userid (credentials) to access your Dynamics 365. When using the OAuth2 authentication, this is the ApplicationID of the App created in the Azure AD.
- Password: Here you specify the Password corresponding to the above UserID. For OAuth2, this is the Key found on the App created in the Azure AD.
- Domain: The Domain for Authentication. For OAuth2, this is the Tenant ID of your Azure AD.
- Resource: This field is only used for OAuth2 authentication. Specify here the resource (the Application ID of the App in your Azure AD that you want to have access to - e.g. your Dynamics 365 EE system).
- Metadata URL: Here you can specify the URL to the metadata for your Dynamics 365 EE - like "https://testing123.cloudax.dynamics.com/data/$metadata"
- Use SSL: Check this field if the connection should use SSL (this setting dictates if SSL is used independently of specifying http or https above).
Test and Read Design
- You can Test that the access to a Connection works using the Test button on the Connection.
- Login to MyRapidi. Click the
- Read Design is the way to read the layout - the information about tables and fields - from a Connection. Reading the design is