- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sqoop sqlserver with windows authentication
- Labels:
-
Apache Sqoop
Created ‎12-28-2015 02:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i'm trying to sqoop (Linux server) data from Sql server...i was able to do it with local account on sql server, but i want to try with Windows authentication
Created ‎12-28-2015 02:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Raja Sekhar Chintalapati You need to have an account with SQL Server Authentication to sqoop from SQL Server to Hadoop. I don't think Sqoop would work with windows authentication account in SQL Server. It definitely not used to work earlier, haven't tried in past 6 months. Please refer below.
http://hortonworks.com/hadoop-tutorial/import-microsoft-sql-server-hortonworks-sandbox-using-sqoop/
Created ‎12-28-2015 02:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Raja Sekhar Chintalapati You need to have an account with SQL Server Authentication to sqoop from SQL Server to Hadoop. I don't think Sqoop would work with windows authentication account in SQL Server. It definitely not used to work earlier, haven't tried in past 6 months. Please refer below.
http://hortonworks.com/hadoop-tutorial/import-microsoft-sql-server-hortonworks-sandbox-using-sqoop/
Created ‎12-28-2015 02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Pardeep is correct. You can only use a local SQL Server account for a Sqoop import. You may want to secure the connection by using the "password-file" hint. https://sqoop.apache.org/docs/1.4.5/SqoopUserGuide.html#_connecting_to_a_database_server
Created ‎12-28-2015 04:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks Scott..but this is sad that it doesn't support AD...
Created ‎12-28-2015 04:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks for swift response..
Created ‎11-01-2017 04:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In 2017, HDP v2.5+ you can connect sqoop to Microsoft SQL Server with AD.
