Anaplan Integration with Amazon S3 using Informatica Cloud
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
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.
Jared Dolich - Retail, Wholesale, eCommerce Analyst