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 := 'MicrosoftProjectConnection';
FDConnection1.DriverName := 'CData.Fire.MicrosoftProject';
with FDConnection1.Params as
TFDPhysCDataMicrosoftProjectConnectionDefParams do begin
...
end;
FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from Projects');
...
Type SQL, Get Microsoft Project
The easiest way to build data-centric applications. Write standard SQL queries to interact with Microsoft Project, just like working with any RDBMS. Supports joins, updates, aggregation, and more.
SELECT WITH INNER JOIN
SELECT Projects.Id, Projects.Name, Projects.Fax,
Opportunity.AccountId, Opportunity.CloseDate
FROM Projects
INNER JOIN Opportunity
ON Projects.Id = Opportunity.AccountId
AGGREGATE FUNCTIONS
SELECT Name, AVG(AnnualRevenue) FROM Projects GROUP BY Name
CRUD OPERATIONS
UPDATE Projects SET Name='John' WHERE Id = @myId
