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
Best Answer
-
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
0
Comments
-
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.
0 -
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
0 -
@jmejia Just wondering, when the run the export from Anaplan platform, does it shows data along with header?
~AB
0 -
@ashish.banka Indeed. When executing in the Anaplan platform, I receive the full export (headers & rows).
Jorge
0 -
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 [email protected] team.
0 -
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
0
