Dynamics 365 F&O /
AX Data Integration

Unique Features

• Seamlessly connect, read from, and write to Microsoft Dynamics 365 Finance & Operations or Microsoft Dynamics AX Server directly within your SSIS packages.

• Support for multiple Connection APIs, including Business Connector for older AX versions (4.0 2012 R3) and OData for Dynamics 365 Finance & Operations.

• Access flexible OAuth authentication types for OData connections, including Authorization Code, Password, Certificate, and Client Credentials (server-to-server).

• Utilize robust token management for OAuth, supporting token file paths and Azure blob storage SAS URLs, with secure token generation.

• Perform Create, Update, Upsert, Delete, and Custom Actions on your Dynamics AX/F&O data.

• Retrieve data from Dynamics 365 Finance & Operations entities or pre-configured RecurringExport projects.

• Optimize data retrieval with customizable batch sizes and options to limit the number of rows returned.

• Apply precise filtering conditions and specify data order using a dedicated Order By Builder for source components.

• Benefit from multi-threaded writing support for Dynamics 365 Finance & Operations which boosts data load performance.

• Bypass table methods and skip server-side business logic during writes (for Business Connector) with control over data validation.

• Ignore unchanged fields and null-valued fields during write operations to prevent unintended data updates.

• Ensure data integrity with robust error handling options, including redirection of failed rows to an error output.

• The Premium Service Lookup Component offers advanced lookup capabilities by searching records in Dynamics F&O instances.