Decision Management (ODM,ADS)

 View Only

 ADS - Importing decision tables from API or XLS

Jump to  Best Answer
Alexandre Lanoue's profile image
Alexandre Lanoue IBM Champion posted Fri December 27, 2024 09:03 AM

Hi,

We are using ADS to model rate sheets for services. We are able to model the rate sheets from the interface, but it would be interesting if there was a way to automate this. I have a way to prepare an XLS with the decision table...but I don't find a way to import the XLS to the decision table or to refresh the decision table with the Excel.

Anyone has tried to do this before? If yes, how did you go about automating decision table management?

Thanks!

Alex

Jean Louis Ardoint's profile image
Jean Louis Ardoint posted Thu July 31, 2025 09:18 AM  Best Answer

You can directly import xls as decision table using ADS command line tool:
https://www.ibm.com/docs/en/cloud-paks/cp-biz-automation/25.0.0?topic=reference-automation-decision-services-command-line-tool

In the command line tool documentation, look for creating decision table.

Jerome Delattre's profile image
Jerome Delattre posted Thu January 02, 2025 03:58 AM

Hello Alexandre,

The ability to export a decision table to an Excel file and import it back through the UI is not available yet but in the product backlog.

Regards,
Jerome

Peter Warde's profile image
Peter Warde posted Thu January 02, 2025 03:15 PM

Just copy and paste between the two.

https://www.ibm.com/docs/en/odm/9.0.0?topic=edt-task-5-importing-data-from-excel-into-decision-table

It works in the Business Console.

Related Content