Platform

Apptio Community Member posted Wed May 11, 2022 04:26 AM

@Jaitabh Jewel Sharma I see you had a request about this topic, too - were you able to retrieve the data? Can you help me out?
Thanks and best regards
Kevin​
#Datalink

Guillermo Cuadrado posted Thu May 12, 2022 02:56 AM

I am not sure about the REST connector approach: in any case, to get oauth2 to work, you'd need credentials. If your client's Azure administrator doesn't grant them EA access, would they set up a similar thing for REST?
If the report you're trying to download is associated to a Subscription, you might not get all the relevant data. Somebody who knows more about Azure, please correct me if I'm wrong.
Furthermore, there's a lot of logic inside CT to map the Azure billing data. Some other things might not work, although you might work around this particular issue.
 
On a more positive note:
In trying to use the REST connector—albeit for something slightly different—we tried with Postman, to ensure a better troubleshooting while things weren't working. Apptio Support also supported this. If you can get to your data via Postman, you should be able to get the REST connector to work.
#Datalink

Debbie Hagen posted Tue May 17, 2022 01:28 PM

Hi @Kevin Sylvester,
Just checking in to see if you found a resolution for this. If not let me know and we'll continue to change down an answer.  You could also try submitting a support ticket. I don't think anything is broken but Support may be able to help with your question and show you possible options.

Cheers,

Deb​

#Datalink

Apptio Community Member posted Wed May 18, 2022 07:01 AM

@Guillermo Cuadrado Thank you for your answer.
According to the customer they would not need EA Access for the reports we want to you - they say they can handle it on tenant level. At least it is what they think. The reports that we have been looking at seem to work with their level of access. ("Usage Details")
We know that Apptio CT applies some logic automatically​ to the Azure billing data. For their current use case, they would not need this as they currently only use Apptio as a platform to serve their specific needs and do not use the whole TBM approach by now.

@Debbie Hagen Thank you, too!
Unfortunately we do not have a solution yet. I will open a support ticket to see if they have any idea about this.​
If you would know anyone who might have icluded Azure data via a generic connector, it would be great to make contact.​

Main issue for us currently is to get the basic settings for the rest connector right... we are not sure about REST URL, auth URL and Token URL.
#Datalink

Jaitabh Jewel Sharma posted Wed June 08, 2022 12:49 AM

@Kevin Sylvester ... sorry I just saw this.

We haven't used the generic REST Connector with Azure, but we use it for several other data feeds (ServiceNow being one such) ... and setting it up is not too tedious. However, the Apptio DL User needs EA Access and the API credentials for the same, else it wouldn't work.​

As @Guillermo Cuadrado mentioned, you need to sort the authorization first. Once that is established, you can use a tool like Postman to iterate to the data feed you want to extract.

Also, MultiCloud connector pulls data from the Old Billing API
https://docs.microsoft.com/en-us/rest/api/billing/enterprise/billing-enterprise-api-usage-detail

but you've already mentioned the latest Consumption API above, so definitely use that one. It includes many more useful columns such as Billing Account ID. ​​
#Datalink