Creating the Data Source NameCData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362
This section describes how to edit the DSN configuration and then authenticate and connect to AWSDataManagement APIs.
Editing the DSN Configuration
You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process, as described in Installing the Connector.
Complete the following steps to edit the DSN configuration:
- Select Start > Search, and enter ODBC Data Sources in the Search box.
- Choose the version of the ODBC Administrator that corresponds to the bitness of your Power BI Desktop installation (32-bit or 64-bit).
- Click the System DSN tab.
- Select the system data source and click Configure.
- Edit the information on the Connection tab and click OK.
Authenticating to AWSDataManagement
To authorize AWSDataManagement requests, provide the credentials for an administrator account or for an IAM user with custom permissions: Set AccessKey to the access key Id. Set SecretKey to the secret access key. Set Region to the region where your AWSDataManagement data is hosted.
Note: Though you can connect as the AWS account administrator, it is recommended to use IAM user credentials to access AWS services.
Obtaining the Access Key
To obtain the credentials for an IAM user, follow the steps below:
- Sign into the IAM console.
- In the navigation pane, select Users.
- To create or manage the access keys for a user, select the user and then select the Security Credentials tab.
- Sign into the AWS Management console with the credentials for your root account.
- Select your account name or number and select My Security Credentials in the menu that is displayed.
- Click Continue to Security Credentials and expand the Access Keys section to manage or create root account access keys.
Connecting to AWSDataManagement
The AccessKey, SecretKey, and Region properties are required to connect to AWSDataManagement. Optionally, you can set Domain if you want to use a domain name you have associated with AWS.
See Getting Data for the next step, which is connecting to the data that you want to work with.