Use Certificate Authentication With SSIS and SQL Azure
I have tried to find any information on this and have not been very successful.
We have a DMZ Azure DB that we will be putting data into, and a partner will be pulling that data out of.
We have set up cert active directory authentication with the partner who has been able to authenticate using a cert in their jdbc connection.
We need to also connect in the same manner, but I am using SSIS to prepare the data and transfer it.
I cannot see anywhere a way to use cert authentication in OLEdb.
Have my search skills failed me or is this not actually possible?
Using SQL server 2016 and SSIS on that server, wanting to connect and put data into an Azure DB.
Can anyone help me or point me in the right direction?
sql-server 
azure ssis asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
add a comment |
I have tried to find any information on this and have not been very successful.
We have a DMZ Azure DB that we will be putting data into, and a partner will be pulling that data out of.
We have set up cert active directory authentication with the partner who has been able to authenticate using a cert in their jdbc connection.
We need to also connect in the same manner, but I am using SSIS to prepare the data and transfer it.
I cannot see anywhere a way to use cert authentication in OLEdb.
Have my search skills failed me or is this not actually possible?
Using SQL server 2016 and SSIS on that server, wanting to connect and put data into an Azure DB.
Can anyone help me or point me in the right direction?
sql-server azure ssis asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
add a comment |
I have tried to find any information on this and have not been very successful.
We have a DMZ Azure DB that we will be putting data into, and a partner will be pulling that data out of.
We have set up cert active directory authentication with the partner who has been able to authenticate using a cert in their jdbc connection.
We need to also connect in the same manner, but I am using SSIS to prepare the data and transfer it.
I cannot see anywhere a way to use cert authentication in OLEdb.
Have my search skills failed me or is this not actually possible?
Using SQL server 2016 and SSIS on that server, wanting to connect and put data into an Azure DB.
Can anyone help me or point me in the right direction?
sql-server azure ssis asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
I have tried to find any information on this and have not been very successful.
We have a DMZ Azure DB that we will be putting data into, and a partner will be pulling that data out of.
We have set up cert active directory authentication with the partner who has been able to authenticate using a cert in their jdbc connection.
We need to also connect in the same manner, but I am using SSIS to prepare the data and transfer it.
I cannot see anywhere a way to use cert authentication in OLEdb.
Have my search skills failed me or is this not actually possible?
Using SQL server 2016 and SSIS on that server, wanting to connect and put data into an Azure DB.
Can anyone help me or point me in the right direction?
sql-server azure ssis sql-server azure ssis asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
edited Nov 19 '18 at 16:18
Pushpendra Rishi
asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
asked Nov 19 '18 at 15:33
Pushpendra RishiPushpendra Rishi
33
33
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53377916%2fuse-certificate-authentication-with-ssis-and-sql-azure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53377916%2fuse-certificate-authentication-with-ssis-and-sql-azure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
