tomroh / bcputility

R package for fast bulk imports/exports from/to SQL Server with the bcp command line utility
https://bcputility.roh.engineering
Other
13 stars 1 forks source link

Add support for Azure AD authentication with -G switch #17

Closed snestler closed 1 year ago

snestler commented 1 year ago

Request that you add support for Azure AD authentication with the -G switch that is supported by the bcp utility from Microsoft. Thanks!

tomroh commented 1 year ago

Are you using username and password auth or integrated?

snestler commented 1 year ago

Username and password.

Please let me know if you think this is something that can be done.

Happy to assist with testing. Thanks!


From: Thomas Roh @.> Sent: Wednesday, October 26, 2022 8:07:37 PM To: tomroh/bcputility @.> Cc: Scott Nestler @.>; Author @.> Subject: Re: [tomroh/bcputility] Add support for Azure AD authentication with -G switch (Issue #17)

Are you using username and password auth or integrated?

— Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Ftomroh%2Fbcputility%2Fissues%2F17%23issuecomment-1292793030&data=05%7C01%7Cscott.nestler%40sumersports.com%7Cd8cce5fd10b64da1dd6408dab7af420d%7Cf748cc0ef9ac42d4bcd259317235ab77%7C0%7C0%7C638024260612707866%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DhP3QQYIItSCSPDlUvYZOUTSeIF5M18AF3zAI25Ld8Y%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FABTQW3RTENTUVVS2J5CDUT3WFHBUTANCNFSM6AAAAAARPNQ32M&data=05%7C01%7Cscott.nestler%40sumersports.com%7Cd8cce5fd10b64da1dd6408dab7af420d%7Cf748cc0ef9ac42d4bcd259317235ab77%7C0%7C0%7C638024260612707866%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=c6D9wDUhOkclP2LU%2Brpi1iHXUz4ICNH72Nt9RypYP%2Fc%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>

Any and all emails sent to us may be monitored and/or stored by us to ensure compliance with relevant legislation, rules and policies. If we collect and use your personal data you provide us or which we otherwise collect in the course of our business, we will use it in accordance with our privacy policy. This email, its contents, and any attachments transmitted with it are intended only for the addressee(s) and may be confidential and legally privileged. If you are not an addressee or authorized to act on their behalf, do not read, print, re-transmit, or store this email, any information contained in it, or any attachments. We do not waive any confidentiality by mis delivery. If you have received this email in error, please notify the sender immediately and then permanently delete this email from your system. Any liability for viruses is excluded to the fullest extent permitted by law.

tomroh commented 1 year ago

12aa0b7

Now supported for username and password auth only

snestler commented 1 year ago

Is there a plan to make integrated authentication and/or MSI work too at some point? Thank you.

tomroh commented 1 year ago

All options are now exposed with bcputility R package that the user can specify. I think if it's not working with Azure there is set up outside of what an R package can do:

image