CData GoogleAdwords - ssis package - Token...

[Farshad Mardani]

Hello,

I am using ssis to get data from adwords into the sql server database...
I downloaded the 30 day trial version of CDATA GoogleAdwords component for the ssis.
In it's connection manager, I placed the token.
It is asking for the "OAuth Client Id" and the "OAuth Client Secret" which I do not have.

Question:

1-

Do you know how to get these "OAuth Client Id" and the "OAuth Client Secret"?

2- 

When testing the connection CData GoolgeAdwords Source in ssis, it gives this error: Test connection failed. Message: HTTP protocol error. 400 Bad Request. AuthenticationError.OAUTH_TOKEN_INVALID: <null>

Please note that the CData GoogleAdwords Source component in the edit window, shows the tables I can use from google but when trying to see the data in those tables it also gives the above error. Do you know why please?

Thank  you

[Umesh Dengale]

Hello,

The developer token, client identifier, client secret and refresh token are required to make AdWords API call. The developer token could be applied using the manager account (MCC). You could generate client identifier, client secret and refresh token by following the steps given in the OAuth2.0 guide. Please check out getting started guide and OAuth2.0 guide for more details.

Cheers,

Umesh, AdWords API Team.