TARGIT Google Analytics SSIS 41


[wp_ad_camp_3]
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.
[wp_ad_camp_5]


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 comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

41 thoughts on “TARGIT Google Analytics SSIS

  • Brian Brotherton

    Hello,

    I recently installed the plug in for SSIS 2008. I can see “Targit” listed in the avaliable connection managers, but I am not seeing it as an option as a source in the Data Flow toolbox. Do I need to do anything else to get it to show up?

    • Linda Lawton

      In the earlier versions of BIDS, the tasks must be added to the toolbox. Right click in the toolbox and, then “Choose Items…” and select the tasks in the “SSIS Data Flow Items” tab

  • Christi

    I’m trying out these tools in SSIS for SQL2014. However, trying to create the connection manager already has me stumped. As soon as it tries to authenticate, it comes back with a MethodNotFound error (‘System.Collections.Generic.IEnumerator’1 Newtonsoft.Json.Linq.JArray.GetEnumerator()’

    Any ideas?

    • Linda Lawton

      What do you see when you click the “new” button? At what stage do you get that error message? Do you have an older version of the JSon library in GAC? “C:\Windows\assembly\Newtonsoft.Json” should be version 4.5.0.0

      • Nguyen

        It’s me again. I just want to make sure that this happens to me after I clicked on “new” button then clicked on Accept. It’s after clicking on Accept that I got that “Error ShowAccounts: MethodNotFound error (‘System.Collections.Generic.IEnumerator’1 Newtonsoft.Json.Linq.JArray.GetEnumerator()” error like Christi.

    • Nguyen

      I have the same problem and I do have the JSon version 4.5.0.0 in the GAC. Please help as soon as you can because I’m already weeks behind on this implementation.

      Thanks,
      Nguyen

  • T Maroli

    Hi,

    I am looking to bring in data specific to a segment. Could you please let me know if this is possible with the data reader.?

    Thanks

  • Nguyen

    Hi,

    I tried to look for it but can’t find pricing information. How much would it be to use this? Also, per current company rules, we have to use .NET 4.0, does this support it or is there any way to support it?

    Thanks,
    Nguyen

  • Vitaliy Krasner

    Hi Linda, I setup global variables StartDate and EndDate in my SSIS project and choose to use “”SSIS varables”.
    However, there is nothing in “Start Date” and “End Date” comboboxes to select from and whatever variable’s names I typed it does not except. I did not find anything in property and in Advanced Editor to configure in order to force component to accept my variables. We are using SQL Server 2014 version. Please advise. Thank you

  • Jon Mal

    It seems like ga:visits and ga:NewVisits are missing from the list?
    Is there a reason for this or a way to update the list using an Expression in SSIS?

    Please let me know.

    Thanks

  • Dean

    Hi Linda,

    The TARGIT Data Reader for Google Analytics is exactly what I’ve been looking for to get our Google Analytics data into SQL Server for further analysis and reporting. I downloaded and installed in on my Windows 7 laptop with SQL Server 2005, set up the SSIS package in BIDS, created and new DB and table in our team’s SQL Server instance (hosted on Windows Server 2008 R2), tested the package, and it works great.

    However, when I installed TARGIT Data Reader for Google Analytics on the Windows Server 2008 R2 DB server, it shows as being installed properly, but it’s not working properly within BIDS on that server. Initially I found that the 4 DLL files did not get copied to the PipelineComponents folder within SQL Server, so I copied them there from the DLLs in that folder on my laptop. That allowed me to add the TARGIT Data Reader for Google Analytics Data Flow item to the list of Toolbox Items within BIDS on the server.

    Unfortunately, when trying to add the TARGIT Data Reader for Google Analytics Data Flow Source to the Data Flow Task stating that the “The component could not be added to the Data Flow task. Please verify that this component is properly installed.”. I restarted SSIS, and this error seemed to go away, but now I’m getting an error when trying to create the Connection Manager after double clicking on the TARGIT Data Reader for Google Analytics Data Flow Source. The error message states that the connection manager ‘TARGIT – Google Analytics’ is not properly installed. There is also an “Index out of range…” message on the dialog window.

    I’ve uninstalled, reinstalled, repaired, run the MSI from an Admin command prompt, run the MSI as Administrator (after modifying the registry), and while I’ve made some progress, I just can’t get this to work on the server. If I knew what the installer did, perhaps I could figure this out, but during install a Command Prompt window appears for less than a second and then vanishes, so I’m not sure what it’s doing.

    Any help you can provide getting this installed on my Windows Server 2008 R2 SQL Server 2005 instance is greatly appreciated.

    Thanks,
    Dean

    • Dean

      Update…

      I set up a new Windows Server 2008 R2 VM and installed SQL Server 2008 R2 SP3 on it. When I installed TARGIT SSIS For Google Analytics 2008, it’s not showing up in the Data Flow Items tab on the Choose Toolbox Items dialog window. Again, this is due to the 4 DLL files not getting copied to the PipelineComponents folder. Something with the MSI installer doesn’t seem to be working properly on the servers.

      Please help.

      Thanks,
      Dean

      • Dean

        I figured out the issue with the TARGIT SSIS For Google Analytics installer. It assumes that SQL Server is installed in the default directory. However, my SQL Server instances are not installed in the default directory. They are installed in a D: partition for the SQL 2005 server and an E: partition for the SQL 2008 R2 server. I created the DTS\Connections and DTS\PipelineComponents folders within the default SQL Server directory structure, and all of the DLL files were copied during installation to those folders, after which I copied them to the corresponding folders within my actual SQL Server installations on the D: and E: partitions. If you could update the installer to copy the DLLs to the actual SQL Server installation folders, that would be great. Thanks

  • Alexander Schneider

    Hi,

    I use SQL Server 2012 BI Edition and I have installed TARGITSSISForGoogleAnalytics2012 but
    I have no TARGIT Data Reader for Google Analytics in my SSIS-Toolbox and no TARGIT for Google
    Analytics – SSIS Connection Manager. Yet I have refreshed the SSIS-Toolbox and restarted Integration
    Services. Is there really a problem when SQL Server is not installed in the default path?

    Kind regards
    Alex

  • Julian Cox

    I downloaded the GA SSIS SQL Server 2016 Edition but when I open a project in Visual Studio 2015 community edition and add a data flow task I dont see TARGIT Data Reader for Google Analytics.
    Any ideas what might be wrong ?

    • Julian Cox

      The Visual Studio is running on an Azure VM. Could this be the problem?
      When I put GA SSIS SQL Server 2016 Edition on a laptop and use Visual Studio 2015 community edition I see the
      TARGIT Data Reader for Google Analytics.

  • Slavko

    Hi!

    Is it possible to run package with Targit connection on SQL Agenta as a scheduled job. I am trying to set this up, but when I upload package to SSIS package store, Targits connection manager for GA is missing in package.

    I tried to run it form command line, and have the same problem with error message as follows:

    “Description: The connection type “TARGIT – Google Analytics” specified for connection manager “Connect for Google Analytics” is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
    End Error”

    Many thanks for your help and best regards!
    Slavko

  • Sam

    Hi.
    I am also having a problem installing the SQL 2016 TARGIT SSIS data reader.
    It installs cleanly but the component does not appear in the SSIS toolbox.
    We also have a non-default installation – its installed on the D:\ drive.
    Can anyone help?

  • Huy Pham

    Hi
    I have installed Targit Data Reader for Google Analytics 2016 to the Windows 2012 server. I could see it in the toolbox in Visual Studio 2015. However, when dragging and dropping the Targit data reader into a data flow, VS gave me the following error. The error does not occur in the dev box which is Windows 10. What should be an issue?

    Thanks.

    Pham

    ===================================

    The component could not be added to the Data Flow task.
    Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. (Microsoft Visual Studio)

    ===================================

    Error at Load data from Google Analytics to SQL [SSIS.Pipeline]: Component , clsid {4F885D04-B578-47B7-94A0-DE9C7DA25EE2} failed to initialize due to error 0x80131600 “”.

    Error at Load data from Google Analytics to SQL [ [71]]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is “”.

    ===================================

    Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)

    ——————————
    Program Location:

    at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()
    at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewComponent(String clsid, Boolean throwOnError, Boolean select)

    • Linda Lawton Post author

      Chan you check the about on your Visual studio Which version of Integration Servicesare you running?

      Microsoft SQL Server Integration Services Designer
      Version 14.0.500.272

      • Huy Pham

        Thanks Ms. Lawton. I found the issue. It was a missing of log4net. I have installed it and it’s working now. Thanks for your time.

  • Preetpal

    Hi,

    TARGIT is a good tool and something which I was looking for. But I am facing an issue with it. I am able to read the data from google analytics and store into a sql server table.

    Now I am trying to automate the process on my machine by creating a batch file and inside batch file their will be a code to execute the package (dtexec.exe utility). but I am getting an error while doing so .
    Error –
    “Description: The connection type “TARGIT – Google Analytics” specified for connection manager “Connect for Google Analytics” is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
    End Error”
    Could someone please help me on this issue.

    • Linda Lawton Post author

      I think you should try and install it again. If it cant find the connection manager there is something wrong with your install. Unfortunately I cant be of more help as i dont work for the company anymore and due to a clause in my contract i am not allowed to consult on it anymore. I suggest you contact TARGIT

  • DanS

    This was working fine for me, but today when i edit the connection manager, once I’ve been prompted with “Targit – Google Analytics would like to view your google analytics data”, I then select “Allow” and get a blank screen, if i click cancel i get the error: “Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index”

    I’ve tried this on 3 separate machines now all with the same error, so perhaps something has changed at Google’s end?

    • Linda Lawton Post author

      I was the lead developer on this project when I worked at TARGIT. I stopped working for the company more then a year and a half ago as part of my contract I am not allowed to offer any support on it. As far as I know after I left no one took over the project and it has probably been left on the shelf somewhere to rot.

      In recent months Google has made some extensive changes to their authentication system. These changes require that developers of applications request that their applications be approved by google before the authorization will work. Older application where allowed a grace period to fix their applications to support the new security measures. I suspect that no one at TARGIT has chosen to do this. If they have not i suspect the application is going to stop working.

      I have tried to contact the company a number of times and ask them to opensource the project so that i can maintain it or to fix it themselves. I have never received a response from them since I left the company. I suggest you try and email “dennis at targit.com” see if he chooses to respond.