Exploring the Power of MuleSoft-Anaplan Integration

Overview:

The Anaplan Connector for Mulesoft allows you to create solutions that can extract, transform, and load (ETL) data from a source system into Anaplan. MuleSoft, Inc. provides an Eclipse-based graphical environment, Anypoint Studio, for designing and configuring integration solutions with Mulesoft’s library of more than one hundred Connectors to other applications, such as Workday, Salesforce.com, and SAP.

In this blog, we will look into MuleSoft Anaplan Integration and how to easily set it up, enhancing the digital transformation journey with improved connectivity. The Anaplan Connector for MuleSoft is an alternative to Anaplan Connect and allows you to build Anypoint flows.

Anaplan Data Integration:

Data transformation plays an important role in any Integration process, especially if you are sourcing data from multiple source systems with different data sets. Hence, it’s necessary to standardize the data before you import/upload the same into the tool.

This not only enhances the effectiveness of Anaplan as a planning platform but also empowers organizations to make informed decisions based on reliable and consistent data insights.

Anaplan Components:

Anaplan connector for Mulesoft:

Anaplan Connector for MuleSoft is an alternative to Anaplan Connect and allows you to build Anypoint flows.

Mulesoft Flows allow you to:

1. Import data into Anaplan from a database, salesforce, CSV file, or other MuleSoft connectors.

2. Export a recently updated Module or List from Anaplan into a CSV file, or import into a target, such as a database, salesforce, or other MuleSoft connectors.

3. Perform data transformations on a schedule.

4. Delete obsolete data.

5. Perform a model-to-model import.

6. Run the Anaplan processes.

Config. required to connect Anaplan connector:

To use the Mulesoft Anaplan connector in your Mule application:

1. Place the connector in the flow.
2. Store the authentication, connection, or other settings in a properties file as a Global Element and also secure the password by encrypting it with algorithms.
3. For the Connection, select Basic auth connection or Cert Auth connection as per the requirement.

Anaplan basic configuration

1. Enter the workspace ID, Model ID, and the Import Name/ID of Anaplan.

2. Enter Import chunk size of 1 -10 MB. The chunks are to be temporarily stored before being uploaded or imported.

3. Enter the Retry count and the Dump file location.

4. Enter the streaming payload to be uploaded for the file in Anaplan.

5. Map the data from the source to the corresponding fields in Anaplan before importing to Anaplan.

Anaplan config. for specific operation

Operations Involved in Mulesoft with Anaplan Connector:

Anaplan MuleSoft connectors allow you to import data from different databases, Salesforce, CSV files, etc.

Anaplan operations available in Mule 4

• Describe Anaplan file — You can get a preview of the file that you are going to upload into Anaplan. A maximum of 20 lines are shown.
• Execute import only — You can create an Integration flow to run any “Import” action in Anaplan directly.
• Execute import with files — This function allows you to upload any file from your local drive into Anaplan & simultaneously run the “Import” action directly.
• Execute import streaming — In this case, instead of uploading files from your local drive, you can extract files from different databases (SAP S4 HANA, Salesforce, Workday, etc.) & simultaneously run the “Import” action.
• Execute export with files — This function allows you to run any “Export” action in Anaplan & simultaneously export the data from Anaplan into your local drive.
• Execute export streaming — You can create an integration flow to run any “Export” action & at the same time, export the data from Anaplan into any integrated databases (SAP S4 HANA, Salesforce, Workday, etc.)
• Execute file upload with files — As we have already talked about “Execute import with files”, you must be thinking what is the difference between “Execute import with files” & “Execute file upload with files”? Both are used to upload files, however in the case of “Execute file upload with files”, files are being loaded into the Anaplan server only, which means that the data is not getting imported into any models.
• Execute file upload streaming — Similar to the above functions, files are being loaded into the Anaplan server only, the models are not impacted by this upload.
• Execute process — You can use this function whenever you want to execute any “Process” action directly in Anaplan.

Conclusion:

By leveraging the Anaplan MuleSoft Connector, businesses can streamline their integration processes, ensuring that data flows smoothly between systems while maintaining security and integrity. Whether it’s importing data from external sources, synchronizing updates in real-time, or exporting insights for further analysis.

Overall, the Anaplan MuleSoft Integration enables businesses to unlock the full potential of their data and drive business success.