Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
C++DatabaseDelphiNews

Accessing Databricks, Teradata, Oracle Autonomous, MongoDB Atlas and Google BigQuery with RAD Studio and FireDAC

firedac architecture12 21 16 3

Intro

I believe almost everyone developing with RAD is aware that FireDAC provides nativelly access to a bunch of database systems.

With each new release of RAD Studio, the list of supported databases is updated in response to customer requests and the availability of newer versions from vendors. A helpful resource to bookmark is this DocWiki link — it allows you to quickly check which database versions are supported for any specific RAD Studio version you’re using: https://docwiki.embarcadero.com/Status/en/FireDAC_Database_Support.

If you are not familiar with FireDAC, these are some good resources to start with:

Going beyond the most traditional platforms

Updates applied in recent versions of RAD (the 12.3 for instance) improved the access to NoSQL databases like MongoDB on the cloud (aka Atlas), as well to the ODBC bridge support provided by FireDAC. Details about what was updated are listed in the documentation below, section FireDAC and Database:

From the databases listed for this blog post, both MongoDB Atlas and Oracle Autonomous Database are accessible via a native FireDAC Driver, meaning no extra installation is needed – except the native client from each database vendor. Actually, MongoDB requires just a DLL, which is already provided by RAD Studio. For Oracle you can choose between the full Oracle client or just the Instant Client – much easier (I’m providing a quick tutorial on the Oracle Instant Client configuration buy the end of this post).

Teradata is also natively supported by FireDAC, but relies on their ODBC driver for connection, meaning requires installing the ODBC driver that can be downloaded for free from Teradata website.

Now, Google BigQuery and DataBricks are not listed as a native supported database platform, but they are fully functional via the FireDAC ODBC Bridge, requiring you to just install their respective ODBC drivers.

Resources

Below you can find the (basic) samples I’ve created to probe these platforms, as well the pertinent documentation:

How to properly setup your Oracle Instant Client

You can find the steps to easily configure your Oracle Instant Client following the steps I’m sharing in these two Gists (32 and 64-bit)

See What's Coming in RAD Studio 13 Florence The AI Codecamp: Learn, Code, Create

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

About author

Lead Software Consultant, LatAm

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES