Solved

getting data from AdWords into SQL server using SSIS

Posted on 2014-07-25
4
152 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 14

Expert Comment

by:Vikas Garg
ID: 40219156
0
 
LVL 32

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now