CData Excel Add-In for Amazon Athena 2019J - Online Help

SSO Properties

CData Excel Add-In for Amazon Athena 2019J - Build 19.0.7354

Additional properties required to connect to the identity provider in a semicolon-separated list.

データ型

string

デフォルト値

""

解説

Additional properties required to connect to the identity provider in a semicolon-separated list. SSOProperties is used in conjunction with the the RoleARN and PrincipalArn. The following section provides an example using the OKTA identity provider.

OKTA

The following SSOProperties are needed to authenticate to OKTA:

  • IdProvider: Set this to OKTA.
  • IdPSystemUserName: Set this to an IdP user if authentication is to be used for the IdP endpoint.
  • IdPSystemPassword: Set this to the password of the IdP if authentication is to be used for the IdP endpoint.
  • OktaDomain: Set this to the specific domain you are using in OKTA.
  • OktaAppEmbedLink: Set this to the specific EMBED LINK of your Amazon Web Services OKTA app in the GENERAL tab.
  • OktaApiToken: Set this to one of the API tokens in your OKTA account.
Below is an example connection string:
Region=Ireland; Database=sampledb; AccessKey=' '; SecretKey=' '; SSOProperties='IdProvider=OKTA; IDPSystemUsername=user@cdata.com; IdPSystemPassword=CH8WerW121235647iCa6; OktaDomain=cdata-us.okta.com; OktaAppEmbedLink=https://cdata-us.okta.com/home/amazon_aws/0oa35m8arsAL5f5NrE6NdA356/272; OktaApiToken=01230GGG2ceAnm_tPAf4MhiMELXZ0L0N1pAYrO1VR-hGQSf'; RoleArn=arn:aws:iam::1234:role/Okta_SSO; PrincipalArn=arn:aws:iam::1234:saml-provider/OktaProvider; S3StagingDirectory=s3://athena/staging;

ADFS

The following SSOProperties are needed to authenticate to ADFS:

  • IdProvider: Set this to ADFS.
  • IdPSystemUserName: Set this to an IdP user if authentication is to be used for the IdP endpoint.
  • IdPSystemPassword: Set this to the password of the IdP if authentication is to be used for the IdP endpoint.
  • IdpUrl: Set this to the ADFS url.
Below is an example connection string:
Region=Ireland; Database=sampledb; AccessKey=' '; SecretKey=' '; SSOProperties='IdProvider=ADFS; IDPSystemUsername=user@cdata.com; IdPSystemPassword=CH8WerW121235647iCa6; IdpUrl=https://adfs.domain.com'; RoleArn=arn:aws:iam::1234:role/ADFS_SSO; PrincipalArn=arn:aws:iam::1234:saml-provider/ADFSProvider; S3StagingDirectory=s3://athena/staging;

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0