search

PowerBi-Projects / ServiceNow

This Power BI template is used for loading Service Now records from the task table using Rest API.
MIT License
28 stars 17 forks source link

authentication #2

Open kpejman opened 3 years ago

kpejman commented 3 years ago

hi,

my company uses SSO to connect to SNOW. when the authentication windows shows up, I tried all the authentication methods but it fails regardless of how I'm trying to authenticate. is there any way to Make this work ?

aduguid commented 3 years ago

I use a service account to access Service Now using a "Basic" data source connection type.

image

kpejman commented 3 years ago

thanks for the reply. that option is not working for me since it uses SSO to access. my personal account has access and SN uses SSO to login.

Siddharth-Latthe-07 commented 3 months ago

To resolve the issue of connecting to Snowflake using SSO, especially when authentication windows fail, you can try the following steps and approaches:-

  1. Verify SSO Configuration Ensure that the SSO configuration in your Snowflake account is set up correctly. This involves making sure that your Identity Provider (IdP) is properly configured and integrated with Snowflake.
  2. Use Browser-Based SSO Sometimes, browser-based SSO can help in cases where direct SSO from the application fails. example snippet:- 
    
import snowflake.connector

Replace with your actual credentials and account information

user = 'your_user' account = 'your_account' authenticator = 'externalbrowser' # For browser-based SSO

Connect to Snowflake

ctx = snowflake.connector.connect( user=user, account=account, authenticator=authenticator )

Test the connection

cs = ctx.cursor() try: cs.execute("SELECT CURRENT_VERSION()") one_row = cs.fetchone() print(one_row[0]) finally: cs.close() ctx.close()


3. Check Network and Browser Settings and update the Snowflake Connector

Hope the above helps, do let me know, if it works or not
Thanks