Dynamics 365 Business Central Connector for MuleSoft

SQL-Centric MuleSoft Connectivity to Dynamics 365 Business Central

Leverage the power of SQL to simplify integration with Dynamics 365 Business Central. Our Dynamics 365 Business Central Connector for MuleSoft includes a robust SQL engine that simplifies data connectivity and allows users to accomplish complex data manipulation without extensive transformation workflow.

  • Write SQL, get Dynamics 365 Business Central data. Similar to the MuleSoft Database Connector, but for Dynamics 365 Business Central.
  • Powerful SQL Engine with support for dynamic queries, streaming, bulk operations, metadata discovery, query folding, and more.

  download beta
Dynamics 365 Business Central MuleSoft Anypoint Connector



SQL Access to Dynamics 365 Business Central From MuleSoft

Connecting to Dynamics 365 Business Central is as easy as connecting to a database



Dynamics 365 Business Central

The Dynamics 365 Business Central MuleSoft Connector provides the easiest way to connect with Dynamics 365 Business Central data from MuleSoft workflow. The Connectors leverage a straightforward design, similar to the MuleSoft Database Connector, that makes it easy to import, export, backup, analyze, transform, & connect-to your Dynamics 365 Business Central data.


Standard MuleSoft Connectors



The Dynamics 365 Business Central Connector for MuleSoft is a fully-integrated standard Connector featuring seamless integration with the Anypoint designer, dynamic input and operation through DataSense, support for complex projections, streaming, bulk operations, and more!


	
	 #["SELECT * FROM $(vars.table) WHERE name = :name"]
	 
	   #[{'name' : payload}]
	 
	

Type SQL, Get Dynamics 365 Business Central



Write standard SQL queries to interact with Dynamics 365 Business Central, just like working with any RDBMS. Supports joins, updates, aggregation, etc.

SELECT WITH INNER JOIN

SELECT Items.Id, Items.Name, Items.Fax,
  Opportunity.AccountId, Opportunity.CloseDate
FROM Items
INNER JOIN Opportunity
  ON Items.Id = Opportunity.AccountId

AGGREGATE FUNCTIONS

SELECT Name, AVG(AnnualRevenue) FROM Items GROUP BY Name

CRUD OPERATIONS

UPDATE Items SET Name='John' WHERE Id = @myId

Key Features

  • Data-Centric Operations (SQL Access to Data)

    CData Connectors for MuleSoft function in a similar way to the Mule 4 Anypoint Connector for Database. They interoperate with MuleSoft DataWeave to offer dynamic data access from MuleSoft workflow.

  • Fully-Dynamic Queries

    Users can parameterize all parts of the Query passed to the Connector. This capability includes the WHERE clause as well as the ability to parameterize parts of the query itself.

  • Streaming & Bulk Operations

    Connectors support data streaming and bulk operations by default, making operations over large datasets fast and efficient. The connectors include integrated paging that streamlines data access, and support bulk and batch operations for reading and writing.

  • Intelligent Query Folding

    Improved performance through intelligent query folding. Connectors push data operations server-side wherever possible to improve execution performance. Operations that cannot be executed server side are handled client-side by the robust embedded SQL Engine.

  • Metadata Discovery

    Extensive schema discovery capabilities. Explore tables, columns, keys, and other data constructs based on user identity.

  • Replication and Caching

    Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.

  • String, Date, & Numeric Function

    Includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Collaborative Query Processing

    Connectors enhance the data source's capabilities with additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Customizable and Configurable

    Data models can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. Customizations are supported at runtime using human-readable schema files that are easy to edit.

  • All-in-One Deployment

    Standard MuleSoft Connectors that can be easily deployed to any supported MuleSoft platform.


Download Dynamics 365 Business Central Connector for MuleSoft Now


Fast-track your next MuleSoft integration to Dynamics 365 Business Central. Standard SQL interfaces provide a familiar interface to Dynamics 365 Business Central, and shield systems integrators from the complexities of data access.


  download beta