Connecting to Google Display & Video 360 via SQL

You can use SQL to connect to Google Display & Video 360 in the CData Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need a ClientId, ClientSecret, RefreshToken, AccessTokenEndpoint.

How to Connect

Before you start retrieving data, you need to run the connector script for Google Display & Video 360 in the CData Virtuality Studio or the Web UI and input your credentials in the following line:

SQL

CALL SYSADMIN.createConnection (
    name => 'google_display_video'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'SecurityType=OAuth2,EndPoint=https://www.googleapis.com/doubleclickbidmanager/v1.1,AccessTokenEndpoint=https://accounts.google.com/o/oauth2/token,ClientId=&lt;ClientId&gt;,ClientSecret=&lt;ClientSecret&gt;,RefreshToken=&lt;RefreshToken>'
);;
 
CALL SYSADMIN.createDataSource (
    name => 'google_display_video'
    ,translator => 'google_display_video'
    ,modelProperties => ''
    ,translatorProperties => ''
);;