Let's Talk

Let's Talk.

Looking for our offices? View locations.

Talking Tech: Workday Adaptive Planning – NetSuite Web-query Integration

Let’s Talk Tech.

Accordion’s “Talking Tech” series explores how different CFO Technology solutions can empower finance functions to support organizational strategic initiatives – by implementing business process recommendations, optimizing operations, and capitalizing on value creation opportunities.

Now, let’s take a look at how to integrate Workday Adaptive Planning with NetSuite Reports via web-query.

Workday Adaptive Planning integration platform allows you to integrate to NetSuite Reports via web-query.

Workday Adaptive Planning integration platform offers several integration options to NetSuite like delivered NetSuite Connector, Saved Search Integration and Custom Cloud bundle for CCDS Integration (for Saved Searches).

A much less known integration path to NetSuite data is utilizing NetSuite reports via web-query.

Integration Steps:


On the NetSuite side, you will need to develop the report that will contain the dataset that you want to integrate. The key to this report is making sure that this report is available for web-query.

Under the More Options in the report builder make sure that “Allow web query” option is checked.

Make sure once you generate the report the icon “Export – Excel Web Query” is available

Workday Adaptive Planning

In Workday Adaptive Planning we will be configuring a CCDS data source to integrate to the report web query.

The difference here is that the CCDS bundle does not need to be installed in NetSuite like it is when using saved searches through file cabinet.

The CCDS Script follows the same process as any other scripts where you have to set where the information comes from, the parameters of your report, report columns, etc.

The key to this script is making sure the correct web query address and correct parameters are set.

Integration Considerations

This integration is no different or takes any longer to develop than the normal Saved Search integration through file cabinet (installing CCDS bundle in NetSuite).

With that in mind, the maintenance of this process will vary accordingly to the parameters you set on the report and CCDS .. so if you code the report to bring 2021 data only, maintenance will be needed once year 2022 comes.

It has been observed (although not documented) that NetSuite web query integration runs faster than Saved search integrations.

About the Author

Eduardo Braghin
Eduardo Braghin
Senior Director

Eduardo is a Senior Director within Accordion’s CFO Technology Practice. He has more than 20 years of experience leading the deployment of ERP, reporting, forecasting, and analytic solutions for companies ranging from PE-backed to Fortune 1000. Eduardo is results-oriented and has a highly effective combination of information technology expertise, diverse industry knowledge, leadership experience, and management skills. He has strong technical and business savvy in addition to communication, analytical, problem-solving, and change management abilities.  Read more

Need Adaptive Support? Let's Talk.