-
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 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.…
-
Challenges with Continuing to Use Version 1.3 API in Power Automate Custom Connectors
I'm currently using Version 1.3 of the API in Power Automate Custom Connectors, but our Anaplan systems have been upgraded to Version 2.0. I have a few concerns and I’m hoping to get some insights from this community: Compatibility and Functionality: Are there any known issues with maintaining the older API version in…
-
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…
-
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…
-
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…
-
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
-
INV01 Inventory Ordering - Summary method not adding up well
Hello, Could anyone help me with the monthly totals of "INV01 Inventory Ordering" module? I think I have the rights setting ( see picture INV01 - Summary setting), but as you can see in picture INV01 - Summary error, it is not adding up well. Find attached the summary settings for module AD02 too, as it affects the…
-
Anyone who can help me configure the SAP HANA JDBC driver?
I have a SAP HANA JDBC driver (ngdbc.jar") in my ANAPLAN CONNECT lib but am not able to configure it. I have attached a screenshot of the SAP HANA JDBC driver window. https://developers.sap.com/tutorials/hana-clients-jdbc/jcr:content.github-proxy.1698070514.file/JDBC-Driver-Trace-Config.png
-
Cant able to open Sprint 1 course in Level 2
Hello Everyone I have finished Level 1 and got the certification and continued to Level 2 introduction class, and I have finished it . but when I opened the sprint 1 class, the cursor was not changing to the input method ( hand symbol ) to click and start the course. the course open button remains like the text Can I know…
-
Avoid creating empty export files
I have an export action triggered by Anaplan connect (export of POs) So a file is created and placed in a folder, the ERP system then read from this file and creates POs in the ERP system. This action runnes quite often and often the exported file is empty (only headers) so there is actually nothing to export. I would then…
-
Automatic Export of 60 pages
Hello guys! Can anyone solve this? I have a module with 60 pages, and I need to export each one of those pages into a different excel file. Does anybody know a way of automate this process? I mean, facilitate the manual process of selecting pages 60 times and export each one of them individually? Is there a way to iterate…
-
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
-
Which Tool Is Easy To Handle Complex Data?
Any advice for the below query will be highly appreciated. Would it be easy for someone to learn Anaplan if they have a Salesforce marketing cloud certification with the given skills set? If not, in how much time he can learn the basics of Anaplan? Recently, one of my friends was assigned a task to work on complex data,…
-
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
-
Delete models using Anaplan Connect/API?
Is it possible to delete models using Anaplan Connect/API? A sample script would be much appreciated.
-
How to update existing records(s) and insert as new records if not exists like UPSERT
Hi, How to update existing records(s) and insert as new records if not exists like UPSERT through Anaplan Connect script for MS SQL Server? Thanks & regards, Anil
-
Can Anaplan Connect with batch scripts append data?
Hello, I'm using Anaplan Connect with batch scripts to integrate data into my Anaplan models. I'm interested in understanding whether Anaplan Connect supports the ability to append data to existing records in the models. Could you please provide information or guidance on achieving data appending using batch scripts in…
-
Anaplan Import Action - Import connector: Error obtaining input stream (caused by: File not found)
In snaplogic, We are using Anaplan-connect SDK 1.4.4.8 version to connect to Anaplan. As part of one of our customer usecase, we have created a process with 8 Anaplan import actions in it. Using Snaplan Anaplan snaps, created a pipeline which executes 8 anaplan uploads simultaneously and once all uploads are successful, we…
-
Efficient Data Exchange: Integrating Anaplan with SFTP Servers
In the dynamic landscape of modern business, data integration plays a pivotal role in decision-making processes. Many enterprises rely on Anaplan as a comprehensive planning and performance management platform. When it comes to data exchange, integrating Anaplan with SFTP (Secure File Transfer Protocol) servers offers a…
-
OAuth 2.0 and Anaplan Connect using Device Flow
Hello, This is a newbie question. I am new to Anaplan and this community so if this question has already been answered elsewhere please feel free to direct me to the link where I can find more information. We are about to start an Anaplan project in a couple of weeks and I have started to do some research on setting up…