Skip to main content
Sign in

Connecting to an S3 Provider

  • Updated

Openprise supports two different connectors to S3. Below are guidelines on which connector to use.

  • The standard connector allows the user to specify the location in S3 by bucket name or by path specification. The standard connector supports both import and export. Setup is explained below.
  • The open connector to S3 should be used if you need to specify the location of your files using a wildcard pattern. The Open Connector only supports import of data from S3 to Openprise. Information on this feature is located HERE.
 
Follow the below procedure to setup and use S3 as a Source technology with an Openprise Data Source. Before setting up a Data Source in Openprise, it is important to configure S3 first.

 

S3 Configuration

Create an S3 Bucket

A bucket is the same as a folder or directory in Windows or MacOs.  Give it a name and select a region where you want the bucket to be located. 

1.png

  • Leave all other configuration as the defaults.

 

Create a user

To keep things isolated, it is recommended to create users specific for accessing S3 from a system. This user should be for API access only.

2.png
 

After the user is created, select the new user to create the access keys. Once in the user screen, select the security tab and click on the Create access key button to generate the secret key.

 
 
3.png
 
 
 

Setup IAM to access the new created bucket

Create a policy with the following permissions and attach it to the newly created user:

{
    “Version”: “2012-10-17",
    “Statement”: [
        {
            “Sid”: “VisualEditor0”,
            “Effect”: “Allow”,
            “Action”: [
                “s3:PutObject” ,
                “s3:GetObject” ,
                “s3: ListBucket”
            ],
            “Resource”: [
                “arn:aws:s3::: bucket-name”,
                “arn:aws:s3::: bucket-name/folder-name”
            ]
        },
        {
            “Sid”: “VisualEditor1",
            “Effect”: “Allow”,
            “Action”: “s3:PutObject”,
            “Resource”: “arn:aws:s3:::bucket-name/ folder-name/*”
        }
    ]
}
 

The above policy gives access to a specific bucket with the name: “bucket-name”. This should be changed to the bucket name you created in S3. The permissions above give access to the bucket to list and access any object within that bucket only.

 

Openprise Data Source Configuration

When selecting AWS S3-CSV files, you need to add the information about S3 in the pop-up dialog from the S3 setup above.
 
2.jpg
 
Once configured correctly, the list of folders/directories in the bucket will be listed in the “Directory or entity” list picker (red arrow above).

 

Related articles