Amazon Athena
Amazon Athena
Follow these steps to connect Amazon Athena to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Amazon Athena into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the S3 Staging Directory that Amazon Athena uses to store the results of a query.
-
Enter the Amazon Athena Data Source.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
ADFS
-
Enter the ADFS User Id.
-
Add the Password for that account.
-
Enter the SSO Login URL to the URL used by the SSO provider.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AWSRootKeys
-
Enter the AWS Access Key associated with the AWS root account.
-
Enter the AWS Secret Key associated with the AWS root account.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AWSIAMRoles
-
Enter the AWS Access Key associated with the AWS root account.
-
Enter the AWS Secret Key associated with the AWS root account.
-
Enter the AWS Role ARN for the authenticating User Id.
-
(Optional) Enter the AWS External Id only if emulating a different role.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Okta
-
In User enter the Amazon Athena username for authentication.
-
In Password enter the user password.
-
Enter the SSO Login URL.
-
Enter all relevant SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
PingFederate
-
In User enter the Amazon Athena username for authentication.
-
In Password enter the user password.
-
Enter the SSO Login URL.
-
Enter the SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Add the SSO Exchange URL.
-
(Optional) Enter the AWS Role ARN only if you have multiple Identity Providers in your AWS account.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
-
Enter the SSO Properties, with the format ‘ssoproperty1=value1;sooproperty2=value2;sooproperty3=value3;’. Make sure to separate all property-value pairs with semicolons.
-
Enter the OAuth Client Id assigned when you registered your Amazon Athena account for OAuth.
-
Enter the OAuth Client Secret for your Amazon Athena account for OAuth.
-
Select the AWS Region that hosts your AWS account.
-
Enter the Amazon Athena Database. If this is blank, the default database set is used instead.
-
Click Sign in to connect securely through OAuth. This action opens the Amazon Athena sign-in page in a new tab.
-
Log into your Amazon Athena account and provide the requested permissions (if applicable).
-
In Amazon Athena, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Amazon Athena Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and Amazon Athena, see this information page.