Share via

Can we have hive connectivity in SQL SERVER MDS

Anjali Shevadkar 1 Reputation point
2020-10-20T06:51:21.247+00:00

need hive connectivity in sql server mds.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,689 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-10-20T07:36:25.153+00:00

    Hi @Anjali Shevadkar ,

    ...need hive connectivity in sql server mds.

    Yes. You can. It is similar as connecting with traditional dbs.
    There are two methods.1: linked server 2. Use tools.

    Similar cases: Load-data-from-SQL-table-into-Hive-table

    More information: quick-tip-for-extracting-sql-server-data-to-hive, importing-data-from-traditional-databases-into-hdfshive-in-just-a-few-clicks

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. m 4,271 Reputation points
    2020-10-22T01:12:58.073+00:00

    Hi @Anjali Shevadkar ,

    Is the reply helpful?

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.