October 4, 2013
XE5 ships with a fully integrated version of FireDAC for the first time.
Delphi XE5 and C++Builder XE5 (that is, RAD Studio XE5) ship with a fully integrated version of FireDAC for the first time. In the XE4 time frame, FireDAC was distributed as a separate installer, and wasn't fully integrated. Now even in XE5 it is not fully integrated (for example because of the missing links in the tools menu I blogged about) but the process has started.
Notice that David I just posted on his blog about FireDAC (reminding me that I wanted to blog about this as well).
What is exactly different in FireDAC in XE5 compared to XE4? Here is a not-so-short list:
- FireDAC has a new set of units and component names, to reflect the new name (form AnyDAC), the need for dotted unit name / namespaces, and a better integration.
- The decision to pick "FD" for the components was helped by the fact this is a unique combination (unlike AD) so you can type it in IDE Insight (the new search box in the toolbar) or in the Tools Palette to filter out FireDAC component easily.
- If you have existing applications, a new utility we ship can help you do a complete search/replace with some scripts, available in a demo folder.
- There is Android support, as expected.
- FireDAC core components and the very powerful in-memory table are now part of the Professional edition of the products. This is a complete new set of components in the Professional edition. Probably one of the most relevant additions to Delphi Professional in a few years.
- FireDAC database connectivity depends on the SKU. Access to many embedded and local databases is part of the Professional edition (see above). Access to the "Enterprise-class" databases is in the Enterprise edition, but the same is also in the Client/Server add-on to the Professional edition.
- It is true that by merging the source FireDAC in XE5 works... with XE5. You can still download the latest separate installer to support previous versions of Delphi. This was expected and announced since Embarcadero originally acquired the technology.
There is actually more in the works. We are going to release some FireDAC / DataSnap integration. You can get a glimpse of those in my coming CodeRage8 session about DataSnap. There are several other areas in which FireDAC will grow. The most important think is that XE5 puts FireDAC in the hands of a much larger number of Delphi developers. Welcome to FireDAC, Delphi's preferred database access library.
posted by
marcocantu @ 3:30PM | 18 Comments
[0 Pending]
18 Comments
FireDAC in Delphi XE5
what version of XE5 comes already with full FireDAC as
you described?
Comment by batman on October 4, 16:22
FireDAC in Delphi XE5
I'm not clear as to how FireDac fits into the
database model - at least the one I typically use.
At the moment my model - for 2 or 3 tier apps - is:
A "Business Logic" Data Module containing
ClientDatasets
linked to
A "Data Layer" Data Module containing ADO Components
and TDataset Providers
accessing
A SQL Server database (using OLE DB Drivers)
... am I going to see any improvements by
incorporating FireDac? Which layer do they sit? I'm
assuming "Data Layer".
Or does Firedac offer an improvement on
ClientDatasets?
Comment by RichardS on October 4, 17:35
FireDAC in Delphi XE5
What's going to happend with the former client of
AnyDAC?
I know there's an "old" version for XE4 (8.0.5), but in
this new FireDAC exist many bug fix, improvements and
change that isn't part of the support for Android; how
can we get access to this change??
Comment by Rolphy Reyes on October 4, 17:56
FireDAC in Delphi XE5
Richard S. Disconnected Mode. FireDAC can be configured
to disconnect in background in order to allow the
database to reuse the sessions. To a certain degree that
frees you from the need for middle tier. I say to a
certain degree - it's not a replacement for n-tier. It's
a stronger C/S. Can help to serve 1000 users and more on
just the database. Examples for that exist on Oracle ...
I would have to rethink the name of the community member
- a German who resides in the U.S. ... I think it's
Thomas Pfister. Anyone correct me if I am wrong.
Comment by Michael on October 5, 14:57
FireDAC in Delphi XE5
Marcu,
Does the PASERVER to target Mac OS/ios work without
internet connection?
It was working allright for me, before i disconnected
internet and its giving me error that it cant connect to
PAServer, even though its on on the target Mac os.
Any advice or link will be appreciated.
Thanks,
Kanwal.
Comment by Kanwal Flora
[http://www.radardesigner.com]
on October 6, 01:41
FireDAC in Delphi XE5
Yes, now paserver is working .i used the
actual ip address using ipconfig rather than
192.168.2.3.
Comment by kanwal flora on October 8, 01:11
FireDAC in Delphi XE5 - NCOCI
Hello, a perfect place here! Does anyone has a glue how
to migrage Delphi 7 NCOCI projects only using
TOCIDatabase and TOCIQuery to FireDAC? Beside that we
use some jedi components, but that's only a smaller
problea, i guess.
Thanks in advance!
Comment by Alexander Dexler on November 6, 17:13
FireDAC in Delphi XE5
"You can still download the latest separate installer
to support previous versions of Delphi."
We have bought latest FireDAC XE5, however I don't see
where I can download latest version. I got only SN and
info how to 'add it to XE5'.
So where can I get this installer?
Comment by Kibab on November 7, 13:42
FireDAC in Delphi XE5
Kibab,
You can buy FireDAC XE5 for... XE5. If you have Enterprise you can get
also older versions of Delphi, and get FireDAC for those. If you bought
only the C/S pack that might be an issue.
If you can email me the specific info, I can see if we can handle the
issue.
Comment by Marco Cantu
[http://www.marcocantu.com]
on November 7, 17:49
FireDAC in Delphi XE5
FireDAC Integrated?
I would beg to differ since MySQL support does not
include the required dll support. A user need to
learn about that from the lengthy support docs and
then go find that required dll and dll version out on
the web. Not exactly "Integrated" in my book.
Any the various FireDAC support files are located in
the Program Files directory when means those dirs
need permissions changes. And finally when I compile
there seems to be missing files. Hmmm, maybe another
read through of the docs is required.
I think FireDAC is a wonderful concept but I had real
problems getting it to play with MySQL. So I simply
went back to a 3rd party tool kit that works "Out Of
The Box" and I hope in the future FireDAC can also.
This experience was in XE4. Did XE5 get better?
Bob K.
Comment by Bob Kondner on November 19, 18:57
FireDAC in Delphi XE5
Bob,
the lack of the client library for MySQL is not a FireDAC shortcoming.
The same if for dbExpress, ADO, BDE... and any other database access
library that shipped with Delphi. The only alternative is to write a data
access driver that bypassed the client library and uses a socket
connection, something possible only for a few databases.
distributing the client libraries for all supported databases (well over a
dozen) would be a huge task and would easily be illegal, as database
vendors don't generally allow the redistribution of the clients, even if
they can be downloaded for free.
FireDAC documentation lists for each database the proper installation
steps for the corresponding client library, to help developers gets
started.
-Marco
Comment by Marco Cantu
[http://www.marcocantu.com]
on November 22, 18:04
FireDAC in Delphi XE5
Bob,
one more thing. You are absolutely right about the "Program Files" issue,
this has been addressed in XE5.
Thanks
-Marco
Comment by Marco Cantu
[http://www.marcocantu.com]
on November 22, 18:06
FireDAC in Delphi XE5
I just bought RadStudio XE5 Entreprise with FireDAC
Included.
I need to install FireDac in D7 to be able to move my
old application from D7 de XE5 but I don't see any
place where I can download de FireDac Installer.
Where can I download it ???
Thank!
Comment by François Zacharie on January 7, 04:29
FireDAC in Delphi XE5
"distributing the client libraries for all supported
databases (well over a dozen) would be a huge task and
would easily be illegal"
You continue to support databases that are become
obsolete in today's everything "Internet" world. Since
mySQL is the most widely used Internet database, you
would think Embarcadero would support it.
Must be a agreement you all have with Devart?
Comment by Shane Holmes on January 8, 01:15
FireDAC in Delphi XE5
Francois,
You should find the older edition of FireDAC in the XE5 registered users
download page.
Shane,
we support mySQL as we support many other databases. Distributing
mySQL client library is not legal, not allowed by their license. Devart has
a solution that bypasses the client library, which we are considering
supporting in the future. What of this description is not clear?
-Marco
Comment by Marco Cantu
[http://www.marcocantu.com]
on January 8, 08:30
MS SQL Driver localhost support FireDAC in Delphi XE5 Professional
Localhost support for MS SQL and other DB drivers for
localhost in FireDAC would be great...Support for
various drivers in XE5 Professional is minimal. There
seems to be a piecemeal approach in different Delphi
versions. If done to force people to go for Enterprise
or higher editions, Embercadero is missing the plot...
Comment by PK on February 11, 22:19
FireDAC in Delphi XE5
PK,
I think the situation is quite clear. FireDAC in Professional version
allows access to local and embedded database. What is not available is
access to enterprise-level databases like Oracle, MS SQL Server, DB2,
Informix, and the like.
An alternative would be to support all database on local host, but given
this can lead to interesting scenarios to work around the local host
limitation, I think this won't be a good idea.
We sell the C/S pack, so you can get full FireDAC without having to buy
Enterprise, but for a cheaper feee.
-Marco
Comment by Marco Cantu
[http://www.marcocantu.com]
on February 14, 21:51
FireDAC in Delphi XE5
Iam having trouble with mySQL and firedac connection.
How can you help me?
I am chii from Philippines.
Comment by Cherrie on May 19, 09:04
Post Your Comment
Click
here for posting
your feedback to this blog.
There are currently 0 pending (unapproved) messages.