Some users may be experiencing issues when trying to access customer resources like the Case Portal or the Product Licensing Center. Our team is aware of the issue and is working to resolve it. Click here for more information.
A customer would like to know if it's possible to import the license cost information into App Broker from a Coupa punch out. My initial thought is that there's no OOTB solution to do that, but wanted to check if there's anything I may be missing?
Apr 07, 2021 03:54 PM
As Charlie states, there is nothing OOTB, but I just implemented this for a customer in the last few months (they were pulling cost data from SAP, but the same solution concept would apply to Coupa). We added a custom variable to each catalog item that contains the catalog ID from the source catalog (in your case, Coupa ID). Then I wrote a PowerShell script that runs as a scheduled task to match the source catalog data to the App Broker catalog items and update the cost in WD_WebPackages. Ideally, this would be querying the source data directly via API's or some kind of ODBC connection. Keep in mind that the cost will only be as current as the schedule on the scheduled task. Also, you'll need to figure out what to do in error cases like when the catalog item in App Broker doesn't have the custom variable defined or when the value doesn't match anything in the source catalog.
Apr 08, 2021 11:41 AM
No, there is definitely not any OOTB solution for this. In theory, it could probably be done... You'd need to call into Coupa to get the costs.. You'd then need to figure out how to match up the cost from Coupa with the appropriate catalog item in WD_Webpackages. You would then need to update the CatalogCost column with the cost from Coupa.
Apr 08, 2021 11:33 AM
As Charlie states, there is nothing OOTB, but I just implemented this for a customer in the last few months (they were pulling cost data from SAP, but the same solution concept would apply to Coupa). We added a custom variable to each catalog item that contains the catalog ID from the source catalog (in your case, Coupa ID). Then I wrote a PowerShell script that runs as a scheduled task to match the source catalog data to the App Broker catalog items and update the cost in WD_WebPackages. Ideally, this would be querying the source data directly via API's or some kind of ODBC connection. Keep in mind that the cost will only be as current as the schedule on the scheduled task. Also, you'll need to figure out what to do in error cases like when the catalog item in App Broker doesn't have the custom variable defined or when the value doesn't match anything in the source catalog.
Apr 08, 2021 11:41 AM