Creating an Amazon S3 data source

With an Amazon S3 data source, you can access data files on your Amazon S3 storage as tables.

About this task

You can connect to Amazon S3 by using either a basic connection or a Security Assertion Markup Language (SAML) connection.

To create an Amazon S3 data source, complete the following steps:

Procedure

  1. Select File > New > Other > Repository > Amazon S3 Data Source.
    The Create Amazon S3 Data Source wizard opens.
  2. Type the data source name in the Data Source Name field.
  3. Depending on the type of connection that you want, enter the necessary information.
    • To make a SAML connection, complete the following steps:
      1. Select the Use SAML Authentication checkbox.
      2. From the Region list, select the region that you have access to, and then click Test Connection.
        The SAML Authentication Properties dialog opens.
      3. Enter the required information in the SAML Authentication Properties dialog and click OK.
        The SAML Authentication Properties dialog closes and the Bucket list is populated with the bucket names for the region that you selected. To reload the bucket names, click the Refresh button.
    • To make a basic connection, complete the following steps:
      1. Specify the Access Key ID and the Secret Access Key for your account.
      2. From the Region list, select the region that you have access to, and then click Test Connection.

        The Bucket list is populated with the bucket names for the region that you selected. To reload the bucket names, click the Refresh button.

  4. From the Bucket list, select the bucket to which you have access.
    All the files from the bucket will be included in the newly created data source.
  5. To include the files that are inside the sub folders, select the Include subfolders checkbox.
  6. Optional: In the Comment field, enter the description for the data source.
  7. Click Finish.
    A new Amazon S3 data source data source gets created and the Create New Amazon S3 Data Source wizard closes.

Results

The Amazon S3 data source is added in the Repository Explorer under the Amazon S3 Data Source node, with a sub-node each for Basic and SAML connections. All the files from the selected bucket that QMF supports are displayed under each sub-node.