Оффлайн
- Регистрация
- 9 Май 2015
- Сообщения
- 1,600
- Баллы
- 155
Table of Contents
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: .
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 and 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).
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, and 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:
Extra Tip
How to easily download and configure the Oracle Instant Client:
1. Download the Instant Client from Oracle developers portal (64 bit) 2. Extract the client to a folder like C:ORACLEINSTANT 3. Add the client folder to Windows PATH variable 4. Add the TNS_ADMIN variable TNS_ADMIN=C:ORACLEINSTANT 5. Add NLS_LANG variable NLS_LANG=American_America.CL8MSWIN1251 6. Create and load the following registry entry Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREWOW6432NodeORACLE] [HKEY_LOCAL_MACHINESOFTWAREWOW6432NodeORACLEKEY_INSTANTCLIENT] "NLS_LANG"="AMERICAN_AMERICA.CL8MSWIN1251" "ORACLE_HOME"="c:oracleinstant" "ORACLE_HOME_NAME"="MY_INSTANTCLIENT" 7. Adjust the "tnsnames.ora" file to reflect your database server configuration 8. For the Oracle Autonomous Database (cloud) the sqlnet.ora file also needs to be updated, more details can be found <a href=".">here.</a>
| 1. Download the Instant Client from Oracle developers portal (64 bit) 2. Extract the client to a folder like C:ORACLEINSTANT 3. Add the client folder to Windows PATH variable 4. Add the TNS_ADMIN variable TNS_ADMIN=C:ORACLEINSTANT 5. Add NLS_LANG variable NLS_LANG=American_America.CL8MSWIN1251 6. Create and load the following registry entry Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREWOW6432NodeORACLE] [HKEY_LOCAL_MACHINESOFTWAREWOW6432NodeORACLEKEY_INSTANTCLIENT] "NLS_LANG"="AMERICAN_AMERICA.CL8MSWIN1251" "ORACLE_HOME"="c:oracleinstant" "ORACLE_HOME_NAME"="MY_INSTANTCLIENT" 7. Adjust the "tnsnames.ora" file to reflect your database server configuration 8. For the Oracle Autonomous Database (cloud) the sqlnet.ora file also needs to be updated, more details can be found <a href=".">here.</a> |