Highlighted
Occasional Contributor

Anaplan Integration with Amazon S3 using Informatica Cloud

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

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Integration with Amazon S3 using Informatica Cloud

@arti.kalekar 

 

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

Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Integration with Amazon S3 using Informatica Cloud

@arti.kalekar 

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. 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Integration with Amazon S3 using Informatica Cloud

@arti.kalekar 

I also found this really awesome article on imports / exports.

Anything related to APIs will be relevant to you as you use Informatica Cloud.

If you haven't already seen this then I would I highly recommend it.

 

 

 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Integration with Amazon S3 using Informatica Cloud

Hi 

 

I am assuming your informatica to S3 connection is sorted and you need to extract data from anaplan . 

 

If above is true you need below guide to configure informatica cloud and extract data from anaplan 

 

1-->

https://docs.informatica.com/content/dam/source/GUID-0/GUID-022E3249-46F2-4819-B29A-9B5F0B93A3FB/4/e...

 

2-->

https://s3.amazonaws.com/anaplanenablement/Community/Anapedia/AnaplanConnectorGuide.pdf?

 

Hope this helps