Dynamics 365 FinOp FireDAC Components

Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with Microsoft Dynamics 365 Finance & Operations data including Vendors, Customers, Accounts, Jobs, and more!

  • Connect to Microsoft Dynamics 365 Finance & Operations from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Integrate Delphi & C++Builder Apps with Dynamics 365 Finance & Operations Vendors, Customers, Accounts, Jobs, and more!

  download   buy now

CData FireDAC Components for Dynamics 365 Finance & Operations
 FireDAC Subscriptions: 150+ Components for data integration.

Extend Delphi & C++Builder Apps with unrivaled data connectivity!

Dynamics 365 FinOp FireDAC Components Included in Enterprise Subscriptions


Get the Dynamics 365 FinOp FireDAC Components together with 150+ additional components for SaaS, NoSQL, and Big Data integration! Our components offer the fastest & easiest way to build data driven Apps.

  • More than 150+ FireDAC Components for NoSQL, Big Data, & SaaS integration.
  • One year of free updates, upgrades, new releases, and support.

Learn More  

FireDAC Components in Action

Connecting to Any Data Source is as Easy as Connecting to a Database



Standard FireDAC Components


Just like connecting with a typical RDBMS like MySQL. or SQL Server. Use standard FireDAC components like TDFManager, TDFConnection, TDFQuery, etc.


	FDConnection1.Name := 'Dynamics365FinOpConnection';
	FDConnection1.DriverName := 'CData.Fire.Dynamics365FinOp';
	with FDConnection1.Params as
	    TFDPhysCDataDynamics365FinOpConnectionDefParams do begin

	    ...
	end;


	FDConnection1.Connected := true;
	FDQuery1.Active := true;
	FDQuery1.Open('select * from Vendors');

	...

	

Type SQL, Get Dynamics 365 FinOp


The easiest way to build data-centric applications. Write standard SQL queries to interact with Dynamics 365 FinOp, just like working with any RDBMS. Supports joins, updates, aggregation, and more.

SELECT WITH INNER JOIN

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

AGGREGATE FUNCTIONS

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

CRUD OPERATIONS

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


Powerful Enterprise features


  • Seamless Integration:Feature-rich high-performance Data Access Components that extend Delphi & C++Builder Apps with SaaS, NoSQL, & Big Data connectivity.
  • Developer Friendly: Full Design-time support for data operations directly from RAD Studio. Work with live data directly from the IDE Data Explorer and FireDAC explorer.
  • 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 SQL Functions: The driver 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: Our drivers enhance the data source's capabilities by additional client side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.
  • Easily Customizable and Configurable: The data model exposed by our DAC Components can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.