Anaplan Integration with Amazon S3 using Informatica Cloud

arti.kalekar1 · January 2020

Hello Team,

We are currently trying to Integrate Anaplan with S3, Here Anaplan is the Source and we need to place files into the S3 Bucket. The metadata tables have been created in the relevant S3 bucket.

The requirement is to have the CSV files containing the data from Anaplan and a Manifest file to be placed into the S3 bucket. Could you please provide any documentation on the above requirement. Integration tool

Regards

Arti

Misbah · January 2020

@arti.kalekar1

Not sure if there is any documentation available for it, I will let other champs chime in here. However here is a small video on Hyperconnect here

https://community.anaplan.com/t5/On-Demand-Courses/HyperConnect/ta-p/54528

Hope this helps

Misbah

JaredDolich · January 2020

@arti.kalekar1

In addition to the video @Misbah suggests you can also read up on data integration.

You can start at this link here.

Note that Informatica also uses a classic connector in addition to the HyperConnect. Some find the classic easier to work with.

Also, it is HIGHLY recommended that you use a certificate for authentication. Using basic authentication has a lot of challenges associated with it, not least of which is that you have to update the password on a regular basis (depends on your clients network policies).

The one thing to remember is that no matter what method you use, all integrations behave the same way when setting up the export in Anaplan.

The most common approach I use is:

- delete file

- run export

- download file (CSV, in your case)

Depending on how you save your file (in the export process) will determine if you need to delete the file. If you save the file as private it will only last 48 hours before being removed.

The actual process within Informatica you can read up about it as @Misbah provided.

Also, S3 has good data integration documentation.