JDBC / ODBC help

[Eljeffe]

Hoping someone here can help guide me. I’m trying to make a JDBC connection to AWS Athena via Okta. I can access Athena via the Okta Web App. I’m getting conflicting information on what is needed and am running into an MFA problem.

CredentialsProvider=Okta;
OktaHostName=xxxxxxxxxxxxxxx;
OktaAppId=xxxxxxxxxxxxxxx;
OktaAppName=amazon_aws;
OktaMfaType=oktaverifywithpush;

Amazon says the Okta Application Id is a segment of two 20-character strings (for example, Abc1de2fghi3J45kL678/abc1defghij2klmNo3p4).

Okta seems to say it is only a single 20-character string.

I’m not sure how to get the full 40-character string, but when I use just a single 20 character string, it says the Okta app is misconfigured when I try to connect. If I add the template ID /272, then it seems to authenticate, but the MFA never actualizes.

I am not a Okta admin, just a user.

[andrea]

Those docs seem to refer to the application’s App Embed Link, which does contain two different identifiers, the first being the expected application ID and the second being an id thats specific to the app embed link.

I can’t say I know or understand this set up and why or how it uses these app embed link components, but since this integration is Amazon specific, its probably best to follow their instructions exactly and collect these ids from the app embed link