Cloudworks Seetup Issue

My ability to login to AWS and reach bucket is validated and all is good on the AWS side

Setting up the Cloudworks Connection seems to work and getting a valid connection.

When an Integration is being setup, I can connect to model and see what I would like to export from Anaplan, but the Data Target remains greyed out and the error:

Failed to load files from Amazon S3

pops up.

Our AWS administrator can see that there is nothing beyond the connection.

I am set with integration role...and have tried it by loggin in with our service account with full access that is used for all our Anaplan Connect API integrations...this role is also set as Integration role.

Any ideas on what might be preventing getting the integration part setup with Cloudworks?

Accepted answers

All comments

Misbah

@ben_speight Don't know if anybody else can help @stephen.hoffer hence looping you.

ben_speight

I don't really know this area but will ask around...

PrashanthS

@stephen.hoffer Can you check whether you have write permissions on S3? You can just try copying into S3.

jnoone

Hi Stephen, I have experienced something similar before. Try this: attempt to create the integration on the "Create new integration" screen as you did for. Check if the data source (your bucket) is available for selection. If it is greyed out (as you were seeing before) then cancel out and then try to create a new integration again following the same steps. I was noticing that it would only recognize the bucket the second time around.

stephen.hoffer

Yes...I have write permissions The AWS admin validated this.

stephen.hoffer

I just tried that too.

I am thinking that using Anaplan Connect on AWS will work better and there is a history of folks having success going that route.

It is not worth being the tip of the spear on this one. If it is not easy to use and figure out, it quickly become a blocker.

Thank you everyone for trying to help.

utsav.kanani

It looks like access issues to the files in the AWS bucket.
I would highly encourage to look at the bucket permissions section at:
https://help.anaplan.com/f764abc8-95ab-4216-a78a-1d9f47a90726-Set-your-bucket-permissions

Also has your AWS administrator setup any IAM roles or is it straight up service account for accessing AWS S3 bucket?

DibB

@stephen.hoffer

Users can setup integrations with Amazon S3 bucket that has fewer than 250,000 files (including folders and sub-folders). If your bucket exceeds this limit, then the workaround is to either setup a new bucket for the "planning" files or reduce the number of files in the original bucket.

If the above workaround does not work for you, can you please create an Anaplan Support ticket so that we can address the root cause of the issue?

JaredDolich

@stephen.hoffer

Some ideas:

Name files with .csv Example: Data.csv.csv
Export and Import file names have to be different
25 integration limit then pay as you go
No processes can be run, only actions
cannot do model to model yet
Integrations can be scheduled but once scheduled you cannot run it manually

Also, this was just released today:

https://community.anaplan.com/t5/Best-Practices/CloudWorks-This-is-How-We-Use-It-Part-1-The-Basics/ta-p/95874

stephen.hoffer

No IAM straight up access

stephen.hoffer

The files in the bucket are nowhere near the limit mentioned and there is a ticket already submitted.

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled