Best Of
UX Enhancement: Red Font Toggle for Negative Numbers
In most cases, especially when adhering to accounting principles, it's preferred to display negative numbers in red font, similar to how Excel handles them. Currently, achieving this in Anaplan requires setting up conditional formatting for each line item, which can be time-consuming and inefficient.
To streamline this process, it would be extremely helpful to introduce a toggle in the UX page formatting section that automatically changes the font color to red for negative values. This enhancement would offer two key benefits:
- Free up conditional formatting logic for other use cases (e.g., borders, Morse indicators, background colors), while still ensuring negative numbers are visually distinct.
- Significantly reduce UX design time, making page building faster and more intuitive.
Even better, this toggle could also be available at the card level, similar to how default column widths are set for grid cards with the option to override specific columns. This would make UX design even more seamless and save substantial time for page builders.
Top 25 Anaplan features released in 2025
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Moderator, Leader India User Group, and Founder at Miz Logix.
Anaplan has consistently released several features monthly to stay ahead of the competition and enjoy being a leader in the Connected Planning world. 2025 was no different and there were so many additions to each area of the platform which includes modeling, UX, extensibility, intelligence and Workflow. Although there may be some of you who have followed these releases, many may have missed these updates and releases. In this article, I’ll share more about top 25 features that Anaplan released during the year 2025. Also, the Community recently hosted a November Challenge, and asked people to chime in with their favorite features from 2025. We have seen tremendous response from our Community members who actively participated and shared their favorites. I’ve noted the most popular fan favorites in my list below with quotes from the Community.
Note that this is the third year and article that I have had the privilege of writing it up and I must say that this year has been one of the toughest years to pick up top 25 features due to the sheer volume of the new features released. Anyway, these top 25 features are divided into their respective areas of their capabilities so that it is easy to understand. Let’s jump into it!
Modeling
1. Breakback functionality in Polaris
Breakback functionality is now available in Polaris models, taking advantage of Polaris's native handling of sparsity. This includes limiting the number of cells affected by a breakback to prevent failures.
2. New functions in Polaris
IRR (Internal Rate of Return) and NPV (Net Present Value) functions are available in Polaris, further increasing the breadth of domain-specific calculation capabilities available to users. ITEMLEVEL and HIERARCHYLEVEL, two new functions exclusive to the Polaris engine, have also been introduced, which will allow modelers to determine the level within a hierarchy of an item or list members. Modelers can easily use this information within their formulas, avoiding the need for more complex modeling constructs.
3. UX Page dependency data
In the modules view beta experience, model builders can now see which UX pages are linked to each module, improving visibility into dependencies and reducing the risk of unintended changes.
Thoughts from the Community:
- @Tiffany.Rice: There have been so many great features this year!! A recent one that really helps those of us in the model builder persona is the "Used in pages" within Modules Beta.
- @Humay: As a Model Builder, I found the “Used in Pages” column in the Anaplan Beta Modules extremely valuable and a major improvement in model management.
- @SIVAPRASADPERAM: The Modules View Beta now enables model builders to identify which UX pages are linked to each module. This added visibility helps manage dependencies effectively and minimizes the risk of unintended changes.
4. Page List enhancements
The Pages Inventory has been enhanced to provide a more seamless and unified experience, aligning closely with the functionality of the New Modules Inventory. This includes a compact toolbar, page deletion, editable table columns, enhanced column sorting and arrangement, modules attribute column, and persistent right-hand panel tabs.
5. Calc Effort % in Classic
Calculation Effort is now available in Classic, either in Blueprint view or the Line Items section of the Module Panel. The column displays the percentage of computational effort required for each line item. Opening a model initiates the calculation of all its line items, which means opening time varies based on model complexity and data volume. Once the model is opened, the Calculation Effort column will show which line items in the model require the most computation and may require optimization. For more, check out this community article here.
Thoughts from the Community:
- @matthewreed: There have been some great enhancements this year, but the biggest game-changer for me was the visibility of calculation effort, which was added to the classic engine in March.
- @Bhumit285: From a Model Builder’s perspective, the most impactful improvement has been the Calculation Effort insight in Classic engine, which has significantly helped in model optimization.
- @SunnyNafraz: For model optimization, the platform introduced Calculation Effort Visibility in March 2025, which is like a built-in "speedometer" for formulas in classic models, helping builders see exactly which calculations are using the most processing power so they can be optimized for faster performance.
- @namdevgurme: See which line items are heavy on calculations. Great for optimizing performance and speeding up model.
- @jjayavalli: The March 2025 release introduced the Calculation Effort % metric for Classic-engine modules. This new column exposes how computationally “expensive” each line item is relative to the overall model.
- @Anjaneyulu Putta: Offers transparency into model performance and calculation complexity, helping optimize efficiency and reduce processing time.
- @Poojalakshmi, @shaik970, @devrathahuja, @Babu12, @PujithaB, @ShivankurSharma, and @parmod.kumar2 all also shared this feature as one of their favorites!
6. Clickable dependency links in the New Modules Inventory
In the New Modules Inventory, columns containing dependency data are now clickable, offering model builders quick, seamless access to linked objects for a more efficient modeling experience. Model builders can access the New Modules Inventory via a toggle on the current modules inventory page.
User Experience (UX)
7. Combined Grids
This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX page. This functionality reduces manual effort and empowers faster decision-making by presenting related information side-by-side. For more information, check out this Community article: Combined Grids is now live!
Thoughts from the Community:
- Bhumit285: From a UX standpoint, the most awaited and valuable feature, in my opinion, is the Combined Grids capability.
- SunnyNafraz: To improve reporting, the Combined Grids (Multi-Module Reporting) feature, released in October 2025, significantly simplified dashboard views by allowing users to pull data from several different planning tables (modules) and display them together in a single, unified report with a shared row axis, making side-by-side comparisons much cleaner.
- namdevgurme: Now we can show data from multiple modules in one grid on a UX page. Super helpful for comparing and analyzing related info side-by-side.
- @pyrypeura: My favorite new features of 2025 are clearly used in pages and combined grids.
- Anjaneyula Putta: Improves user experience by consolidating multiple views into a single grid, making analysis and reporting more streamlined.
- Poojalakshmi, @lokesh1156, @Pradyumna, @KumariSuman, @shaik970, @Praveen8919639033, @MeghanaDhanokar, @PriyaKumari, Babu12, PujithaB, ShivankurSharma, and parmond.kumar2 all also shared this feature as one of their favorites.
8. Multi-browser tab syncing
When changing context or data on a UX page, you can now view real-time data updates across up to five visible browser tabs without refreshing, streamlining workflows and improving planning efficiency. This feature must be enabled by page builders in the Edit Selectors section under the Overview tab. Multi-browser tab sync gif (end user):
Thoughts from the Community:
- @KirillKuznetsov: Multi-browser tab syncing (from the August release). It may look simple, but it’s significant for users who’ve built their workflow around browser tabs — and we all know it can take time to adjust to a new way of working, especially for new users of the platform.
9. Charts
Updates made to Charts throughout the year:
- Network Charts: This new card type enables customers to visualize their supply chain network in the UX, including visualizing the relationship from Suppliers to Plants to Distribution Centers to Customers and identifying bottlenecks. Use conditional formatting to highlight line items or production issues based on business logic, update the model and see the impact in real time, or model multiple scenarios and see the impact over time. More information available in the official Network Charts release notes.
- Network charts: Connection labels
Users can display labels on network connections based on a selected line item. This will work for horizontal flows only and allow the value to be displayed, providing clearer visibility into flow values and allocations. - Network charts: Reorder network connection
Users can reorder connection types in network charts, further improving customization and readability of planning visuals. Thoughts from the Community:- SunnyNafraz: Finally, dramatically improving visualization and scenario planning, the Network Charts feature was released in January 2025, which allows users to visually map relationships between different parts of their business, like a supply chain.
- SunnyNafraz: Finally, dramatically improving visualization and scenario planning, the Network Charts feature was released in January 2025, which allows users to visually map relationships between different parts of their business, like a supply chain.
- Scatter and Bubble chart
Page builders can enable the Sizes option in a bubble chart so that the size of each bubble is based on the absolute value of the data point it represents.
10. Hide 'maximize' and 'comments' options on All Cards
Page builders will be able to hide the ‘maximize’ and ‘comments’ options from the Card toolbar on all the cards. Simply disable the toggle option in the new Card settings in the Overview tab. Earlier this year it was released to only Text Cards, Image cards and Field cards but later it was added to all the cards.
11. Re-order uncategorized pages
Page builders can now reorder Uncategorized pages on the Apps contents screen using the grabber icon. They can also drag and drop pages within an app from one category to another, including the Uncategorized section. This enables page builders to create their own custom sequential view of pages to be displayed to end users.
Thoughts from the Community:
- @Prajjwal88: The ability to move or restructure pages across apps without rebuilding them from scratch is incredibly helpful, especially during deployments between lower environments and production.
12. Custom button styling
Page builders can now add custom images for buttons, offering greater flexibility to elevate the design and user experience of pages. Thoughts from the Community:
- namdevgurme: Add images and change button colors to match your dashboard style. Looks great and improves user experience!
- @Pradyumna: Page builders can now add custom images for buttons, offering greater flexibility to enhance the design and user experience of pages.
13. Improved keyboard navigation across cards
Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and navigating context selectors using the keyboard are now available. This enhancement makes navigation more seamless and inclusive for all users.
14. Multi-cell undo for paste and delete actions in a grid
End users can now use keyboard shortcuts (Ctrl + Z for Windows, Cmd+Z for Mac) to undo paste and delete actions directly in the grid, reducing accidental data loss and boosting confidence and speed when making edits. Thoughts from the Community:
- @manchiravi: Although this feature is simple but very impact for end users. It prevents accidental clearing of data but no way getting the data back on their own unless we (model builders) are involved to restore the model.
- Prajjwall88: It prevents accidental data loss and removes the manual cleanup that used to follow a mistaken paste or delete.
15. External URL navigation button
Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan URLs, which will open in a new browser tab. This feature can be used to drive a more connected and streamlined experience by linking to other apps, providing shortcuts to platform pages such as their Workflow task inbox, and linking to external documentation, training, or job aids.
Workflow
16. Workflow: Updates related to Workflow
- Context in notifications: Context labels can now be included in the emails issued to task assignees and approvers. This can be especially useful when approving across multiple products, cost centers, regions, etc. or for user-triggered workflows where tasks and approvals are tied to specific line items. A tenant-level setting controls whether the context label, which is model data, is included in the email notification. The setting is set to off by default.
- Improved task completion checking: Workflow owners can now configure a completion rule to specify whether it should apply to Workflow owners as well as other users. Switching this setting on will mean everyone who completes the task will be forced to abide by the completion rule, reducing the risk of Workflow owners leaving tasks incomplete or inaccurately completed when part of someone else's workflow.
- Group approvals: Workflow owners can configure group tasks to jump straight to the approval stage of the task, allowing for "group approvals" to be configured while maintaining the ability to send work back to assignees should rework be required.
- Bulk notifications: End users who are assigned multiple subtasks as part of a group task can now be set to receive a single notification containing multiple calls-to-action, rather than multiple emails. This makes it easier for approvers to get notifications and less likely that notifications will be missed.
- Assignment filters and assignment data write: Group tasks can now be configured to only pick up context items where a filter Boolean is set, and automatically write Booleans when subtasks are assigned. This brings extra flexibility when using group tasks as part of scaled, scheduled business processes with multiple contributors.
- Reduced emails for Workflow owners: Email notifications to Workflow owners will now, by default, focus on the emails that inform an admin when action is required. Notifications that communicate updates are now turned off by default for Workflow owners, reducing the number of notifications Workflow owners receive and enabling them to focus on where action is needed.
- Custom email contents: Workflow Owners can now write their own notification emails, including custom subject lines, intro text, and outro text. This enhances the experience by providing a more tailored and intuitive message that resonates more closely and drives more effective calls-to-action.
- Extra line items in emails: When sending task or approval notifications, Workflow owners can now provide more context to users and approvers by including hand-picked line items and their values. Tenant Administrators must enable this feature as it exposes model data via email.
17. Workflow Advanced: Multiple features
Workflow Advanced is now available, which includes parallel steps, branch and reconnect, value-based decisions, and send back loops. These features empower businesses to visualize and automate processes with greater speed and confidence. Parallel steps allow multiple approvals to happen in parallel while providing different stakeholders with unique experiences. Branch and reconnect allows steps to be added to both the approval and rejection branch of a decision steps, as well as the reconnection of a branch to another step to bring two branches together. Send back loops allows, at a decision step, that the request can be sent back to a previous step in the workflow, providing a third response option for an approver (Approve, Reject, and Send Back). And value-based decision steps operate similarly to a decision task, but instead of requiring a user to make the decision, a workflow owner can use a value-based decision step to query model data and make the decision based on the model value.
Integrations & Extensibility
18. Anaplan Data Orchestrator (ADO)
- Metering improvements: The metering lozenge on the Overview page now includes consumption of storage and datasets, as well as Daily Usage of data extracts and model links.
- Transformation Blueprint view: The Transformation page now includes Blueprint view, an alternative to Grid view. This view shows details of the transformation definitions and the data type and formula for each column in the transformation. It also displays the order in which transforms are applied, making it easier to debug complex transformations. This view does not require Data Orchestrator to apply the transformation to the data, so it will typically be more responsive than Grid view when working with large datasets.
- Migrations menu item: The import Actions tab can now be found under the Migrations menu item for faster access and to clarify this as a basic migration capability when moving to Data Orchestrator from a classic Data Hub approach. This tab was previously on the Links page.
- Create a transformation view directly from a source dataset: On the Source data page, a transformation view of a source dataset can be created from the ellipsis to the right of the dataset.
- Data lineage map: On the Map page, the display of objects can be organized into swim lanes, providing a more organized display when many objects are shown. Additionally, groups of objects can be collapsed and expanded, allowing the map to be focused on types of flows at different levels. A source/target view is also available as a tab, which auto filters datasets (both source datasets and those derived using transformation views) to provide a view focused on data sources and which models they target.
- Preview dataset when mapping to model or selecting for transformation view: When selecting a dataset to map to a model link or as the source of a transformation view, there is now the option to see a preview of the data in grid view or a definition of the dataset in blueprint view. This feature improves accuracy and efficiency during dataset selection-leading to more reliable models and smoother data transformations.
Thoughts from the Community:
- jjayavalli: When mapping datasets, builders can now preview data in either Grid View or Blueprint View, making it much easier to validate structures, formats, and mappings before executing a process.
19. Export to CSV in Anaplan Data Orchestrator
Inventory pages for connections, source data, and links can now be exported to CSV, along with datasets (both source datasets and those derived from transformation views). The files are exported in 500MB segments. Download is currently limited to only the first segment, which would typically be more than 1 million rows.
20. Cloudworks: Self-manage long running process on CloudWorks
CloudWorks users will soon see a button to cancel long running processes on the CloudWorks UI. By being able to cancel jobs independently, users won't have to rely on Anaplan support, which minimizes delays and allows for quicker decision-making. This leads to a more streamlined and autonomous experience for users, enhancing overall productivity. It empowers users to have more control over their processes, improving their efficiency and saving time.
21. Anaplan XL
- General enhancements: Custom time-out queries can now be set, which will override the default time-out for any new connection added to a workbook, regardless of its connection type.
Users will now receive an additional confirmation warning when duplicate members are added to a filter dimension. And, if a user attempts to add a connection that already exists in the workbook, the system will suggest that the existing connection is used.
- Anaplan XL (version 2509) - Anaplan data source: Support has been added for drilling down in Anaplan models. Improvements have also been made to how unavailable models are handled. If an Anaplan model is unavailable when a workbook is opened, a user can turn off Anaplan XL to prevent further connection error messages from being displayed; Anaplan XL can be reactivated by the user. Users can now cancel queries and define how long to wait before the Cancel Query button appears.
- Anaplan XL Reporting (version 2510) - Freeform reports: Enhancements to freeform reports include more options for selecting members and navigating within a hierarchy, the ability to see the query text used to refresh a Freeform report, a confirmation message when all data cells or the first column of a freeform report are deleted to prevent unintentional data loss, and the ability to disable all formatting from the Freeform properties window.
- Anaplan XL Reporting (version 2510) - Anaplan data source: Only updated or new values will now be sent to Anaplan, increasing efficiency with how writes are handled. Additionally, custom calculations are now supported when selective access is used.
- Anaplan XL Reporting (version 2507) general enhancements: Support has been added for Anaplan workspace, model and module labels in grid titles and XL3ConnInfo function. Also improved Member Selector by adding an option for users to set a threshold for incrementally loading members. There is also single sign-on (SSO) support for Atoti connections from Anaplan XL Web edition.
- Anaplan XL Reporting (version 2507) Writeback enhancements: The Writeback panel is now available in GA. Support for Anaplan Breakback has been added, as well as an option for Grids and FreeForm reports.
Security & Administration
22. License Management Reporting
With License Management Reporting (LMR), tenant and user administrators can now view, allocate, and track usage against the licenses an organization has purchased. LMR brings transparency and control to license management - streamlining license management and helping further optimize use of Anaplan. License Management Reporting here.
23. Other administration features
- Tenant administrations can assign the Application Owner role to users in their tenant. The user assigned this role will see the applications deployed to their tenant, initiate the generation of an application, and accept a new version update for each application. This role will further enhance operational efficiency with robust application governance.
- UX based audit: Events tracked in Anaplan's central Audit Service now include a variety of activities logged from the UX. This includes when apps and pages are opened, and details of which page type they were.
- Global navigation: End users with access to more than one tenant can now see which features are assigned to their selected tenant when opening the main menu in the global navigation bar. This makes it clear which features can or cannot be used by the logged-in user on the current tenant, enabling users to focus on what's relevant and making the platform more intuitive.
- Limit exception user assignment to Administration only: Tenant Administrators can turn on a "Limit exception user assignment to Administration only" switch to enable only Tenant Security Administrators to assign exception users in Administration. Workspace Administrators will be unable to assign exception users within models.
- IP allowlist enhancement: Tenant security administrators can now import or export IP address policies using a CSV file.
Anaplan Intelligence
24. CoPlanner: Link to relevant pages
CoPlanner can now display up to three direct links to relevant pages in response to a user's question. These links are contextual, personalized based on access permissions. They're designed to help users explore insights, locate where key actions can be taken, and quickly access related content.
25. Anaplan Optimizer log API
Workspace Administrators can download Anaplan Optimizer logs via API for root cause analysis of optimization errors.
Conclusion
This list is not exhaustive and there are many more other features that were released to the platform which did not make it to our top 25. All official release notes are here, and also check out the Community’s top picks in the November Community Challenge blog!
…………..
More from Misbah:
Misbah
[Polaris] Allow for the use of Suppress 0's functionality on saved views for Model to Model exports
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: While understanding there are potential updates in the works, an alternative solution for Model to Model import challenges within Polaris could be allowing for the use of Suppress 0's in saved views instead of native filtering. With the updates to allow for more rows on the pivot, being able to use saved views with the suppress 0's functionality can replace the vast majority of filtering. Currently you are not allowed to save a view with suppress 0's.
How often is this impacting your users? Frequent
Who is this impacting? All Polaris Users
What would your ideal solution be? How would it add value to your current experience?
This minimize the need for exports with many dimensions to have to be made 'flat'. Making flat exports with lots of dimensions requires multiple staging modules and at times the use of the text fields or item names.
Please include any images to help illustrate your experience.
Estimated size of deployed model when making changes to dev model
After making changes in dev, we could not synchronise them with the production model because the latter model would have been larger than 130GB. This means that we had to turn off / change the newly developed functionalities because we were not able to estimate the size impact of the changes. It would therefore be great to have a way to, when making changes in dev, estimate the size impact in deployed model.
Benefit: save time, better space management
MagaliP
A reading list to broaden your abilities beyond Anaplan technical skills
Author: Tristan Colgate is a Certified Master Anaplanner and Managing Director at Fidenda.
It’s early January and, after a well-needed break over the holiday season, many of us will be returning to work with renewed energy and a desire to level-up our careers over the coming year. I hope this article gives some ideas for those of us who enjoy reading.
Whether you are working in-house at an organization implementing and supporting an Anaplan solution, or a consultant helping organizations do so from the outside, it’s important to develop skills outside of core Anaplan model building and solution architecture.
In my 25+ years of working with EPM technology, I’ve enjoyed reading around the subject to build up rounded skills that help me best serve my customers. In this blog, I’m glad to share some of the key resources that I’ve used in the past. I hope others enjoy some of these as much as I have.
By the way, the list is far from exhaustive and I’m always looking for new titles to read. Please share any recommendations in the comments.
Build a strong foundation of business domain knowledge
It’s important to have a sound grasp of the business process that your solution supports and be able to talk the same language as your business colleagues and customers. Topics like accounting and supply chain planning are vast and intimidating at first to those who haven’t either studied or lived and breathed them in business. The following are some great introductory texts to these large topics.
- Frank Wood’s Business Accounting by Wood and Sangster. I often wonder whether I should have taken an accounting qualification earlier in my career. Instead, I read this book, which gives a fantastic introduction to the topic for the uninitiated. If you’re delivering Anaplan solutions to finance teams there is a base level of accounting knowledge that you must have. This book gives you that and more. Amazon link
- Financial Planning and Analysis and Performance Management by Jack Alexander. Once you have the accounting fundamentals under your belt, it’s time to focus on one of the departments most likely to be able to benefit from Anaplan, FP&A. This book dives deep into the topic and gives a comprehensive overview of the key drivers of business performance, and how FP&A teams analyse those in support of business decision-making. Amazon link
- Group Accounts – a European Perspective by Pierce and Brennan. With Anaplan’s acquisition of Fluence and the availability of the FCR App, it is now important to understand the nuances of group reporting, otherwise referred to as financial consolidation. Consolidation projects are heavy on knowledge of technical accounting and it is essential to have the base knowledge this book provides before embarking on one. Note: it is written from a European perspective and US GAAP has some different concepts. Amazon link
- Supply Chain Management by Sunil Chopra. For anyone unfamiliar with this topic, this book provides a great introduction. Chopra takes the reader from basic principles and there are links to online resources including Excel models showing how the different concepts work. Reading this will give you the background knowledge to have meaningful conversations with supply chain practitioners in your business or customer. Amazon link
- It is not a book, but I can’t recommend highly enough subscribing to Secret CFO here. There’s a newsletter each week unpacking in nerdy detail a different topic relevant to the role of the CFO. I have found that this has helped me understand in better detail the CFO role and what keeps them up at night, so that I can better help them.
Sharpen your soft skills
I sometimes joke that the easy part about any Anaplan project is the bit where we get to sit down and build the solution. On a serious point, everything that happens up to that point is where the hard yards are because it all involves working with other people; whether that’s influencing a senior team to make the investment in Anaplan, or working with business stakeholders to understand their requirements and guide them through the design of a solution. This requires soft skills, and there several books that are very helpful here.
- The Trusted Advisor by Maister, Green & Galford. To wield influence and get things done in an organization it is essential that you build a reputation as someone who can be trusted to impart advice. This book takes the reader through important soft skills such as active listening in that pursuit. Amazon link
- The Five Dysfunctions of a Team by Patrick Lencioni. Whether we’re building an Anaplan Center of Excellence or working in a project team alongside business stakeholders, it’s important to not take team dynamics for granted. This is a particularly compelling book because it uses a story of a team and how they evolve to introduce the author’s model of what makes an effective team. You don’t need to be a leader to read the book — it’s equally useful if you work as part of a team. Amazon link
- Good to Great by Jim Collins. This book is about how you build a great company, but this can be scaled down to how to build great teams. It focuses on the important of having clarity of purpose, the right people in the team, a focus on identifying and facing down challenges, the importance of continual improvement, discipline and tracking progress. Reading this book gave me inspiration feeding into how I built our Anaplan consulting firm and could equally apply if you’re building an internal Anaplan COE. Amazon link
What would you add to my list? Leave a comment, and happy reading!
Multiple approvers in workflow when using, "select user from a line item in a module”
Currently we can assign only 1 approver when assigning using "select user from a line item in a module”. There is no option assign the task to multiple approvers and have one of them approve the task. Even if we create 2 line items each for an approver, since it is a drop down, it is currently giving an option to select only one approver.
The expectation is that when one approves, the workflow should not ask for further approvals and it should move to approved state.
Re: How I Built It: Customizing Summary Methods
Polaris Improvement: You can use HIERARCHYLEVEL top accomplish the results of your SYS Hierarchy Levels with only one line item, summary of Formula.
Inspired by the best: Master Anaplanner insights to close out the year
Hello, Anaplan Community!
What an amazing year it’s been! As we look back on 2025, I am absolutely blown away by the spirit of collaboration and support that defines our community. Every single day, you all show up for each other, sharing knowledge, solving complex challenges, and pushing the boundaries of what’s possible.
This year, you collectively posted over 1,500 questions and provided an incredible 4,000+ answers! That represents thousands of moments of connection, learning, and progress. Thank you for making this community the vibrant, helpful, and indispensable resource that it is.
⭐️ Community Champions of 2025!
I want to give a special shout-out to some of our most active and helpful members this year. Your contributions have not gone unnoticed, and your willingness to jump in and help others is the bedrock of this community. A huge round of applause for a few of our top commenters: @devrathahuja @Dikshant @rob_marshall @seymatas1 @Tiffany.Rice @Prajjwal88 @andrewtye @SriNitya @logikalyan and @alexpavel.
🏆️ Perspectives from Anaplan Certified Master Anaplanners
One of my favorite parts of this community is learning from the best of the best. To celebrate the year, I asked five of our brilliant Certified Master Anaplanners to share their biggest wins from 2025 and what they’re aiming for in 2026.
I hope their stories inspire you as much as they’ve inspired me!
Junqi Xue, Certified Master Anaplanner and Solution Architect at valantic
For Junqi, 2025 was all about building a deeper, more versatile skill set and giving back to the community. Here's what he had to say:
"Here are my learnings from 2025:
Built my foundational knowledge:
a. Completed trainings on ADO, Polaris, Workflow, and tried finding their use cases in our projects and proposals across functions, e.g. finance and supply chain.
b. Attended the workshop for the Anaplan SC APP, getting to understand the capabilities of Anaplan Apps more in details, advocated and shared the knowledge with my internal colleagues.
Enhanced capability: I implemented two complicated use cases of Optimizer (production planning, resource allocation and planning), including the analysis of the results.
Community growth: Some interesting new functions were suggested and added to the valantic Anaplan extension this year, namely the visualization of the line items, list items, or anything, that is used as filter in saved views. Along with the visualization of actions/processed used on the UX. As a result, now the model clean up is even easier, especially solving the pain point of not being blind anymore."
Junqi's target for 2026: "Gather more hands-on experience on the Polaris engine."
Julie Ziemer, Business Solutions Architect at Royalty Pharma, LLC
Julie and her team drove a true transformation in how their organization approaches planning. In her own words:
"This past year has been a truly transitional step forward in our Anaplan journey, driven by myself and my team. What began as an effort to modernize financial modeling has evolved into a full-blown transformation in how we plan, connect data, and collaborate across departments.
We've successfully built and streamlined the foundation of our models, providing a clearer, real-time view of performance and forecasts. This means significantly fewer spreadsheets (win!) and far more confidence in our numbers. Along the way, we rigorously tested, refined our logic, and constantly reminded ourselves that “version control” is not a lifestyle choice, but a life-saving best practice. The progress hasn’t just been about automation; it’s been about building a sustainable framework that enables us to work smarter, not harder.
Looking ahead, our team's focus is on expanding Anaplan’s role in financial reporting, bringing greater automation, transparency, and storytelling to our data. To ensure long-term success, we’re laying the groundwork for a Center of Excellence (CoE) to help our models, processes, and people thrive as a connected Anaplan community."
Julie's goals for 2026:
- "To ensure 100% adoption of Anaplan by all finance team members, completely moving away from legacy systems to establish a single source of truth for planning and reporting.
- To lead the integration of Anaplan beyond the finance function into a new business area, such as research or HR planning, to foster true connected planning across the entire organization."
Wenwei Liu, Anaplan Systems Architect at Atlassian
Wenwei’s journey from consulting to an internal role gave her a powerful new perspective. She shares:
"Through my transition from Anaplan Consulting to the internal Anaplan team, I gained a fundamentally different perspective on how Anaplan supports business connected planning from the customer side. A key accomplishment was contributing to a large-scale model rebuild project that deepened my understanding of the platform's capabilities and identified critical customer needs. This shift from external consultant to internal team member positioned me to bridge consulting expertise with product strategy, uncovering pain points and opportunities that will drive more customer-centric solutions."
Wenwei's goal for next year: "Leverage emerging AI capabilities and new Anaplan features to enhance the connected planning experience for our users, while improving efficiency in model building and internal support processes."
Dmitry Sorokin, Senior Software Engineer at lululemon
Dmitry focused on the power of collaboration and technical excellence to elevate his company's Anaplan ecosystem. He reflects:
"2025 was a year of collaboration and learning. I focused on simplifying complex model logic to reduce calculation times and enhance the user experience across our Anaplan Connected Planning ecosystem. I also partnered with engineering to streamline integration pipelines, improving data refresh speed and overall reliability."
Dmitry's goal for 2026: "I’m excited to continue mentoring new model builders while expanding my architecture expertise. I plan to explore new ways to leverage AI in model building, automated testing, and planning workflows."
Ekaterina Garina, EPM Consultant at Keyrus
Ekaterina spent her year strengthening Connected Planning by bridging the gap between finance and procurement for her clients. She explains:
"This year, I worked closely with clients to strengthen their FP&A capabilities in Anaplan, helping leaders gain clearer insights and make more confident, data-driven decisions. A major highlight was delivering equipment-level variance analysis that improved visibility into cost drivers and simplified performance explanations for stakeholders. Procurement reporting was enhanced through the introduction of clear price and volume impact breakdowns, enabling a deeper understanding of spend movements. These initiatives strengthened Connected Planning by aligning finance and procurement around shared outcomes and consistent insights."
Ekaterina's goal for 2026: "I look forward to continuing to deliver scalable, high-impact solutions that help organizations plan faster and respond more effectively to change."
Now, it's your turn!
What an inspiring collection of achievements! Now, I want to hear from YOU.
What was your biggest win of 2025? What are you looking forward to tackling in 2026? Share your story in the comments below!
Happy planning,
Ginger Anderson
Sr. Manager, Community & Engagement Programs
Re: TEXTLIST() vs [TEXTLIST:]
Ankit,
The function TextList, no matter how it is used, is bad on performance. Why, because it relies on Text and Text is evil due to the amount of "real" memory it uses. In the UX, text is approx 8 bytes, but in reality, it is (2 * the number of characters of the text string) + 48 bytes. So, the string ABC is really 54 bytes. And when you use TextList, those bytes start adding up very quickly. Take a look at the below, when you use text concatenation on 100 million cells

And that is only doing one concatenation, but with TextList, you can have multiple, just adding to it every character at a time which then blows the performance out.
Does this help?
Please let me know.
Rob
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
- What is Anaplan Connect?
- What is covered in this article?
- What is NOT covered in this article?
- What pre-requisites do I need?
- Deep Dive on Integration
- Integrating with SAP HANA Cloud
- Integrating with Snowflake
- Integrating with Azure SQL Database
- Integrating with Google Cloud (GCP) BigQuery
- Integrating with Oracle database (On-Prem)
- Integrating with Oracle Cloud Database
- Summary
We are kicking off this series, focused on Anaplan Connect 2.0, with 3 articles:
- Start Here - all you need to know to get started on your Anaplan Connect 2.0 journey,
- Advanced Scripts - ready-to-use scripts to take your Anaplan Connect 2.0 further, and
- Integration with On-Prem integrations platforms - connect your Anaplan data to virtually any On-Prem and SaaS platforms
What is Anaplan Connect?
Anaplan Connect is a Java based command line utility that facilitates automation of integrations between Anaplan and data sources. Data sources, currently, supported by Anaplan Connect include flat files and databases (on-prem & cloud). Database connectivity is established via Java Database Connectivity (JDBC).
The following resources will help you get started with Anaplan Connect installation and implementation.
- Data Integration – Part 1
- Data Integration – Part 2
- Introduction to Anaplan Connect
- Anaplan Connect – Data from a Flat File
- Anaplan Connect – Data from a JDBC Database
- Anaplan Connect - Guidelines
- How to leverage sample codes to generate authentication strings from CA Certs?
In this article, we will focus exclusively on integrating Anaplan with following databases using Anaplan Connect and JDBC:
- SAP HANA Cloud
- Snowflake
- Azure SQLDB
- Google Cloud BigQuery
- Oracle (On-Prem)
- Oracle Cloud Database
What is covered in this article?
Connectivity to both On-Prem & Cloud Databases via JDBC using Anaplan Connect is, essentially, the same. The differences are in required JDBC libraries (.jar), how JDBC string is constructed and some nuances in SQL queries. We will present JDBC connection strings for databases listed above, required JDBC libraries, and any relevant tips.
What is NOT covered in this article?
We will not be presenting basics of Anaplan Connect, scripting, and authentication.
Please refer to resources above to get started on Anaplan Connect.
What pre-requisites do I need?
- Knowledge of building Anaplan Connect scripts
- Java 8 installed (or supported JDK. Please refer to Anaplan Connect documentation for Java compatibility).
- Anaplan Connect 2.0 installed on a Windows/Linux/MacOS
- Database access & connectivity information you wish to connect to
- JDBC Driver(s)
- Whitelisting of api.anaplan.com, auth.anaplan.com
- Port 443 open for bi-directional communication
- Anaplan account with either basic authentication (username/password) or CA Certificate.
- Text editor (ex: Sublime Text, UltraEdit, etc…)
Deep Dive on Integration
Integrating with SAP HANA Cloud
In this section, we will cover connectivity to SAP HANA Cloud via JDBC using Anaplan Connect 2.0. We will begin by establishing and testing JDBC connectivity outside of Anaplan Connect, followed by configuring Anaplan Connect scripts to import data from a SAP HANA Cloud table into Anaplan.
Establishing JDBC connectivity
- Download & copy latest jdbc driver for SAP HANA Cloud to <anaplan-connect>/lib directory.
- Download root certificate ‘DigiCert Global Root CA’ from DigiCert. You can download this certificate in pem format here. Additional JDBC information can be found on SAP Help Portal here.
- Add ‘DigiCert Global Root CA’ certificate to Java VM Keystore using following command. Note: You may need to log into linux/MacOS as root to perform this step. Instructions to enable root user on a MacOs can be found here.
Linux/MacOs
keytool -import -trustcacerts -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass <password> -alias DigiCertGlobalRootCA -import -file DigiCertGlobalRootCA.crt
Windows
keytool -import -trustcacerts -keystore "%JAVA_HOME%\jre\lib\security\cacerts" -storepass <password> -alias DigiCertGlobalRootCA -import -file DigiCertGlobalRootCA.crt
Ensure JAVA_HOME is set. You will need your Java VM Keystore password. Default value for Java VM Keystore is likely ‘changeit’.
- Once certificate has been added to the keystore, we will build jdbc connection string. JDBC syntax for SAP HANA Cloud is:
jdbc:sap://<host endpoint>:<port>
- You can obtain endpoint for your SAP HANA Cloud database in SAP HANA Database Explorer under database properties. Port is standard HTTPS port, 443.

- Based on information from the picture above, JDBC string would look something similar to:
jdbc:sap://430f7d5a4c5866c.hana.trial-us10.hanacloud.ondemand.com:443
Test JDBC Connection
- Once we create JDBC connection string to our SAP HANA Cloud database, we will test the connection using Java on the command line. Syntax to test JDBC connection is:
java -jar <jdbc driver> -u User1,Password123 -n 12345678-abcd-12ab-34cd-1234abcd.hana.hanacloud.ondemand.com:443 -o encrypt=true -c "SELECT 1 FROM SYS.DUMMY";
- Launch command prompt (Windows) or Terminal (MacOs) and change directory to location of <anaplan-connect>/lib directory. You should already have your jdbc driver (ex: ngdbc-2.8.12.jar) in this directory.
- Using your database information construct a command line syntax similar to the one shown below, resulting in one row from the SQL query:

- Now that we have successfully established jdbc connection to an SAP HANA Cloud database and tested it, we are ready to configure Anaplan Connect script.
Configure Anaplan Connect Script
In this scenario, I have a database table in SAP HANA Cloud named “Accounts”. This table has data that will be used to populate a LIST (Accounts) and a Module (AccountDetails) in Anaplan. There is also an associated Anaplan Process we will execute from Anaplan Connect script. Anaplan Connect script will connect to SAP HANA Cloud table “Accounts” via JDBC and then will execute a process, procLoadAccountDetails.
Two files need to be configured for Anaplan & JDBC integration:
- Jdbc-query.properties: This file will contain JDBC connectivity information as well as SQL query. Sample example-jdbc-query.properties file is available as a starter in <anaplan-connect>/examples directory.
- Anaplan Connect script: This script will reference the jdbc.properties file (instead of a flat file) to establish connection to the database and execute the SQL query. Output from the query is, then, uploaded to a file (data source) on Anaplan platform.
Configure JDBC Properties
Following steps outline instructions to configure jdbc.properties and Anaplan Connect script.
- Copy example-jdbc-query.properties file to <anaplan-connect> directory.
- Rename the file to something meaningful (ex: jdbc_SAPHANACloud_Select_query.properties)
- Depending on the type of authentication and OS being used, copy appropriate sample script from <anaplan-connect>/examples directory. For this article, I’ll be using sample_basic_auth_import.sh.
- Rename sample_basic_auth_import.sh to something meaningful (ex: jdbc_SAPHANACloud_accounts_select_basic_auth.sh).
- We will edit the jdbc properties file providing required JDBC connection and SQL statement. Update following variables in the jdbc properties file:
Jdbc.connection.url, jdbc.username, jdbc.password, & jdbc.query

- If you notice, the line for jdbc.params is commented out. This is because my SELECT statement does not have any parameters (ex: values for a ‘where’ clause).
Anaplan Connect Script
- We’ll create an Anaplan Connect script now to reference the jdbc properties file.
- In a text editor, open your Anaplan Connect script you copied earlier to <anaplan-connect> directory.
- Add following variables
- ProcessName, jdbcproperties
- Optional: Remove variable “ImportName”. You may choose to execute an Import Action instead of a Process. In such case, you may keep variable ImportName.
- Provide following information:
- AnaplanUser, WorkspaceId, ModelId, ProcessName, FileName, ErrorDump, jdbcproperties

- Modify the line “Operation =” to reference jdbcproperties variable and execute a process instead of an import action.

- Save your script and execute it from the command prompt.
- Successful run will show database connection, SQL query execution, number of records transferred from the database to Anaplan, and results from Process execution.

NOTE: when it comes to exports, we strongly recommend to use csv format. Other extensions like "xls'" might bring some issues.
Next section will present Anaplan Connect connectivity to Snowflake.
Integrating with Snowflake
Setting up Anaplan Connect script to integrate Anaplan with Snowflake is very similar to the steps outlined above for SAP HANA Cloud. Slight modification to jdbc properties file and Anaplan Connect script is all it takes. We will examine JDBC connection properties required to establish connection to a Snowflake database.
In this example, my snowflake database name is “AnaplanDB”, name of virtual Warehouse is “COMPUTE_WH”, and schema is “Public”. Similar to SAP HANA Cloud, I have a table named “Accounts” from which Anaplan Connect will extract data and import into a model via a process.
JDBC Driver
- Download latest JDBC driver for Snowflake by following instructions provided here. Current version of JDBC driver is 3.13.4 (snowflake-jdbc-3.13.4.jar).
- Copy JDBC driver to <anaplan-connect>/lib directory.
JDBC Connection String
Connection string (JDBC) for Snowflake is as follows:
"jdbc:snowflake://.snowflakecomputing.com/?"
Connection parameters include information such as database name, schema name, warehouse name, etc. A comprehensive list of connection parameters for JDBC can be found here.
You can obtain <account_name> from the URL of your Snowflake account.

Based on information from the image, JDBC string for my Snowflake database would be something like:
"jdbc:snowflake://he34739.us-east-1.snowflakecomputing.com/ warehouse=COMPUTE_WH&db=AnaplanDB&schema=public"
JDBC Properties
- Copy example-jdbc-query.properties file to <anaplan-connect> directory.
- Rename the file to something meaningful (ex: jdbc_Snowflake_Select_query.properties)
- Edit JDBC properties file created above and update values for
- Jdbc.connection.url, jdbc.username, jdbc.password, & jdbc.query
- Sample JDBC properties file is shown below

Anaplan Connect Script
- We’ll create an Anaplan Connect script now to reference the JDBC properties file.
- In a text editor, open your Anaplan Connect script you copied earlier to <anaplan-connect> directory.
- Add following variables
- ProcessName, jdbcproperties
- Optional: Remove variable “ImportName”. You may choose to execute an Import Action instead of a Process. In such case, you may keep variable ImportName.
- Provide following information:
- AnaplanUser, WorkspaceId, ModelId, ProcessName, FileName, ErrorDump, jdbcproperties

- Modify the line “Operation =” to reference jdbcproperties variable and execute a process instead of an import action.

- Save your script and execute it from the command prompt.
- Successful run will show database connection, SQL query execution, number of records transferred from the database to Anaplan, and results from Process execution. You may notice additional verbose information. If you choose to omit this information, you may experiment with JDBC connection parameter tracing.

Integrating with Azure SQL Database
Setting up Anaplan Connect script to integrate Anaplan with Snowflake is very similar to the steps outlined above for SAP HANA Cloud. Slight modification to JDBC properties file and Anaplan Connect script is all it takes. We will examine JDBC connection properties required to establish connection to a SQL database on Azure.
In this example, my Azure SQL database name is “AnaplanDB”, on a server labeled “anaplandi”, and schema is “dbo”.

Similar to SAP HANA Cloud & Snowflake, I have a table named “Accounts” from which Anaplan Connect will extract data and import into a model via a process.

JDBC Driver
- Login in Azure Portal, select your database, and choose Connection strings from the left-hand pane.
- Select JDBC on the right-hand pane. You will notice jdbc connection string under JDBC (SQL authentication) and a link to download JDBC driver for SQL server.

- Alternatively, you may download JDBC driver for SQL server from the link here.
- Once you download and unzip the driver zip file, select the jar file that corresponds to your Java version. I have Java 8 installed on my system, therefore, I will choose mssql-jdbc-9.2.1.jre8.jar.

- Copy JDBC driver (ex: mssql-jdbc-9.2.1.jre8.jar ) to <anaplan-connect>/lib directory.

JDBC Connection String
Constructing JDBC string for Azure SQL database is very simple. The connection string for your database is provided to you in Azure portal. Copy JDBC connection string provided in Azure portal under settings > Connection strings > JDBC.

JDBC Properties
- Copy example-jdbc-query.properties file to <anaplan-connect> directory.
- Rename the file to something meaningful (ex: jdbc_AzureSQL_Select_query.properties)
- Edit JDBC properties file created above and update values for
- Jdbc.connection.url, jdbc.username, jdbc.password, & jdbc.query
- Copy JDBC connection string from Azure portal and replace the value for jdbc.connection.url variable.
- Sample JDBC properties file is shown below

Anaplan Connect Script
- We’ll create an Anaplan Connect script now to reference the JDBC properties file.
- In a text editor, open your Anaplan Connect script you copied earlier to <anaplan-connect> directory.
- Add following variables
- ProcessName, jdbcproperties
- Optional: Remove variable “ImportName”. You may choose to execute an Import Action instead of a Process. In such case, you may keep variable ImportName.
- Provide following information:
- AnaplanUser, WorkspaceId, ModelId, ProcessName, FileName, ErrorDump, jdbcproperties

- Modify the line “Operation =” to reference jdbcproperties variable and execute a process instead of an import action.

- Save your script and execute it from the command prompt.
- Successful run will show database connection, SQL query execution, number of records transferred from the database to Anaplan, and results from Process execution.

Integrating with Google Cloud (GCP) BigQuery
Setting up Anaplan Connect script to integrate Anaplan with Google Cloud Platform’s (GCP) BigQuery is similar to the steps outlined above for SAP HANA Cloud. Creating JDBC connection string has some additional steps. We will present steps necessary to capture required information to create JDBC connection to GCP BigQuery. Once JDBC connection string is defined, rest of the Anaplan Connect steps are similar to other JDBC data sources.
Additional information on Anaplan & GCP BigQuery integration can be found on community here.
In this example, my GCP BigQuery dataset name is “anaplandi”, on a project labeled “celtic-spider-206221”, and the table is “Accounts”.

Anaplan Connect will extract data (using SQL SELECT) from Accounts table and import into a model via a process.
GCP Administration
Before we create JDBC connection and Anaplan Connect scripts, we must perform couple of administration tasks on Google Cloud Platform to create a service account and enable BigQuery API. Creating a service account will allow us to authenticate to GCP via a downloadable private key (JSON file).

- In GCP, go to API & Services Credentials Service Accounts Manage Service Accounts to create a service account.


- Once you create the service account, you will need to generate a private key that will contain information about client_email, project_id, and private key.
- Under “Actions” for the service account, select “Manage Keys”. From the drop down list, select “Create new key”.

- Select the downloadable file type (JSON/P12) and secure the file in a safe place. You will need this as part of JDBC connection string.

- Next, we will need to enable GCP BigQuery API.
- In GCP, go to API & Services > Dashboard and click on Enable API and Services.

- Search for and enable following APIs:
- BigQuery API, Google Cloud Storage JSON API


- You should see both APIs enabled in your dashboard.

JDBC Driver
- Download latest GCP BigQuery JDBC driver by Magnitude Simba from Google’s website.
- Copy JDBC driver and related .jar files to <anaplan-connect>/lib directory.
JDBC Connection String
GCP BigQuery JDBC driver by Magnitude Simba uses OAuth2.0 protocol for authentication & authorization (via Oauth APIs). In our example, we will use Google Service Account method. Instructions to setup a Google Service Account can be found here. Additional information on constructing jdbc connection string can be found on Simba documentation here.
You will need following information from GCP console to construct jdbc connection string to BigQuery:
- ProjectId, OAuthServiceAcctEmail, OAuthPvtKeyPath (json/p12 file you downloaded earlier).
- ProjectId can be found from list of projects in GCP console.

- You will find OAuthServiceAcctEmail under service accounts you created earlier.

- OAuthPvtKeyPath is the location of json/p12 file you created earlier.
Once you have above information, you can construct JDBC connection string using following syntax:
jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<project_id>;OAuthType=0;OAuthServiceAcctEmail=<email address>; OAuthPvtKeyPath=<path_to_json/p12>;IgnoreTransactions=1;
Sample JDBC connection string may look something similar to:
We will use this JDBC connection string in JDBC properties file next.
JDBC Properties
- Copy example-jdbc-query.properties file to <anaplan-connect> directory.
- Rename the file to something meaningful (ex: gcpbigquery-jdbc-query.properties)
- Edit jdbc properties file created above and update values for
- Jdbc.connection.url & jdbc.query
- Since we’re using service account and OAuth credentials, we don’t need to provide username and password. Comment out variables jdbc.username and jdbc.password.
- Using example shown above, construct jdbc connection string and paste it for variable jdbc.connect.url.
- Sample JDBC properties file is shown below

Anaplan Connect Script
- We’ll create an Anaplan Connect script now to reference the jdbc properties file.
- In a text editor, open your Anaplan Connect script you copied earlier to <anaplan-connect> directory.
- Add following variables
- ProcessName, jdbcproperties
- Optional: Remove variable “ImportName”. You may choose to execute an Import Action instead of a Process. In such case, you may keep variable ImportName.
- Provide following information:
- AnaplanUser, WorkspaceId, ModelId, ProcessName, FileName, ErrorDump, jdbcproperties

- Modify the line “Operation =” to reference jdbcproperties variable and execute a process instead of an import action.

- Save your script and execute it from the command prompt.
- Successful run will show database connection, SQL query execution, number of records transferred from the database to Anaplan, and results from Process execution.

Integrating with Oracle database (On-Prem)
Setting up Anaplan Connect script to integrate Anaplan with On-Prem Oracle database is similar to the steps outlined for other JDBC sources above. Therefore, we will not be regurgitating the same information for Oracle database in this section. We will, however, provide you JDBC driver information and JDBC connection syntax required when connecting to Oracle database (On-Prem).
JDBC Driver
- Download latest jdbc driver (ex: ojdbc8.jar) for your Oracle database version from Oracle here.
- Copy jdbc driver to <anaplan-connect>/lib directory.
JDBC Connection String
JDBC connection string for Oracle database (On-Prem) is pretty straight forward. You will need following information: Oracle server name or IP address, port (generally 1521), service name. JDBC syntax is as follows:
Jdbc:oracle:thin:<server/ip>:<port>:<servicename>
Example: jdbc:oracle:thin:192.168.196.128:1521:xe
Integrating with Oracle Cloud Database
Setting up Anaplan Connect script to integrate Anaplan with Oracle Cloud Database is similar to the steps outlined for other JDBC sources above. For this scenario, we’ll be using Oracle Autonomous Database. In this section we will present the following:
- Download Client Credentials (Oracle Wallet) for authentication
- Required JDBC Drivers
- Constructing JDBC connection string
Download Client Credentials
- Log in to Oracle Cloud. Go to Overview > Autonomous Database > <database>.
- Under database details, click on DB Connection.

- Under Wallet type, select Instance Wallet and click Download Wallet. You may be prompted for a password. Download the wallet to the system that’s running Anaplan Connect.

- Wallet will name following naming convention: Wallet_<dbname>.zip (ex: Wallet_anaplandb.zip).
- Unzip the wallet to a directory. Path to this directory will be used in your jdbc connection string. As a best practice, you will want to secure access to this directory to only “integration user” as it contains private key information for authentication and access.
JDBC Driver
- You will require following JDBC drivers to connect to Oracle Cloud Autonomous Database.
- odbc8.jar, ucp.jar, oraclepki.jar, osdt_core.jar, osdt_cert.jar
- You may download these drivers from Oracle here.
- Copy above mentioned drivers to <anaplan-connect>/lib directory.
JDBC Connection String
JDBC connection string for Oracle Cloud Autonomous Database is relatively straight forward. You will need following information: TNS alias (found in tnsnames.ora in Wallet_<dbname> folder), path to Wallet_<dbname> directory. JDBC syntax is as follows:
Jdbc:oracle:thin:<TNS alias>?TNS_ADMIN=<path-to-wallet>
Example:
jdbc:oracle:thin:@anaplandb_high?TNS_ADMIN=/Anaplan/DataIntegration/OracleCloud/Wallet_anaplandb
TNS alias can be found in tnsname.ora file in Wallet_<dbname> directory.

Anaplan Connect
- Build a jdbc properties file with jdbc connection string, database username, password, and SQL SELECT query.

- Build an Anaplan Connect script referencing the JDBC properties file to execute either an Action or a Process.

- Run Anaplan Connect script

Summary
For a quick reference, the table below provides sample JDBC connection strings for different database solutions we covered in this blog.
|
Database |
JDBC Connection String |
|
SAP HANA Cloud |
jdbc:sap://430f7d5a4c5866c.hana.trial-us10.hanacloud.ondemand.com:443 |
|
Snowflake |
jdbc:snowflake://he34739.us-east-1.snowflakecomputing.com/?warehouse=COMPUTE_WH&db=AnaplanDB&schema=public |
|
Azure SQL |
jdbc:sqlserver://anaplandi.database.windows.net:1433;database=anaplandb;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30; |
|
GCP BigQuery |
|
|
Oracle (On-Prem) |
jdbc:oracle:thin:192.168.196.128:1521:xe |
|
Oracle Cloud |
jdbc:oracle:thin:@anaplandb_high?TNS_ADMIN=/Anaplan/DataIntegration/OracleCloud/Wallet_anaplandb
|
Additional information on Oracle JDBC Thin Connections and Wallets can be found here.
Ready to move on to the next step? Let's deep dive into Advanced Scripts.
Got feedback on this content? Let us know in the comments below.





































