Connecting from RAD Studio

The CData FireDAC Components for Google BigQuery implement the standard FireDAC classes and integrate Google BigQuery into RAD Studio wizards. You can access the components from the RAD Studio Tool Palette and use the components alongside standard FireDAC classes like TFDQuery, TFDManager, and TFDConnection.

Connecting from Google BigQuery

See Establishing a Connection to connect with the Data Explorer and FireDAC Connection Editor wizards.

RAD Studio Version Support

RAD Studio 10.4 (Sydney) and above are supported.

Google BigQuery Version Support

The component enables read/write SQL-92 access to the BigQuery tables in your Google account or Google Apps domain. The complete aggregate and join syntax in BigQuery is supported. Additionally, statements in the BigQuery syntax can be passed through. The component uses version 2.0 of the BigQuery Web services API: You must enable this API by creating a project in the Google Developers Console. See Connecting to Google for a guide to creating a project and authenticating to this API.

Dependencies

CData FireDAC components require the 2010 version of the VC++ (x86/x64) redistributable package that matches the bitness of RAD Studio being used. You can download this from Microsoft:

2010 VC++ Redistributable package download Note: The appropriate VC++ redistributable package requires distribution with the deployed application.

See Also

• See Creating VCL Applications to use the Form Designer to create a simple VCL application that queries Google BigQuery.
• See Writing Data Access Code to create TFDConnection objects. See Connection Definitions for other ways to create connections, with TFDManager for example.
• See Using the FireDAC Components for Google BigQuery-specific examples of executing prepared statements, discovering schemas, and writing other data access code.