Connection to Google Analytics

[Former Member]

Hi,

Does anyone know how I can directly connect SAP Lumira to Google Analytics utilizing ODBC?

Thank,

Petya

[former_member183750 · Accepted solution]

See:

Or you could create an extension to deliver direct ODBC access to Google Analytics.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place 

[Former Member · Accepted solution]

Thank you for your help!

[Former Member]

You can write your own Data extension in JAVA or language of your choice to access Google Analytics (GA) data. You have to create a project in google developer console and follow OAuth to authenticate.  There are many ways in OAuth, follow the one which is applicable to you.

https://console.developers.google.com/project

Get the java libraries from below link. Bases on my experience please use the latest one v3.

Supported Google APIs  |  API Client Library for Java  |  Google...

Below is the link I referred while writing GA connector for Lumira.

Hello Analytics API: Java quickstart for installed applications  |  Analytics Core...

Hope it helps.

- Mayank Mishra

[Former Member]

Hi Mayank,

If you have written DAE for google analytics, can you share it?

[former_member183462]

Hi Mustafa & others,

We already have a published DAE for Google and YouTube Analytics by Mike Voloshko, published on GitHub at: SAP/lumira-extension-da-google-and-youtube-analytics · GitHub

Cheers!

- Annie

[WernerS]

Hi Annie

the extension does not work with lumira 1.29.

I cannot install it.

Do you now if there is a new version?

Warm regards

Werner

[former_member183462]

Hi Werner,

Have you installed the latest version? It's on the GitHub link. Make sure you have installed this one: https://github.com/SAP/lumira-extension-da-google-and-youtube-analytics/blob/master/Extension%20File...

Let me know how that works out for you.

Thanks,

Annie

[WernerS]

Hi Annie

i did the mistake to not extract the big fiel to get the insallation zip.

Now it works, many thanks.

Werner

[Former Member]

Hi Annie

I am wondering if you could point us in the right direction with this ?  We have installed the extension within Lumira 1.3 and have set everything up but are getting the following error when trying to create a new dataset:

As we are testing this locally, we have given the local IP address (with port) for the origin destination when setting up the API

Are we missing this ?

Hope someone can help us climb out this hole !

Points at the ready...

Thanks

Ian

[former_member207736]

not sure but is your client id wrong or expired?

try resetting -> Getting Started  |  Analytics Embed API  |  Google Developers

[former_member183462]

Hi Ian,

As Rahul mentioned, try with a fresh project, new client ID and API key.

Cheers,

Annie

[IvervandeZand]

Hi all,

I need help here since way less-technical than all of you. I installed the extension in Lumiura 1.31. I also created the API key and Client ID key.

Following questions:

The "Webcontent\com\sap......\ExtensionUtils.js" file. Do I need to create it, since I cannot find it on my pc. If I need to create or edit it, where exactly do I need to store the file.

What about checking the port number? I can check it, but where exactly do I need to adjust settings in Lumira

I small demo movie guiding us would be really appreciated !

cheers

Iver

[Former Member]

Hi Iver,

I face the same problem. Have you solved the problem?

Regards,

Frank

[Former Member]

Hi Petya,

you can refer the same document which Ludek just mentioned:

Hope it helps you

Thanks,

Megha

[Former Member]

Thank you, Megha!