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.
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 ?
Yes the SSIS connection manager and Data source reader work directly in SSIS, they designed to be used for that exact purpose. They are part of the Targit Google Analytics BIA solution but can be used independently with out TARGIT.
What do you mean by Poc?
Many thanks for the reply.By POC I meant Proof Of Concept. Once again many thanks for taking time to create tutorials like this.
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.
It currently supports all the way down to .net 3.5 and sql server 2005 – 2014. What part of the task is just closing?
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 ?
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.
Is it possible to set the values in the Targit Data Reader (e.g. StartDate and EndDate) with the use of expressions?
if you put your expression in an variable you can use the variable in the TARGIT Google Analytics Data Reader.
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 .
The data only requests the data you request and inserts it into your system. The only place the data is is on your system.
Thank you very much for confirming it.
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
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.
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.
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.
Hi, I`m trying to create connection manager, but it falls on error ‘Shoq Accounts:method not found’
What the reason?
I would try and reinstall it sounds like there is an issue with it not finding the Dll.
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.
Hope It will be helpful.
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.
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
do you suppose to release version with support for SQL Server 2016?
Yes there is a version released that supports SQL Server 2016 : Data Reader For Google Analytics
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!
See if this helps