Quick and easy installation in just minutes. Combine your data automatically in the background and benefit of better insights and greater revenues.
FINANCe and OPERATIONS Data Integration
Microsoft Dynamics 365 Finance and Operations data can be integrated and synchronized codeless with various external systems, on-premises or in the cloud, using the Layer2 Cloud Connector. Learn on this page how the data integration of Finance and Operations is working with the Layer2 Cloud Connector. Make use of the benefits and features of this data integration tool by trying it out yourself.
How it works
In fact, you only need to do the 5 following steps to get your Finance and Operations data integration started.
1: Set up your connection direction as required: one-way or two-way.
2: Set up your data source, in this case, Finance and Operations.
3: Set up your target, for example, a Microsoft SharePoint list or library.
4: Set up your mapping.
5: Run your connection!
Benefits of using Layer2 Cloud Connector for Data Integration
FINANCE AND OPERATIONS Connection Settings & Intro tutorials
You can find here the Connection Settings for Finance and Operations. Click on the intro tutorial to get the whole "how-to-connect" documentation on a concrete example with SharePoint.
Connection Settings for the OData Provider:
"How-to-connect" documentation of Finance and Operations & SharePoint Online with the Layer2 OData Provider:
Connection String Example
URL=https://yourcompany.ax.dynamics.com/data;Authentication=OAuth2;ClientId=yourclientid;ClientSecret=yourclientsecret;Scope=openid offline_access;AuthorizeEndpoint=https://login.windows.net/yourcompany/oauth2/authorize;TokenEndpoint=https://login.windows.net/yourcompany/oauth2/token;Port=yourport; ResourceUri=https://yourcompany.ax.dynamics.com;
Select Statement Example
SELECT CustomerAccount, EmployeeResponsibleNumber FROM Customers