Data Integration

Hello guys. Can anybody help me to go through this? I need to add * Export Qlik Extract into an existing report thank you. 

Hi All I have an issue when trying to execute an insert query using jdbc. # JDBC Connection string (Oracle, Mysql, H2, etc.) jdbc.connect.url=******* # JDBC login username jdbc.username=****** jdbc.password=****** jdbc.fetch.size=10 jdbc.isStoredProcedure=false jdbc.query=Insert into flash_rw (Period) Values (?);…

I'm trying to set up an integration to get our consolidated balance sheet ending balances from NetSuite into Anaplan. Initially I was able to load transaction data using a saved search, which works for our income statement, but for the balance sheet it doesn't allow me to get the right values for foreign accounts that have…

Have noticed that in the last couple of days a couple of Cloudworks integrations have got a status of "Auto_Deactivated". Couldn't find anything in Anapedia and wondered if anyone knew what this was about? Seems to be something about the schedule as deleted the existing one, added it back and is now running fine but is…

It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…

Scheduled Cloudworks integration that fail move to AUTO_DEACTIVATED status. When this happens there's no other option that re-creating the integration from scratch, which results in unnecessary work. Depending on the user, this could have a wider application impact while the Admin integration will need to re-create the…

In Part 3, we described the procedure for using CloudWorks APIs. But the main question would be, how can we use them? Indeed, we can find that having a dedicated screen in Anaplan itself is already a major step forward. And it surely addresses most of the future needs. Nevertheless, in our strive to open our platform as…

Hi Anaplaners, I have a question related to Integrating Anaplan to Google cloud(GCP) through ADO. Currently we can integrate GCP and ADO via a GCP service account with JSON key authentication which is a static authentication method (Fixed JSON key file), Here in-seated of static authentication, can we use another dynamic…

A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…

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: in Actions - the only way to get the information is to manually export or to have an export action. It would be great if I could make…

The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…

We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…

The Google Sheets add-on doesn't let us change the dimensions in the Pivot when setting up the connection, unlike the Excel add-in. We need to create custom views in the model to be able to pull the data in the format we want. This is a big deterrent towards adoption of the Google Sheets add-in and restricts the…

The information toolbar suggests that we pivot in Anaplan using filters and pivot feature. This is an inconvenience from the user experience perspective. If that were to be the case then we are better off creating views for everyone. Moreover, this feature that's been mentioned as information does not work as intended.…

Hi Anaplaners, I have a scheduled job run by an integration [Internal (Full Access)], in the target module some data/values (text or numbers format) are imported correctly however, in some line items with DCA the values imported are zero and this is not the value in the source module. Internal (Full Access) has WRITE…

Hi, The new UX looks great and I know it has the ability to export a dashboard in pdf format. Is there a way to automate this process? I want to schedule some reports to be exported as pdf files to a cloud location or send as attachments to an email distro list. Thanks for your help.

Author: Kira Wagner is a Product Owner at Anaplan. The Oracle connector further expands Anaplan’s integration capabilities by bridging your Oracle database with the Anaplan Data Orchestrator (ADO). This connection makes your data readily available for downstream processing in your Anaplan models, supporting accurate,…

If I schedule two CloudWorks jobs, one that loads data into Module A from different Model and a second that runs the actions to move that data into Module B from Module A, will the second job wait until the first job finishes before starting, or will it start at its scheduled time even if the first job is still running.

In the NUX everytime I try to import the employee list it doesn't display the name. I am correctly importing but it continues to show the employee names as numbers. Please advise

If we schedule two CloudWorks actions to start at the same time, using the same source model but different saved views, and updates two different target models, will they run in parallel or sequentially (with one finishing before the other starts)?

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: In enterprise planning and forecasting, we aim to produce statistically sound forecasts at multiple organisational levels (e.g.…

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: In planning and forecasting processes, large volumes of textual commentary are captured at detailed levels (e.g., line items,…

I am having a challenge creating the volume input module properly as the location is showing Region. How can I change from the Region format?

This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…

Author: Piotr Weremczuk is a Certified Master Anaplanner and FinSys Application Specialist at EQT. In the first part of this two-part article, I explored the non-technical foundations of maintaining complex Anaplan environments: leadership, governance, accountability, and the importance of building the right team. All of…

Hi Team, In the official documentation under "Google BigQuery Permissions" https://help.anaplan.com/set-your-google-bigquery-permissions-5bb8f011-3fad-452a-8765-b5a7b52405a7 I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message…

Hi, Does anybody have experience of integrating Netsuite & Successfactors with Anaplan. Would be keen to understand the best practices. Regards Sanjeev

Capability to Export Model Map from Contents page to PDF/Excel.

Now using the cloudworks integrations and have come across an annoying situation. Once I set a schedule for an integration the option to run it now disappears. Only way I can find to run it now is to cancel the schedule (deactivating not sufficient) and then rebuild the schedule after I have run it and made any changes.…

Hi Everyone, I am reaching out to inquire about the possibility of connecting an SFTP server to Anaplan Data Orchestrator (ADO).Could you please let me know if such a connection is supported? If so, I would greatly appreciate it if you could provide detailed guidance or documentation on the process involved. Any specific…