Anaplan Connect

Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…
Automatic email notifications
I have an action on my UX dashboard which runs a process for submitting order for approval. I want to trigger an email as soon as that process is triggered. Is there anyone who has worked on a similar use case?
Access to the Anaplan workspace
Hi Team, This is Rohan Suvarna . I have learned and certified Anaplan Level-1, Level-2 and Anaplan way. I am requesting here, Could you please give me a 90-days free trial workspace for me. I want to practice it again to get ready to attend the interview. And one more thing, I have to do sample projects in Anaplan.
How to Avoid an old "Default File" from importing into Anaplan via Anaplan Connect if no file loads?
Here is our setup: We have an Anaplan import that runs via Anaplan Connect. The file drops into the folder location daily on the server. Then Anaplan Connect picks up that file & loads it into Anaplan. Here is our problem: If no file drops into the folder location on the server, then Anaplan Connect will default to an…
Anaplan API: Could not initialise service credentials (Anaplan API: Invalid certificate-alias provid
Hi, I am testing an Anaplan Connect upgrade and am struggling to get our scripts to run. We had recently had our certificate renewed and I have refreshed the KeyStoreAlias in line with live scripts. I am getting the following error message now: "Anaplan API: Could not initialise service credentials (Anaplan API: Invalid…
Anaplan & Fluence Connection
Does anyone know how the connection between anaplan and fluence works… or can point me in the right direction for documentation?
Trying to get .xlsx from Anaplan Connect but comes out as csv
I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly. So it seems…
Access to the Anaplan workspace
I want to complete Anaplan level 3 for that i require Anaplan workspace access so i want to Connect with model builders for opportunities for model builder junior roles. Please help me.
Automatic Model Copy&Archive Functionality
Hi everyone, is it possible to automate the functionality of "Copy & Archive" of a Model? And eventually schedule this automation? Thank you in advance! Joana
Is it possible to run external Python script from UX page?
Hi, The question is about the following situation: A user makes a change to the grid and I want to perform calculations for another line item. I have the calculation formula written in a Python script and I would like the end user to be able to run it from their UX.
Introducing the Anaplan Integration Script Generator: Simplifying Anaplan Connect Scripting
Introduction Anaplan, a leading platform for enterprise planning, has revolutionized the way organizations manage their data and streamline processes. However, leveraging Anaplan's powerful features often requires scripting with Anaplan Connect—a command-line utility for interacting with the platform. To simplify this…
What are the limitation of Cloudworks Integration?
Hello Community, I am new to the Anaplan cloud works. I just want to know what are the important points we should keep in mind, while creating cloud works integration. some where it is mentioned that per tenant the limit of integration is only 500. What does that mean? after 500 do I need to purchase any subscription for…
Issue with Cloudworks Scheduled Process Not Updating Target Modules
Hi Team, I am facing an issue with Cloudworks. When I run a process manually, it updates the data in the target modules. However, when I schedule the same process in Cloudworks, it runs successfully but the data is not copied to the target modules. There are no Selective Access or DCA applied. Is anyone else facing the…
Anaplan Connect SQL - Cannot Connect to Database
We receive the below error when trying to connect to the SQL database. Anaplan API: Could not connect to database! (SQL server: Login failed for user) However, our test odbc connection on the server connects successfully, so the credentials are valid. What do we need to do to resolve this and connect successfully? Below is…
Boolean oriented Show/Hide & Variance
Given a module which has Time(quarter) dimension, Total $ (line item), Scenarios(list, dynamically user created). On a dashboard view, how can we let user choose which Scenario they want to see based on boolean and create variances of selected scenario?
Integration - Constraints on Data Volumes/Frequencies
Are there materials regarding constraints around data volumes and load frequencies for the various Anaplan Integration options? Any user feedback or limitations that you have seen? Thank you
Inquiry Regarding Anaplan Integration Process and Schedule
I have created an 3 Integration Process and added it to the Integration Flow and Schedule using my ID. I have a couple of questions regarding this setup: If the update schedule is modified using a different ID, will the process continue to run under my name, or will it reflect the name associated with the new ID? In the…
Anaplan Connect JDBC issues - SnowFlake - jdk.internal.misc.Unsafe
I have successfully connect to snowflake, and extract file, import to anaplan file csv, but it seems the connect api did not call the action to import into anaplan. (Because I have seen the file of anaplan has been updated, but the process/action has not been launched) It seems the problem coming from…
Anaplan Connect JDBC issues - SnowFlake - (solved)
I have encountered some issues when configuring and running connect script. But I didn't get a specific error message, as following picture : PS: I have configured the snowflake properties files and java, anaplan connect installed etc. Can anyone give me some tips to figure it out ? Thanks
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
Anaplan Connect: Export to SQL Server
Hi, I am setting up export connections from Anaplan to SQL Server. We do this using Anaplan Connect. We have already set up around 100 export connections, but we are still facing difficulties with one specific export. In the screenshots below you can find the error log we’re facing. We use a simple query to insert the…
Unable to onboard whole data into Anaplan
Unable to onboard whole data into Anaplan Source data: Translate business process into Anaplan components Expected Result: Translate business process into Anaplan components Onboarded data into Anaplan: Translate business process Please guide me!!
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
CA Certificate Quick Start Guide using Sectigo
Creating an Anaplan CA Certificate using the Sectigo Personal Email Security (S/MIME) certificate involves several steps. Here's a quick start guide to help you through the process: Step #1: Purchase the Sectigo Personal Email Security (S/MIME) certificate from Sectigo's website. You can find it here. The cost is $15 for a…
OEG Best Practice: Using Anaplan Connect with OAuth
How to Use Anaplan Connect with OAuth Authorization Anaplan Connect is a powerful command line interface that allows you to automate your Anaplan environment, enabling seamless data integration and synchronization between Anaplan and other systems. While Anaplan Connect offers various authentication methods, including…
Anaplan Connect: Difficulties setting up export from Anaplan to SQL Server
Hi, We're trying to set up a connection to export data from Anaplan to Microsoft SQL Server. We already have a working connection to import data into Anaplan, but we can't manage to set this up the other way around (export). We set up the export connection using the Anaplan Connect guide and our working import actions. We…
When is module DAT02 SKU Volumes Module created for import in LEVEL2 Model Building: Conclusion
Hello, I'm on Level 2 Model Building: Conclusion, and it says that I have to import the Demand data into the DATA02 SKU Volumes module, However I do not have that module in my Level 1 Model , Did I miss a step? When is this module created? Thanks in advanced, Marta

Anaplan Connect

Discussion List