sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Shaw <ss...@hortonworks.com>
Subject Re:
Date Tue, 26 Apr 2016 12:32:33 GMT
You’re best approach is to schedule a SQL Server job and export the tables as csv files to
a landing zone. You can then load these into HDFS.
 
Scott Shaw
Sr. Solutions Engineer
sshaw@hortonworks.com
+1.314.517.2126








On 4/25/16, 11:16 PM, "Alexey Ponkin" <alexey.ponkin@gmail.com> wrote:

>Hi,
>All instances are MS SQL Server.
>> On Apr 25, 2016, at 11:57 PM, Deepak Vohra <dvohra09@yahoo.com> wrote:
>> 
>> sqoop import into HDFS. Which database is used?
>> --------------------------------------------
>> On Mon, 4/25/16, Aleksey Ponkin <alexey.ponkin@gmail.com> wrote:
>> 
>> Subject: 
>> To: user@sqoop.apache.org
>> Date: Monday, April 25, 2016, 11:59 AM
>> 
>> HI,
>> 
>> I have the following use case:
>> 
>> We have several SQL databases in different locations. And we
>> need to load them in HDFS.
>> The problem is that due to security concerns we do not have
>> direct access from Hadoop cluster to those databases.
>> But we can push data from our SQL servers to Hadoop.
>> Is it possible to do something like push load using sqoop?
>> 
>> Thanks in advance.
>
>
Mime
View raw message