CloudWorks—This is How We Use It, Part 2: Setup

In Part 2 of our CloudWorks—This is How We Use It series, we're diving into how to set up CloudWorks.
 
Need a refresher on the basics of CloudWorks? See Part 1.
 
Before starting anything, you need to identify and create an Integration Administrator (Learn more here: Access Control).

Ready? Let's start!

Our use case for the purpose of this best practice is as follows: 

Screen Shot 2021-01-21 at 2.51.11 PM.png

We have source data from a file (Accounts.csv) on an Amazon S3 bucket, and we want to populate an Anaplan Module (AccountDetails) with it.
 
 
 
If you need help creating your AWS S3 bucket, follow this link: Set your AWS S3 bucket  
Now, to set up CloudWorks, follow these four steps:

Step 1. AWS S3 Authentication—Access Key ID and Secret Key

Follow these four steps:
  1. Log in to https://console.aws.amazon.com using your credentials.
  2. Go to My Security Credentials & Access keys (access key ID and secret access key).
  3. Click Create New Access Key.
     
    image.png

  4. Download and secure the key file that contains Access Key Id & Secret Access Key.   
     
Screen Shot 2021-01-15 at 12.17.30 PM.png

Step 2. Authenticate in CloudWorks

Create a connection and authenticate with AWS S3 from CloudWorks.
Screen Shot 2021-01-15 at 12.20.13 PM.png


Learn more about creating a new connection

Step 3. Run your integrations

You can do so either manually or through a scheduler. Learn more about running an integration.

Step 4. Schedule an integration

 

Guidelines

For detailed guidelines about CloudWorks, scroll at the end of this page.

 

You are now officially a CloudWorks user. Congratulations!
Feel free to test your skills with our .
 
And for more advanced topics, check out Part 3, Part 4 and Part 5!
 
Got feedback or questions on this article, let us know in the Comments thread below.
 
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
Comments

@annejulie great article 

 

I do have a question in regards to AWS Access keys. Generating user-level access keys is always prohibited as it poses a great security risk. A lot of organizations' IT teams don't allow this. Is there a way anaplan can retrieve  temporary access keys?

Anaplan or CloudWorks doesn't have the ability to retrieve temporary access keys.  Perhaps, you can use AWS API to do this.  Once you do this, you can use CloudWorks API end point "patch a connection" to update AWS S3 credentials via a script (ex: python).  CloudWorks API will help automate updating connection details.  Here's the link to CloudWorks API and end point to "patch a connection".  Hope this helps!!!

@pmarpaka that's pretty cool. Now I just have to convince IT to make it happen which is not so cool. 

 

Thanks for the insights 

Take a look at Part 3 of this series for sample code on CloudWorks API.  It might help you make your case to your IT team.

@pmarpaka I meant the AWS temp key API call to update the access key on routine. That part will take some convincing to do. patch a connection part is the easy bit . cheers