Solved

getting data from AdWords into SQL server using SSIS

Posted on 2014-07-25
4
215 Views
Last Modified: 2016-06-09
I looking for an API that get data from AdWords source and fetch it into SQL server database via SSIS

Any suggestion?
0
Comment
Question by:Rawan Jambi
4 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40219156
0
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40219188
Using SSIS for it is not a good approach imho. Cause it is quite complex. Using lots of different objects and it requires also a sophisticated error handling.

Afaik, there is no ready to use package out there.

The things you need to know: AdWords API.

Caveat: The API changes 3 or 4 times a year. Older version are discontinued often after 9 or even 6 months. So this requires a permantent effort to keep it running.

You should start with the ready to use .NET Client Library.
You may use it to either create a console application, a Windows Service or even a collection of .NET CLR procedures to retrieve the data.

So in short: it requires definitly some .NET development.
0
 

Author Comment

by:Rawan Jambi
ID: 40219227
thank you
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question