Running an Action to Export with a Mapping from Informatica

Hi,

I'm trying to execute an Action to export data with the use of a Mapping in Informatica. I've executed many exports with mappings in the past, but for some reason with this action, I'm only receiving the headers. There are no rows of data.

The strange thing is that when I run this action directly in Anaplan I get the rows of data without issue.

Any advice is appreciated.

Jorge

Accepted answers

jmejia

Looks like the service account that Informatica was using had an expired password. Resetting the password enabled the action to export data, not just headers. Strange though because in the past when this is the case, the validation fails in Informatica and you are unable to run the action entirely. I'm not sure why Informatica behaved this way this time around.

Thank everybody.

Jorge

All comments

JaredDolich

@jmejia

Try this: There's a good chance the default export is from a prior save. Anytime you change the saved view you must manually rerun the export action and save as "All". Make sure you name the export the same as before. Then try again. With exports using the API (or with Informatica, same) there are two parts to an export. The first is to create the export action, the second is to download the data. Sometimes these two get confused as being one and the same.

If this doesn't work, make sure the email (User) you're using in Informatica has the security to see the data you're after. Could be a simple selective access issue.

jmejia

Thanks for the advice @JaredDolich but unfortunately after executing your suggestions the export still only has headers. This is the first time I've had an issue like this with a seemingly straight forward export action.

Jorge

ashish.banka

@jmejia Just wondering, when the run the export from Anaplan platform, does it shows data along with header?

~AB

jmejia

@ashish.banka Indeed. When executing in the Anaplan platform, I receive the full export (headers & rows).

Jorge

JaredDolich

@jmejia

It's possible it's an Informatica issue. One idea that I used a while ago was to delete the Informatica process and rebuild it. If that's possible without a lot of disruption you can try that too. Beyond that, I would say it's time to pull in the support@anaplan team.

jmejia

Thank everybody.

Jorge

SelmaX

Hi Jorge,

I'm trying to create a mapping that exports data from Anaplan to a file. On Anaplan side, there's an export action that I use as a source, my mapping completes successfully, but no records are copied.

Could you describe me steps for extracting data from Anaplan via IICS? I read Anaplan connector guide, but I can only see that we need first Import step, then Export step that uses ERRORDUMP from the Import step.

Thanks,

Selma

jmejia

Hi @SelmaX ,

I apologize that I'm only now seeing this question. Let me know if you still need assistance.

Quick Links

Can you help?

Unanswered questions

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
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…