Issue in mapping creation in dell Boomi tool using Anaplan action

Hello Team

Can anyone help me to understand the Dell Boomi integration with Anaplan.

I am trying to integrate Oracle Databse to Anaplan using Dell Boomi.

When i try to create Mappings in Dell boomi from Database to anaplan by using MAP .

I am able to retrive columns from Databse but when i try to select anaplan action in target sesction of mapping it doesnt retrive Columns present in Anaplan action like informatica cloud does.

I have attached the mapping snapshot for reference.

Please help me to understand and solve this.I have to select JSON file format in mapping to select Anaplan action.

11032019_42323.PNG

Accepted answers

jesse_wilson

Hi @Ankitjain

You can create a generic mapping profile, based on the CSV file in Anaplan. By selecting the import action, Boomi is trying to map the source data to the JSON response from an Import action, not the file associated with it. From the mapping object, you can create a new target profile; first, select flat file from the dropdown, then create a new profile. Please see the attached for reference.

Thanks,
Jesse

Screen_Shot_2019-03-12_at_10_42399.png

jesse_wilson

In order to push data to Anaplan you must first get the data into your model via the upload operation. This sends the data in a file format to your model, which can then be imported into your module(s) with imports or processes. If you have a single file that acts as a source to multiple objects, it would be best to upload the file then use a process. This will help to reduce your maintenance costs associated with your integrations.

All comments

jesse_wilson

Hi @Ankitjain

Thanks,
Jesse

Screen_Shot_2019-03-12_at_10_42399.png

Ankitjain

Hello Jesse,

Thank you so much for the solution.I am able to load data now.

Currently i have created a mapping with database to flat file and mapping is connected to Anaplan upload operation then Anaplan upload is connected to Anaplan import operation.

Do i have any other option to load data in anaplan to database by skipping anaplan upload operation and direct import in Anaplan? Please correct me if am following a bad practice for integration.

I have attached snapshot of mapping for your reference.

dellbomi_mapping_42469.PNG

Ankitjain

@jesse_wilson Can you please update me on this ? I am struggling to push data in anaplan without using upload operation in anaplan import action.

jesse_wilson

Quick Links

Can you help?

Unanswered questions

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…