Solved

getting data from AdWords into SQL server using SSIS

Posted on 2014-07-25
4
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40219156
0
 
LVL 34

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server 2012 r2 and SQL 2014 6 34
Question about Common Table Expressions 3 43
Moving away from Access 2003 adp files 4 47
SQL - Subquery in WHERE section 4 33
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

732 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