SSIS Data reader for Google Analytics 25


Please Share



Tutorial

The TARGIT Google Analytics SSIS task was a project I was in charge of at TARGIT. The company discontinued the project. There will be no support or further releases of the task.

I recommend anyone using the TARGIT Google Analytics SSIS package find a new option. I have asked them to opensource it so that development can continue on the project but have not heard anything about that as of yet.

Please Share


Linda Lawton

About Linda Lawton

My name is Linda Lawton I have more than 20 years experience working as an application developer and a database expert. I have also been working with Google APIs since 2012 and I have been contributing to the Google .Net client library since 2013. In 2013 I became a a Google Developer Experts for Google Analytics.


Leave a Reply to Sandy Cancel reply

Your email address will not be published. Required fields are marked *

25 thoughts on “SSIS Data reader for Google Analytics

  • Siljith

    Hi Linda,

    Can I use this connector to pull the data from GA directly to SSIS. I’m working on a project which want to pull data from GA and store in Data warehouse periodically.I was creating a PoC using Google Analytics API based on your tutorial “Google Analytics API – Seven part Tutorial Series”. Then realize it is not a correct fit for my requirement. Can you please suggest a best way to do this ?
    Kind Regards,
    Siljith

  • Siljith

    Hi Linda,
    Many thanks for the reply.By POC I meant Proof Of Concept. Once again many thanks for taking time to create tutorials like this.
    Siljith

  • Siljith

    Hi Linda,

    I tried Targit data reader in my PC. The package is installed at C:\Program Files (x86)\TARGIT\BIA\Google Connect\SSIS . But when I try to invoke it is closing immediately. Is there any prerequisites ? I’ve .net framework 4.5 and Sql Server 2014 in my computer.

    Many thanks,
    Siljith

  • Siljith

    Hi Linda,

    i tried the connector. It works fine. Is there any way I can configure service authentication for this connector as I want to automate the process ?

    Regards,
    Siljith

    • Administrator
      Linda Lawton

      Once you have added the connection manager it saves the refresh token, It will be able to run automated.

      Tip: If you are going to use this on several packages you may want to have a dedicated Google account to authenticate SSIS task with. Goolge only allows you to have 26 refresh-tokens in use, once you authenticate 26 SSIS packages the first one will stop working.

  • Tim

    Hi Linda,

    Is it possible to set the values in the Targit Data Reader (e.g. StartDate and EndDate) with the use of expressions?

    Thank you,
    Tim

  • Siljith

    HI Linda,

    All looks good. But one concern. Can you please confirm that this connector won’t collect any of our data for any other use.I want to use it for a project and my stakeholders are concerned about data security.
    Please reply .

    Thanks,
    Siljith

  • Tom

    Hey Linda,

    thanks for your great post.
    Do you know if it is possible to set the ProfileId over an expression to change it during runtime in a for each loop ? I tried this but got an error – maybe im doing something wrong.

    Thanks in advance and kind regards

    Tom

    • Administrator
      Linda Lawton

      Hi Tom,

      That is not something we have tried, If I had to guess i would say you could probably do it with a script task.

      What I would like to know is why you want to bother. If you select more then one profile id in the connection manager it will handle looping over several for you automatically.

      Linda

      • Tom

        Hi Linda,

        i want to store the data in a database. So at the moment i have three profiles but only need two to load. But in the future i will load the third one too. In that case i want the GA READER just to load the new profiles data from the beginning. The other two profiles should be loaded incremental.

        I tried to do this but the GA Reader fails as soon as i pass a value to my ProfileId variable during runtime.

        Regards,

        Tom

        • Administrator
          Linda Lawton

          I don’t think that is going to work. The data reader will always load by the dates so even if you managed to get the variable profile id working, its only going to load for the same dates as the old profiles.

          In the past when I wanted to load all the data I would set start date to 2006 if memory serves that’s when Google Analytics started.

          Personal I would just make a new another package with the new profile in it.

          Linda

      • SQL Daddy

        Hello Lindaaaa,
        I have SSIS Google Analytics Source connector complete power pack ,that can be used to read data from Google Analytics Service without learning complex APIs.Easy to use interface allows you extract large amount of data adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data. We are having sample work of this and we also have shared video where task is explained that how to work with this. Hope You will be abpble to resolve your error .I am sharing URL here. Please Have a look.
        http://zappysys.com/products/ssis-powerpack/ssis-google-analytics-source-connector/
        Hope It will be helpful.

        • Linda Lawton
          Linda Lawton Post author

          Congratulations I wish you luck with your project. TARGIT Google Analytics is however free we don’t charge for the usage of it and has been working fine for 2 years. I am not sure what you are referring to about resolving errors. Any errors found in our task would be fixed promptly for our users.

  • Hari krishna

    Hello There,
    I have been using this component it was working fine but we cant see the exact date what i am looking in google. for example we can see the results if the page has direct link like xyz.html but we can’t see the results if the page comes like /group/xyz.html and another concern what i can see here the total AVG time on page is different in GA and the Data what we got from Targit, can you please help me to figure it out.
    Is there any document on Targit so that we can go through to use is it better as per the our requirements

    Thanks in advance

  • Sandy

    Hi.
    I’ve just taken delivery of a SQL 2016 SP1 server running on Windows Server 2012 R2.
    I installed the SQL 2016 version of the Targit data reader and the component is not showing in the SSIS toolbox.
    I’ve tried uninstalling and installing older versions of the Targit data reader (back to 2005) and same issue – no component in the toolbox in SSIS.

    Is there anything I missed? Anything I can try to make it appear?
    I’ve had the data reader working really well for a while now on my SQL 2012 box, but 2016 just refuses to play entirely!
    Thanks!