Overview

The CData JDBC Driver for Google Ads models Google Ads entities in relational views and stored procedures. The provided views will give you access to your Google Ads data using the Google Ads API.

Key Features

• The driver models Google Ads entities like documents, folders, and groups as relational views, allowing you to write SQL to query Google Ads data.
• Stored procedures allow you to execute operations to Google Ads.
• Live connectivity to these objects means any changes to your Google Ads account are immediately reflected when using the driver.

Views

Views describes the available views. Views are statically defined to model Campaigns, AdGroups, Customers, and more. They are mainly used as a way to create your custom reports instead of being used standalone.

The Resources view shows the names of the resources, attribute resources and segmenting resources, which you need for the CreateReportSchema stored procedure.

Stored Procedures

Stored Procedures are function-like interfaces to Google Ads. Stored procedures allow you to execute operations to Google Ads, the most important being CreateReportSchema, which is used to create views from resources (like 'distance_view') with attribute resources (like 'customer' in this case) and segmenting resources (like 'campaign' in this case).