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 [email protected] +1.314.517.2126
On 4/25/16, 11:16 PM, "Alexey Ponkin" <[email protected]> wrote: >Hi, >All instances are MS SQL Server. >> On Apr 25, 2016, at 11:57 PM, Deepak Vohra <[email protected]> wrote: >> >> sqoop import into HDFS. Which database is used? >> -------------------------------------------- >> On Mon, 4/25/16, Aleksey Ponkin <[email protected]> wrote: >> >> Subject: >> To: [email protected] >> 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. > >
