Big Query Connection Manager - Authentication Fails

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
marneo
Posts: 1
Joined: Wed 05 Oct 2022 08:29

Big Query Connection Manager - Authentication Fails

Post by marneo » Wed 05 Oct 2022 08:45

Hi,

WE have decided in our organization to create a separate email to be used for our ETLS. We are now trying to move our previous ETLs but we are having some authentication issues because google is flagging Devart now as an unsecure app.

What will be the way to add the app to our new email to be used for ETLs? (I tried using app passwords but the window popups are forced to use a google password which then produces an unsecure connection)


Screenshots below:
Image
Image
Image

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Big Query Connection Manager - Authentication Fails

Post by DmitryGm » Fri 07 Oct 2022 17:47

You have to unblock the application here:
https://myaccount.google.com/lesssecureapps

However, this option is not available for accounts with two-step verification.
In this case, you can create an application password, as described here:
https://support.google.com/accounts/answer/185833?hl=en

Post Reply