Connecting to Google Ads via SQL

You can use SQL to connect to Google Ads in the Data Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need the Client ID, Client Secret, Developer Token, Refresh Token.

How to Connect

Run the following statements in the Data Virtuality Studio or the Web UI (remember to enter your credentials):

SQL

CALL SYSADMIN.createConnection (
    name => 'google_ads_src'
    ,jbossCLITemplateName => 'adwords'
    ,connectionOrResourceAdapterProperties => 'ClientId=<ClientId>,UserAgent=<UserAgent>,ClientSecret=<ClientSecret>,DeveloperToken=<DeveloperToken>,RefreshToken=<RefreshToken>'
);;

CALL SYSADMIN.createDataSource (
    name => 'google_ads_src'
    ,translator => 'google_ads'
    ,modelProperties => ''
    ,translatorProperties => ''
);;