Latest Articles

InterBase 2017 Update 1 Is Now Available

Written by Marco Cantu, RAD PM on . Posted in Articles

We are pleased to announce general availability of InterBase 2017 Update 1.

This update expands on the InterBase 2017 version we release earlier this year and introduced many new features as discussed at

InterBase 2017 Update 1 New Features

A highlighted summary of InterBase 2017 Update 1 new features includes:

  • Developer and Server Editions are now available for MacOS Universal build, in both 32-bit and 64-bit platforms
  • Server Edition includes bug fixes for Windows and Linux as well as performance enhancements
  • Support for Windows 10 Creator’s Update
  • SQL features support for Expression Indices, ORDER BY and GROUP BY Expression, as described below

Expression Indices

Expression indices optimize queries based on expressions. By defining the index below, based on an expression referring to multiple fields:

CREATE INDEX idx_expr_t1_udf ON t1
COMPUTED BY (UPPER(first_name) || UPPER(last_name));

a query based on that same expression is going to be much faster:


WHERE (UPPER(first_name) || UPPER(last_name)) = 'THREE MUSKETEERS';

SQL GROUP BY Expression and ORDER BY Expression

The GROUP BY statement can be used with expressions COUNT, MAX, MIN, SUM, and AVG to group the result-set by one or more columns. Similarly the ORDER BY statement can be used with these expressions to sort a resulting dataset. 

/* Following sample queries are optimized to use the expression index, if available; SET PLAN ON to see the plan. Otherwise, the ORDER BY and GROUP BY <expr> will execute by sorting the result set as needed. */

CREATE INDEX idx_expr_t1_mul ON t1 COMPUTED BY (f1 * f2); 

/* ORDER BY */

-- by expression
SELECT f1, f2, f1 * f2 FROM t1 ORDER BY (f1 * f2);

-- by ordinal position
SELECT (f1 * f2), (f1 + f2) FROM t1 WHERE f1 * f2 = 100 ORDER BY 1, 2;

 /* GROUP BY */

-- by ordinal position
SELECT f1 * f2, COUNT(*) FROM t1 GROUP BY 1;

-- by expression
SELECT (f1 * f2), COUNT(*) FROM t1 GROUP BY (f1 * f2);

More Information on Update 1

For a complete list of updates in InterBase 2017 Update 1, please visit our docwiki at

InterBase is the Future for Your Data Layer Needs

Consider these new features along with the current, easily configurable InterBase features like column-level data encryption, field-level change tracking (Change Views), user-specific data visibility, journaling, and point-in-time recovery. InterBase 2017 is a lightweight embeddable database solution that is ideal for distributed systems.

Tips for choosing the best ISV database for you?

If you are looking to choose an ISV database, visit the ISV database comparison on the InterBase pages. Here you will discover a number of questions to help you choose the right database for you.

Download InterBase 2017 Update 1 today!

The Windows and Linux Server Edition updates are provided as a patch install kit for InterBase 2017 customers, while InterBase ToGo and MacOS versions are provided as full install kits. 

Existing Users download the update here:

New to InterBase? 

Learn more at

Buy a license on or from your local Embarcadero reseller parnter

Notice that the trial and developer edition updates will be made available in the coming weeks following final certification, and at the same time we'll refresh the IB 2017 versions distributed via GetIt to the RAD Studio Tokyo customers.


Focus on your product, and stop worrying about your data layer.


InterBase 2017: Embed, Deploy, Relax!



A Busy Summer!

Written by Atanas on . Posted in Articles

It was a busy summer. There has been so much happening lately that it is difficult to decide where to start.

A Busy Summer

Earlier this year we launched the milestone RAD Studio 10.2 (aka Tokyo). This August we released Update 10.2.1 that provided a number of highly anticipated quality and feature updates. So, what happened with the BIG September release? As stated before, we are no longer looking for the next BIG release. We want to provide customers the functionality that they need when it is ready and continue to constantly evolve the product ALL the time. We did 10.2.1 in August, but this week you should be looking for the iOS 11 update. We want to make it easier to stay on the latest release and deliver value more often.


We do have more work to remove the re-installation requirement altogether, but that is not a small task with almost 70K files involved. The good news is that upgrades today are more seamless and our Product and R&D teams received a lot of acolytes for that. The Linux support is a huge milestone and there is a lot more in 10.2.1 for both mobile and Windows.


Our marketing published an awesome magazine to celebrate the progress made with Delphi over the last 22 years I encouraged many of our developers to share this with their supervisors, who think that Delphi is a thing of the past, many were pleasantly surprised. We are running a nice promo for September that goes with the “22” theme, so check-out the site or speak with your partner. It is a great time to upgrade or expand.


The VCL framework continues to evolve. I think that with all the technologies out there, we sometimes forget how good it is, and it is only getting better. High DPI support and improved icons make your apps truly stand-out, and we have plenty of more awesome updates in the works. Lately, we’ve spoken a lot with C++ developers, as we try to increase the awareness for C++Builder. It is amazing how much Delphi developers take for granted. While there are OK visual frameworks that support C++, almost nothing comes close to VCL. I am really excited to continue to educate our C++ community on what we can deliver and of course continue to improve the C++ language support.


At the end of August, we released Enterprise Connectors. These make integration of applications built with RAD Studio to the most common enterprise applications, such as SAP, Salesforce, Facebook, and many more, very easy. They use a combination of FireDAC, REST, and CData technologies to make user adoption seamless. I think that these give an incredible competitive edge to our developer community, especially considering the speed of development. It is fast development indeed.


Just last week we launched the Embarcadero Academy! Making our products more easily accessible for education and making learning easier is a top priority. I feel that a dedicated education site together with a FREE Starter edition that is available for Education purposes are important steps in this direction. I benefit personally… My thirteen-year-old son is learning Delphi and the Academy is making it easy (and inexpensive)! Visit and find out for yourself.


Most importantly, last month we acquired Sencha. This demonstrates again our broader commitment to Developer Tools. Sencha is the home of Ext JS, which is the premier Enterprise framework for JavaScript development. I am super excited for the Ext JS community. Today there are few independent IT organizations with our resources committed to developers. There are also a lot of immediate benefits for our existing Delphi and C++ developers. Over the years RAD Studio provided many Web development options, but none has had the robustness of our core VCL and FMX frameworks. As Web usage exploded, this has contributed for some in the decline of popularity for Delphi. The Ext JS framework is a match to VCL in terms of sophistication and scalability. There are already several good ways to bridge the technologies. As always, we have really smart partners in our technology ecosystems that have developed deeply integrated solutions (e.g. UniGui, Kitto). Developers can also use Ext JS through the REST API connectivity enabled by RAD Server. We will work with our technology partners to make the integration even more seamless.


The product team also just published a roadmap updated for September 2017. It includes plans for the upcoming 10.2.2 and 10.3 releases. There are also details on some research areas R&D is exploring. All of this as we continue our commitment to developers in keeping Delphi, C++Builder, and RAD Studio the premier choice for expert developers everywhere.


After a busy summer, we are all preparing for a busier fall. The community is full of ideas, Block Chains, more IoT support options, better TFS integration, and as always many ideas for language features. Our PMs are busy evaluating ideas and working with R&D on specs. We are open to technology partners and MVPs to participate and introduce products that expand our capabilities, Woll2Wall made an awesome Beacon Editor with FMX, the much anticipated FMX Linux Clients are out, there are cool FMX designer ideas, so much more to come. We’ll demonstrate a lot of these during CodeRage coming November 7th.


This is going to be a productive fall. Get on 10.2.1 and build some awesome apps!

RAD Studioロードマップ(2017年9月付)

Written by Hitoshi Fujii on . Posted in News

この記事は、Marco CantuによるRAD Studio Roadmap September 2017の抄訳です。

RAD Studioの現在と将来に関する2017年9月付のロードマップをご覧ください。

RAD Studio / Delphi / C++Builderのアップデートは、製品を購入すると標準で1年間有効なアップデートサブスクリプションサービスによって提供されます。

RAD Studio Roadmap September 2017

Written by Marco Cantu, RAD PM on . Posted in Articles

Check out the latest RAD Studio Roadmap, September 2017 update, to learn where RAD Studio is now, and where it is going.


the RAD Studio PM team (Sarina DuPont, David Millington, Marco Cantu)



Deep Dive: Hospitality Survey App Template For RAD Studio 10.2.1 ...

Written by Eli M on . Posted in Articles

The Hospitality Survey App template can be downloaded through Embarcadero's GetIt which is built into the RAD Studio IDE. It consists of four different projects that interconnect with each other. The projects are:

  • Hospitality Survey Setup
  • Hospitality Survey EMS
  • Hospitality Survey Admin
  • Hospitality Survey Client

You should deploy and run the projects in the following order:

1) The Hospitality Survey Setup app will help you set up your database, the tables and data, and your EMS user accounts.

2) The Hospitality Survey EMS is the RAD Server side REST resource which both the Hospitality Survey Client and the Hospitality Survey Admin interface with. It should be deployable on Windows and Linux through IIS, Apache, or the stand alone EMS server.

3) The Hospitality Survey Client is a RAD Studio client application for Android, iOS, macOS and Windows. The client application should allow you to select a tenant from your RAD Server and then log in as a user. Once logged in it will download the survey data for your current tenant and allow the survey to be filled out. Once the survey is complete it can be submitted back to the server and a new survey can be started.

4) The Hospitality Survey Admin app is an AngularJS application for the web. You should be able to log into the application with your Tenant ID and RAD Server user ID. The web app should allow you to view statistics and graphs about the results of the survey questions and each individual question and answer. You can also export a list of emails collected from the surveys.


In Depth Developer Guide Webinar


Hospitality Survey Setup

Start: Your EMS Server should already be setup and running.

Step 1: Set a path for your stores database. Set the path to the EMSServer database.

The stores database is created, used, and populated with data in Step 4.

The EMSServer database link is used to populate the drop down of Tenant IDs in Step 3.

Step 2: Setup the demo users on the EMS Server using the EMS API.

You will need your EMSServer Host, Port, and Tenant IDs in this step. The Setup will connect to your EMSServer and create groups and users for the template.

You can create Tenant IDs using this tutorial:

Step 3: Customize the questions to be asked in the survey for each tenant. A blank tenant_id will be asked to all tenants.

You can customize the questions in your survey on Step 3. The fields are:

  • ID - An ID for the question.
  • name - A short name for the question with no spaces.
  • title - The text of the question as it will appear in the survey.
  • type - The type of question controls which question template is loaded on the client. The existing types are: rating, yesno, edit, options
  • options - If the type of the question is set to options this field is used to populate the options. It's value is a JSON array of options.
  • value - The value is where the user submitted data is stored. It can be left blank but could be used to provide a default answer.
  • category - The category of the question. This field is provided for expandability.
  • tenant_id - The tenant ID of the question. If the tenant_id field is blank all tenants will get the question. If it is set to a tenant only that tenant will get the question.


Be sure to update the tenant IDs to to match your tenant IDs.

Pressing the Re-Generate button will create new INSERT queries on Step 4.

Step 4: Create the tables and insert the questions data into your stores database with the Initialize All button.

This step contains the SQL setup queries for the stores database. There are three tables which will be set up which are: SURVEYS, QUESTIONS, RESULTS

Each table will be dropped and re-created when the queries are run (any existing data in the tables will be lost). In the third TMemo field the SQL queries from your questions defined in Step 3 will appear.

Pressing the Initialize All button will execute the SQL queries against your defined stores database from Step 1.

Complete: After step 4 the databases and users should be setup and ready for you to use the client and admin areas.

Your EMS database and users should be setup at this point. You should be able to connect the Hospitality Survey EMS package to your new stores database and compile the package.

Once your Hospitality Survey EMS package is running in the EMS Development Server you should be able to open and compile the Hospitality Survey Client.

After you submit some survey results via the Hospitality Survey Client you should be able to log into the Hospitality Survey Admin and see your results.


Hospitality Survey EMS

The Hospitality Survey EMS is the RAD Server module for the Hospitality Survey Client and the Hospitality Survey Admin to interface with.

The end points mainly return the FireDAC JSON format which can be easily loaded in to a RAD Studio client or access via standard JSON in a non-RAD Studio environment.



GET /survey/ - Download the survey questions in FireDAC JSON format.

POST /survey/complete - Upload the survey questions and answers.

GET /survey/results/* - Download the survey results in a paged fashion in FireDAC JSON format. The page number is placed where the * is.

GET /survey/stats/all - Download various stats about the survey results in FireDAC JSON format.

GET /survey/details/* - Download the questions and answers from a specific survey ID in FireDAC JSON format. The survey ID is placed where the * is.

GET /survey/emails/csv - Download a list of all of the email addresses from completed surveys in CSV format.


GET /tenants/ - Download a list of the server Tenants which are active in FireDAC JSON format.



The endpoints are defined like this in code:

// SurveyModule.pas



procedure Get(const AContext: TEndpointContext; const ARequest: TEndpointRequest; const AResponse: TEndpointResponse);



procedure GetData(const AContext: TEndpointContext; const ARequest: TEndpointRequest; const AResponse: TEndpointResponse);



procedure PostData(const AContext: TEndpointContext; const ARequest: TEndpointRequest; const AResponse: TEndpointResponse);



if ARequest.Params.Values['query'] = 'results' then

if ARequest.Params.Values['query'] = 'stats' then

if ARequest.Params.Values['query'] = 'details' then

if ARequest.Params.Values['query'] = 'emails' then



// TenantModule.pas


procedure Get(const AContext: TEndpointContext; const ARequest: TEndpointRequest; const AResponse: TEndpointResponse);


The variable in the /survey/results/* and /survey/details/* endpoints is accessed via ARequest.Segments object like below:


  if ASegments.Count = 3 then // first segment is "survey" second is "results or "details" third segment is the variable


    SurveyId := ASegments.Items[2];


User permissions:

User permissions are governed by the {$DEFINE GROUPPERMISSIONS}. You can comment or uncomment this line for dev and live deployments. User permissions are ignored when {$DEFINE GROUPPERMISSIONS} is commented out.


Hospitality Survey Admin

The Hospitality Survey Admin dashboard project which was built in AngularJS. The Admin Dashboard connects to RAD Server on the backend via a REST API. The stats that are displayed are for data that has been collected in the Hospitality Survey Client. AngularJS is a popular framework for building web applications. It uses straight Javascript and HTML as it's template language. The data binding functionality that it offers eliminates a lot of the CRUD code you would normally have to build. AngularJS uses HTML as it's View and Javascript as it's Controller. You can quickly consume JSON from REST end points and display it using AngularJS. 

You should be able to log into the Admin area using a Tenant ID and Tenant Secret plus the login and password for a user in the Managers Group. For this template the default user is Manager1.

Note: You must log in with your Tenant ID as the Store ID and not the Tenant Name.


Copy index.html and the img, js, and styles subdirectories to your web server. Optimally you should place them on the same web server as your RAD Server DLL or Shared Object file. They could be placed in an admin subdirectory. You can place them on a different web server than RAD Server but you will need to make sure that your CORS Access-Control-Allow-Origin is set up correctly.

Within the js/admin.js file you should configure the $scope.ServerURL variable to point to the host where you RAD Server install is located. The default is: http://localhost:8080/


CORS Accept permissions:

Within the js/admin.js file you can configure the CORS settings for dev and live versions within the $scope.getHeader function. By default it is setup for development. When you want to switch to the live version (and enable user permissions) you can uncomment the line containing the X-Embarcadero-Session-Token and comment out the line without it. Switch back and forth between the two as needed.

There is a similar setting in the Hospitality Survey EMS server for configuring permissions for dev or live.


REST Endpoints & FireDAC

The Hospitality Survey EMS endpoint returns FireDAC tables as JSON. This allows interchangable compatibility between RAD Studio and clients like AngularJS. Here is an example of walking through the FireDAC table JSON tree to get to the records: data["FDBS"]["Manager"]["TableList"][0]["RowList"]

In addition to AngularJS the Admin Dashboard also utilizes Chart.js, BootStrap, and a custom Bootstrap style. The Bootstrap style is from and you should be able to go there and get other styles. If you replace the existing style in the project with one of the other styles on it should just drop it without any other effort and you will have an entirely new look (just like how FireMonkey styles work). Chart.js is available from which is a great Javascript library for displaying chart data dynamically in the browser. The Chart.js library has a special shim for AngularJS which facilitates the data exchange between AngularJS and Chart.js. Lastly, BootStrap is used which provides visual theming on HTML form elements (among other things). There is also a special shim for AngularJS which facilitates the easy integration with BootStrap.


Hospitality Survey Client

The Hospitality Survey Client connects to the Hospitality Survey EMS server on multiple end points for downloading and upload data. It is built to be cross platform on Android, iOS, macOS, and Windows using a single codebase and single UI.

The survey is dynamically generated based on the questions that are downloaded from the Hospitality Survey EMS server. Each question is assigned to a TFrame which displays that type of question.


The architecture of the app is built in a rapid application development style using TTabControl for handling pages and individual frames for each page. TActionList is used to consolidate much of the code in the MainForm.



uMainForm.pas - Contains the main form of the application including the TTabControl with the design time frames.

uTenantListForm.pas - Contains a separate form for selecting the active Tenant ID.



uTenantsDM.pas - Contains the non visual components for downloading the Tenant list.


Design Time Frames:

uStoreLoginFrame.pas - Contains the store login frame.

uLoginFrame.pas - Contains the user login frame.

uMenuFrame.pas - Contains the main menu of the application including the Take Survey button.

uFinishFrame.pas - Contains the final frame of the application including the Thank You button after a survey has been completed.

uBackendFrame.pas - Contains the non-visual components for downloading survey data and uploading the results.

uProgressFrame.pas - Contains the animated progress controls which are displayed when the application is doing work.


Dynamic Frames:

uComboBoxFrame.pas - Contains the combo box survey question type.

uCompleteFrame.pas - Contains the complete button for the survey.

uEditFrame.pas - Contains the edit survey question type.

uRatingBarFrame.pas - Contains the star rating track bar survey question type.

uSurveyHeaderFrame.pas - Contains the header for the top of the survey.

uYesNoFrame.pas - Contains the Yes/No survey question type.


If you want to make changes to the design time frames be sure to edit the frame itself and not the version of it that is embedded in the MainForm. This will keep your changes consolidated in one place. If you changes don't update in the MainForm you can delete the Frame from the MainForm and re-add it. Be sure to add it to the correct Tab and set to Align Client after you add the frame.

Note: You must log in with your Tenant ID as the Store ID and not the Tenant Name.


Restaurant Image:


Hospitality Survey Editor

There is also a Hospitality Survey Editor app which will connect to your existing Hospitality Survey database and allow you to customize the questions which are asked in the client. The questions are stored in a table in the database and then downloaded to the client as JSON through RAD Server. The Hospitality Survey Client app loads the JSON and then dynamically creates the input fields using TFrames.

The Hospitality Survey Editor app was created by stripping down the Hospitality Survey Setup app and connecting it directly to the Hospitality Survey database.

Download the full source code for the Hospitality Survey Editor in FireMonkey for Delphi 10.2 Tokyo.


Hospitality Survey Admin Client

There is also a Hospitality Survey Admin Client that is another version of the Hospitality Survey Admin dashboard. It is built in Delphi 10.2 Tokyo instead of AngularJS and can be deployed to Android, iOS, macOS, and Windows 10. The Admin Client interface is very similar to the one found in the AngularJS version. TeeChart Lite which comes with RAD Studio was used for the charts in the business Dashboard. The survey results for each completed survey are displayed using the dynamic form code from the original client as well. The Admin Client is based off the main client and just updated to make new REST calls to the needed endpoints for the admin data.

Download the full cross platform source code of the Hospitality Survey Admin Client for Delphi 10.2 Tokyo.


RAD Studio 10.2.1をリリース

Written by Hitoshi Fujii on . Posted in Articles

この記事は、Marco CantuによるRAD Studio 10.2.1 Released Todayの抄訳です。

10.2 Tokyo Release 1が公開されました。これは、Delphi 10.2 Tokyo、C++Builder 10.2 Tokyo、RAD Studio 10.2 Tokyoの有効なアップデートサブスクリプションユーザー向けのアップデートです。このアップデートには、100以上のプラットフォームにフォーカスした改善、バグフィックス、機能強化が含まれています。

RAD Studioは現在、5つのプラットフォーム(Windows、Mac、iOS、Android、Linux)をサポートしています。プラットフォームベンダーは、頻繁にOSに変更を加えており、ときに開発の面でも影響を受けることがあります。私たちは、こうした変更を継続的に追跡することで、お客様が最新のOS環境を対象とできるようにしています。10.2.1は、数多くの新機能やバグフィックスだけでなく、お客様にとって大きな影響のある主要なOSの変更にも対応しています。重要な修正のひとつは、Windows 10 Creators UpdateにおけるOSレベルでの変更に対応するコンパイラとリンカの変更です。これは、OSがDLLとDelphiパッケージ(BPL)をロードする方法に影響を与えるもので、ロード操作が複数回繰り返されることと、ランタイムパッケージを使用したアプリケーションのデバッグが行えないという問題を引き起こしていました。マイクロソフトは、この問題をWindows 10の将来バージョンのベータ版で修正していますが、Creators Updateには反映されていません。

2017年5月、私たちは最新のロードマップを公開しました。インストールベースでもVCLが広く普及していることを鑑み、このフレームワークの急速な進化を継続させ、この分野に対する投資を加速していきたいと考えています。Windows 10の利用も拡大しており、今後のリリースにおいては、開発者に対してより大きな価値を提供できると思っています。このようなフォーカスと追加のプラットフォームサポートがリリーススケジュールに加えられたことで、これまでロードマップの10.2.1と10.2.2にリストされていた項目の優先順位が、10.2.2以降に変更されることになりました。これにはC++のLinuxサポートも含まれます。製品担当マネージャチームでは、今後数週間にロードマップの更新を行う予定です。

10.2 Tokyoの主な機能


  • Delphi LinuxコンパイラとRTL、Linuxサーバー開発、配置、デバッグ向けの完全なツールチェイン
  • C++コンパイラとリンカの改善
  • Desktop Bridge によるWindows 10ストアサポート
  • 新しいVCLコンポーネントとQuickEditデザイナ



Enterprise Connectors

CDataとの長年の協業により誕生したEnterprise Connectorsは、RAD StudioのFireDACテクノロジーを活用し、複数のデータソースに接続する際の複雑性を解消し、CDataのアダプターをDelphi / C++開発者が容易に利用できるようにします。

Enterprise Connectorsは、Salesforce、NetSuite、Microsoft Dynamics、SAP、SugarCRM、MailChimp、JIRAなど80以上の主要なデータソースへの接続をサポートしています。

Enterprise Connectorsは、現在、アップデートサブスクリプションユーザーは誰でも利用できるパブリックベータ版が提供されています。それぞれのコネクターは、10.2 TokyoのGetIt Package Managerから入手できます。ベータ版は、ここ数週間で終了する予定です。ぜひ、皆さんのフィードバックをお寄せください。

GetIt Package Managerの改善

GetIt Package Managerを用いれば、IDE内で直接パッケージを検索、ダウンロード、インストールできます。オープンソースまたはサードパーティのライブラリ、コンポーネント、IDE拡張、SDKなどが含まれます。GetIt Package Managerは、IDEのツールメニューからアクセスできます。今回、10.2 TokyoのGetIt Package Managerにいくつかのカテゴリーを追加し、GetIt内での検索を容易にしました。

以下は、GetIt Package Managerの新しいカテゴリーリストです。

  • All
  • Libraries
  • Components
  • Internet of Things
  • Trial
  • Connectors
  • Industry Templates
  • IDE Plugins
  • Styles
  • Sample Projects

RAD Studio 製品管理チーム (Sarina, Marco, David)

RAD Studio 10.2.1 Released Today

Written by Marco Cantu, RAD PM on . Posted in Articles

10.2 Tokyo Release 1 is now available. It’s an update of Delphi 10.2 Tokyo, C++Builder 10.2 Tokyo and RAD Studio 10.2 Tokyo for active Update Subscription customers. It includes 100s of platform focused enhancements, bug fixes and features.

RAD Studio supports 5 platforms today: Windows, Mac, iOS, Android and Linux. Platform vendors frequently make changes to their operating systems which at times impact us on the development side. We continuously track these changes to ensure our customers can target the latest operating systems. 10.2.1 not only provides a number of new features and bug fixes, but also addresses key OS changes that have been impacting our customers. A significant issue we fixed on Windows was changing our compilers and linkers to address an OS level change on Windows 10 Creators Update affecting the way the operating system loads DLLs and Delphi packages (BPLs), which ends up repeating the load operation multiple times and severely hampering the debugging of applications with runtime packages. Microsoft has addressed the issues in the beta of the future version of Windows 10, but not in Creators Update.

In May 2017, we published our latest roadmap. Given the popularity of VCL within our install base, we want to make sure that this framework continues to evolve rapidly and we are accelerating investments in this area. We see a nice increase in usage of Windows 10 and we feel that we can deliver even more value to developers with the coming releases. With that focus and the addition of the platform enhancements release to our release schedule, you will see that some some of the features previously listed under 10.2.1 and 10.2.2 in our roadmap are being reprioritized for 10.2.2 and beyond. This includes C++ for Linux. PM will be providing additional roadmap updates in the coming weeks.

Key Features delivered in 10.2 Tokyo

Below is a recap of key features we’ve delivered  in recent months (including Berlin updates):

  • Delphi Linux compiler and RTL, along with complete toolchain for Linux server development, deployment and debugging

  • C++ compiler and linker improvements

  • Windows 10 Store support via Desktop Bridge
  • New VCL controls and QuickEdit designers

Exciting developments this year

In addition to the Tokyo release several months ago, and the 10.2.1 update release, we also wanted to highlight some other exciting developments.

CData Enterprise Connectors

The result of a year-long collaboration effort with CData, Enterprise Connectors leverages Embarcadero’s RAD Studio FireDAC technology to remove the complexity in connecting to multiple data sources, and make CData's adapters easily accessible to Delphi and C++ developers.

CData Enterprise Connector Packs support 80+ popular data sources such as Salesforce, NetSuite, Microsoft Dynamics, SAP, SugarCRM, MailChimp and JIRA.

The Enterprise Connectors are currently in Public Beta, allowing anyone on Update Subscription to participate. Downloads for each connector are available through the GetIt Package Manager in 10.2 Tokyo. The beta is expected to finish within the next few weeks, and we’d love to get your feedback.  

GetIt Package Manager Enhancements

The GetIt Package Manager enables browsing, download, and install of packages directly within the IDE. This includes open source and 3rd party libraries, components, IDE extensions, SDKs, and more. The GetIt Package Manager can be accessed through the Tools menu in the IDE.

We have recently added a number of new categories to the GetIt Package Manager in 10.2 Tokyo to make it easier to find what you're looking for in GetIt.

Here's the new list of categories you will find in the GetIt Package Manager:

  • All
  • Libraries
  • Components
  • Internet of Things
  • Trial
  • Connectors
  • Industry Templates
  • IDE Plugins
  • Styles
  • Sample Projects

The RAD Studio PM team (Sarina, Marco and David)

More 2017 FireDAC Webinars

Written by Jim McKeeth on . Posted in Articles

To follow up with our recent FireDAC in Depth with Cary Jensen we have a series of FireDAC webinars to help you learn more about everyone's favorite database access framework. Each webinar is offered at 8 AM, 1 PM and 8 PM US Central Time to provide access in all timezones. 


  • 25-Jul (Tue) FireDAC Introduction
    • An introduction to the multi-platform, multi-database, full featured, super fast database access framework.
  • 27-Jul (Thu) FireDAC Tracing and Monitoring
    • How to use FireDAC's Tracking and Monitoring features for advanced logging and troubleshooting.
  • 01-Aug (Tue) FireDAC Cached Updates and Autoinc Fields
    • Learn to use autoincrement fields as primary keys, and cached updates to cache multiple updates in memory and write them all to the database at a later time in a single batch.
  • 03-Aug (Thu) FireDAC Array DML
    • The Array DML execution technique submits a single DBMS command with an array of parameters. Each command parameter has an array of values, and all parameters have arrays of the same length. Then FireDAC requests the DBMS to execute a command once for each row in arrays. This technique reduces the amount of communication between DBMS and client, enables DBMS to stream command execution, and speeds up execution time.
  • 08-Aug (Tue) FireDAC Cascading Options System
    • Learn to use the cascading system of setting options for optimal FireDAC performance
  • 10-Aug (Thu) FireDAC: Preprocessing SQL Commands
    • FireDAC Preprocessing includes "macro" and "escape sequence" allowing dynamic generation of more complex sets of operations for performance and less work on the developer's part.
  • 15-Aug (Tue) FireDAC ETL = Extract, Transform, Load
    • The FireDAC Extract, Transform and Load functions work with the batch move, reader and writer components for data movement between different types of data sources and the data destinations.
  • 17-Aug (Thu) FireDAC In Memory DataSets: TFDMemTable
    • The FireDAC in memory data set lets you work with an offline or in memory dataset with being connected to a database. This can be helpful in a briefcase model, or when adding dataset functionality to a non-database driven application.
  • 22-Aug (Tue) FireDAC Local SQL
    • Local SQL gives you the full power of SQL based set operations across datasets from diverse sources, including different databases, different data engines and in memory data.
  • 24-Aug (Thu) Migrating BDE applications to FireDAC and InterBase
    • Learn how to migrate your legacy BDE based database application to FireDAC and InterBase to keep your programs relevant and to take advantage of all the new features and functionality.
  • 29-Aug (Tue) Migrating dbExpress Applications to FireDAC
    • Learn how to migrate away from dbExpress to give your applications the full power of FireDAC
  • 31-Aug (Thu) Using InterBase Events and Change Views with Callback Functions
    • Get more power from InterBase with events, change views and call back functions.

Viewing Salesforce Data in RAD Studio Data Explorer

Written by Sarina D on . Posted in Articles

How to view Salesforce data in RAD Studio Data Explorer using the Enterprise Connectors for Salesforce.

With the Enterprise Connectors for Salesforce, you gain access to live Salesforce data within RAD Studio, abstracting the data into tables, views, and stored procedures that can be used to both retrieve and update Salesforce data. This article will walk through connecting to Salesforce using the Data Explorer.

Connecting to Salesforce Data Using Data Explorer

You can create a simple application for displaying Salesforce data by utilizing the Enterprise Connectors for Salesforce and a new VCL Forms Application:

  1. Open the Data Explorer in RAD Studio and expand FireDAC.
  2. Right-click on CData Salesforce Data Source and click Add New Connection.

  3. Name the connection.
  4. Fill in the necessary connection parameters and click OK. 


    There are several authentication methods available for connecting to Salesforce: Login, OAuth, and SSO. The Login method requires you to have the username, password, and security token of the user.

    If you do not have access to the username and password or do not wish to require them, you can use OAuth authentication.

    SSO (single sign-on) can be used by setting the SSOProperties, SSOLoginUrl, and TokenUrl connection properties, which allow you to authenticate to an identity provider. See the "Getting Started" chapter in the help documentation for more information.


  5. Back in the Data Explorer, expand the tables for the connection.
  6. Create a new VCL Forms application and drag a table (for example: Account) onto the form.

  7. Select the AccountTable object on the form and set the Active property to true.
  8. Right-click on the object, bind visually, and link everything (*) to a new control (TStringGrid).

  9. Arrange the TStringGrid on the form and run the application to see the Account data.

Ready to try the Enterprise Connectors? Download the beta builds today. Just open RAD Studio 10.2, navigate to Tools > GetIt Package Manager and select from over 70 connectors. Requires RAD Studio Pro or higher editions.

Check out more tips and tricks in this development video: