Facebook Connector and Extraction of Data through Matillion ETL
September 8, 2021ADDING JDBC DRIVER TO MATILLION
September 8, 2021Challenges Faced while Connecting Google Ads by Google ads connector :
Facing Issue while Connecting Google Ads by Google ads connector through OAuth Authentication. It was not Configuring Google Ads through Matillion. Explained below is a step-by-step process to connect Google ads connector using Google ads connector to matillion.
PREREQUISITE Google ads connector:-
- Google Ads Configuration.
- Client Id.
- Client Secret.
- Developer Token.
- Client Customer Id.
Creating an OAuth Entry in Matillion ETL
- In Matillion ETL, on the top left of the screen, click Project→ Manage OAuth.
2. Copy the Callback URL in the field at the top of the window as this will be required in Acquiring Third-Party Credentials.
3. Click +in the bottom left of the window to open the Create OAuth Entry
4. Click the Service drop-down menu and select Google. Then, provide a name for the OAuth in the Name field and click OK.
5. On returning to the Manage OAuthwindow, check the list of OAuths to ensure the new entry is listed.
Acquiring Third-Party Credentials
- Navigate to the Google Developers Console. The Google login screen will appear immediately. Enter valid login credentials to continue. The browser will then redirect to the API & Services Click the project dropdown menu next to Google APIs in the top left of the screen.
- The project window will pop up. Click NEW PROJECTin the top right of the window.
- On the New Project screen, provide details for the following fields:
- Project name– provide a name for the project
- Organization– select an organization to be associated with the app
- Location– select a folder where the project will be stored, then click Create
- The browser will return to the API & Services Now click the OAuth consent screen in the sidebar. On the OAuth consent screen, provide details for the following fields:
- Application name– provide a name for the app
- Support email– provide an email address to be used to provide support for the app.
- Next, scroll down the Authorised domains section and provide details for the following fields:
- Authorized domains– provide all domain URLs associated with the app including the domain URL of the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier)
- Application Homepage link– provide the homepage URL for the app (it must also be listed among the above-Authorised domains), then click Save
- The browser will return to the API & Services Click Credentials on the sidebar. Then, in the Credentials window, click Create credentials → OAuth client ID.
- Now, on the Create OAuth client page, select Web Application under Application type to reveal further options. Then, provide details for the following fields:
- Name– provide a descriptive name for the client ID
- Authorized redirect URLs– provide the Callback URL (earlier listed on the OAuth consent screen as one of the Authorised domains).
- The browser will return to the API & Servicesdashboard once again, now with a pop-up window featuring the client and client secret. Copy both the client ID and client secret codes from the fields as they will be required in Authorising for use in Matillion ETL.
- A service API will now need to be enabled to work with the newly created credentials. Click Library on the sidebar, and in the API Library window, either type the name of the relevant service into the search field at the top of the screen or scroll down and click on the relevant service block.
- Once a service has been selected, the relevant API window will open. To enable the API for use with the app, simply click Enable.
Authorizing for Use in Matillion ETL
- Return to the Manage OAuthwindow in Matillion ETL and click ⚙next to the previously created OAuth entry. This will open the Configure OAuth
- Using the codes copied from the Google Developers Consoleearlier, provide details for the following fields:
- Client ID– enter the client ID
- Client Secret– enter the client secret, then click Next
Connecting Via a Proxy
When connecting via a proxy, the following Advanced Connection Options must be set to complete the authentication:
- proxyserver= 0.0.141
- proxyport= 3128
- The next window will have an Authorization link. Click the link to authorize Matillion ETL to use the acquired credentials
- The browser will then redirect to a login screen to connect the Google account to the app. Click the associated account name to confirm the connection. A prompt will then ask permission to access each feature associated with the Google account. Either Allow or Deny to continue to the next prompt.
- Once permission has been allowed or denied to each associated Google feature, a final window will confirm all the permissions together. Click Allow to confirm all is correct.
- If all is successful, the browser will return to Matillion ETL with a window stating, “Authorization Successful”.
Google AdWords Query
->Properties: