Configure SQL PolyBase to access external data in MongoDB

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

Im trying to connect SQL server using Polybase with MongoDB but Im failing to create the external data source for that. Please help ...

Im using the following code:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword';  



CREATE DATABASE SCOPED CREDENTIAL MongoDbUser

WITH IDENTITY = 'myusername', Secret = 'thepassword';





CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH (

TYPE = HADOOP,

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

Im expecting the create the datasource with name "external_DS_MongoDB" but Im facing the following error in SQL:

Msg 105007, Level 16, State 1, Line 26
Scheme of the input URI is not supported. Please revise the following scheme and try again: 'mongodb'

Can anybody advice me ?

Thanks.

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

What version of SQL Server are you running?

– GregGalloway
Jan 4 at 1:51

Hello, Im using this version : Microsoft SQL Server 2019 (CTP2.2) - 15.0.1200.24 (X64)

– Amir
Jan 4 at 15:14

add a comment |

Im trying to connect SQL server using Polybase with MongoDB but Im failing to create the external data source for that. Please help ...

Im using the following code:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword';  



CREATE DATABASE SCOPED CREDENTIAL MongoDbUser

WITH IDENTITY = 'myusername', Secret = 'thepassword';





CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH (

TYPE = HADOOP,

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

Im expecting the create the datasource with name "external_DS_MongoDB" but Im facing the following error in SQL:

Msg 105007, Level 16, State 1, Line 26
Scheme of the input URI is not supported. Please revise the following scheme and try again: 'mongodb'

Can anybody advice me ?

Thanks.

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

What version of SQL Server are you running?

– GregGalloway
Jan 4 at 1:51

Hello, Im using this version : Microsoft SQL Server 2019 (CTP2.2) - 15.0.1200.24 (X64)

– Amir
Jan 4 at 15:14

add a comment |

Im trying to connect SQL server using Polybase with MongoDB but Im failing to create the external data source for that. Please help ...

Im using the following code:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword';  



CREATE DATABASE SCOPED CREDENTIAL MongoDbUser

WITH IDENTITY = 'myusername', Secret = 'thepassword';





CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH (

TYPE = HADOOP,

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

Im expecting the create the datasource with name "external_DS_MongoDB" but Im facing the following error in SQL:

Msg 105007, Level 16, State 1, Line 26
Scheme of the input URI is not supported. Please revise the following scheme and try again: 'mongodb'

Can anybody advice me ?

Thanks.

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

Im trying to connect SQL server using Polybase with MongoDB but Im failing to create the external data source for that. Please help ...

Im using the following code:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword';  



CREATE DATABASE SCOPED CREDENTIAL MongoDbUser

WITH IDENTITY = 'myusername', Secret = 'thepassword';





CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH (

TYPE = HADOOP,

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

Im expecting the create the datasource with name "external_DS_MongoDB" but Im facing the following error in SQL:

Msg 105007, Level 16, State 1, Line 26
Scheme of the input URI is not supported. Please revise the following scheme and try again: 'mongodb'

Can anybody advice me ?

Thanks.

sql mongodb polybase sql-server-2019

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

edited Jan 4 at 16:02

GregGalloway

6,4113829

edited Jan 4 at 16:02

GregGalloway

6,4113829

edited Jan 4 at 16:02

GregGalloway

6,4113829

asked Jan 3 at 15:30

Amir

asked Jan 3 at 15:30

Amir

asked Jan 3 at 15:30

Amir

What version of SQL Server are you running?

– GregGalloway
Jan 4 at 1:51

Hello, Im using this version : Microsoft SQL Server 2019 (CTP2.2) - 15.0.1200.24 (X64)

– Amir
Jan 4 at 15:14

add a comment |

What version of SQL Server are you running?

– GregGalloway
Jan 4 at 1:51

Hello, Im using this version : Microsoft SQL Server 2019 (CTP2.2) - 15.0.1200.24 (X64)

– Amir
Jan 4 at 15:14

What version of SQL Server are you running?

– GregGalloway
Jan 4 at 1:51

Hello, Im using this version : Microsoft SQL Server 2019 (CTP2.2) - 15.0.1200.24 (X64)

– Amir
Jan 4 at 15:14

add a comment |

1 Answer
1

active

oldest

votes

TYPE is not needed when creating a MongoDB data source:

CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH 

(

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

answered Jan 8 at 18:50

ChrisK

111

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54025279%2fconfigure-sql-polybase-to-access-external-data-in-mongodb-problem%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

TYPE is not needed when creating a MongoDB data source:

CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH 

(

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

answered Jan 8 at 18:50

ChrisK

111

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

add a comment |

TYPE is not needed when creating a MongoDB data source:

CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH 

(

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

answered Jan 8 at 18:50

ChrisK

111

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

add a comment |

TYPE is not needed when creating a MongoDB data source:

CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH 

(

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

answered Jan 8 at 18:50

ChrisK

111

TYPE is not needed when creating a MongoDB data source:

CREATE EXTERNAL DATA SOURCE external_DS_MongoDB

WITH 

(

LOCATION = 'mongodb://localhost:27017', 

CREDENTIAL = MongoDbUser

);

answered Jan 8 at 18:50

ChrisK

111

answered Jan 8 at 18:50

ChrisK

111

answered Jan 8 at 18:50

ChrisK

111

answered Jan 8 at 18:50

ChrisK

111

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

add a comment |

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

Thank you @ChrisK. It worked for me.

– Amir
Jan 9 at 12:38

For future users, the topic is well documented here

– Ronen Ariely
Apr 7 at 1:35

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu