Nov 22, 2022
06:43 PM
Hi hoping someone can help here.
I currently have a Flexera Data Platform report that I export as a CSV and manually load/refresh into a PowerBI dashboard to provide a "pretty" timeline view of when the software will be going end of life, with a few helpful view filters like within the next 5 years, already out of date etc. I was wondering if I could replace this manual execution and load into PowerBI by connection PowerBI to FlexeraOne directly to retrieve the information I need via an API.
As a complete newbie to API integration I have absolutely no idea what i am doing and found the FlexeraOne documentation hard to understand let alone try and implement.
Is their an idiot's /dummies guide to FlexeraOne API and endpoints so i can easily understand which endpoints to call to get the data I need please? Or has someone already done this and would be willing to help me through this process please?
I have access to FlexeraOne and have a Refresh Token.
I just don't know how to then use this via the PowerBI web or OAuth connection to get the data I need, being:
SW Manufacturer
SW Family
SW Category
SW Subcategory
SW Name
SW Market Version
SW Version
SW GA Date
SW EOL Date (calc.)
SW OBS Date
thanks in advance
Andi
... View more
Mar 09, 2022
12:43 AM
Anybody else using the private catalogue or just us?
... View more
Feb 07, 2022
09:13 PM
Hi All, Just wondering how everyone else is handling the registration of multiple components for a product within the FDP Private Catalog? I am finding it is one to one between product and component and therefore in the below example I have to create multiple products so that I can have multiple components.... anyone else in this boat or are we going too detailed with the mapping? This is what i have to do... which kind of makes the component field superfluous to need as I am having to include it in the Product Name field which is then selected in the Software field name. Manufacturer Family Product Component Software Market Version Version PKG Name Acme Corporation Software Family Software Admin Admin Software Admin 1 1.0.1 Acme.SoftwareFamily.Admin.1.0.1 Acme Corporation Software Family Software Driver Driver Software Driver 1 1.1.2 Acme.SoftwareFamily.Driver.1.1.2 Acme Corporation Software Family Software Finaliser Finaliser Software Finaliser 1 1.1.2 Acme.SoftwareFamily.Finaliser.1.1.2 Acme Corporation Software Family Software Processor Processor Software Processor 1 1.0.1 Acme.SoftwareFamily.Processor.1.0.1 Acme Corporation Software Family Software Extractor Extractor Software Extractor 2 2.2.2 Acme.SoftwareFamily.Extractor.2.2.2 Acme Corporation Software Family Software Updater Updater Software Updater 2 2.0.1 Acme.SoftwareFamily.Updater.2.0.1 Acme Corporation Software Family Software Matcher Matcher Software Matcher 3 3.0.0 Acme.SoftwareFamily.Matcher.3.0.0 This is what I thought I could do... or am I completely barking up the wrong tree and have assumed the wrong definition of component and/or are using the private catalogue incorrectly? Can someone also tell me why release is mandatory in the private catalogue but contains the same info as the software market/version field? Manufacturer Family Product Component Software Market Version Version PKG Name Acme Corporation Software Family Software Admin Software 1 1.0.1 Acme.SoftwareFamily.Admin.1.0.1 Acme Corporation Software Family Software Driver Software 1 1.1.2 Acme.SoftwareFamily.Driver.1.1.2 Acme Corporation Software Family Software Finaliser Software 1 1.1.2 Acme.SoftwareFamily.Finaliser.1.1.2 Acme Corporation Software Family Software Processor Software 1 1.0.1 Acme.SoftwareFamily.Processor.1.0.1 Acme Corporation Software Family Software Extractor Software 2 2.2.2 Acme.SoftwareFamily.Extractor.2.2.2 Acme Corporation Software Family Software Updater Software 2 2.0.1 Acme.SoftwareFamily.Updater.2.0.1 Acme Corporation Software Family Software Matcher Software 3 3.0.0 Acme.SoftwareFamily.Matcher.3.0.0
... View more
Feb 07, 2022
01:41 AM
Hi All, Just wondering if I am comparing the wrong software components... is the "Windows Server AppFabric" software in FDP the Technopedia representation of Microsoft's "AppFabric 1.1 for Windows Server", and if so... can someone please explain to be why the Out of Support date in FDP shows as 14th July 2026 yet the Microsoft Product Lifecycle search returns 12th Apr 2022? FDP report on "Windows Server AppFabric 1.1" SW Manufacturer SW Name SW Component SW Market Version SW Version SW Edition SW OBS Date Microsoft Windows Server AppFabric - 1 1.1 - 07/14/2026 Microsoft Product Lifecycle search on "AppFabric 1.1 for Windows Server" AppFabric 1.1 for Windows Server AppFabric 1.1 for Windows Server follows the Fixed Lifecycle Policy. Support Dates SUPPORT DATESListing Start Date Mainstream End Date Extended End Date AppFabric 1.1 for Windows Server Feb 11, 2012 Apr 11, 2017 Apr 12, 2022
... View more
Feb 01, 2022
05:23 PM
Thanks John, I will raise a case for this item as this is not what is appearing for us... example below
... View more
Jan 30, 2022
08:29 PM
Hi, Just wondering if anyone can tell me how to get the version information to the build level for ActiveState ActivePerl please? e.g. 5.10.1.1008 vs 5.10 appearing in the SW_Version field and or the Edition field updated with Community Edition vs Platform etc?
... View more
Jan 30, 2022
07:25 PM
It would be helpful if an indicator was available so we know if gap fill at the product or market version or minor version only is available for the product, so we don't bother you with these requests for backfill.
... View more
Jan 13, 2022
03:06 PM
Hi Deepa, How do we go about requesting a copy of the ERD for the BDNA_PUBLISH database please? And are there best practices and recommendations around how to establish a connection and extract the data please?
... View more
Nov 29, 2021
05:17 PM
I am looking to import a CSV into our data platform to populate database names against machines, I am thinking of keying on KEY-Hostname:Machine but I am worried about getting an error about duplicates. I am very new to FDP. I understand that there is a restriction around duplicate keying i.e. keying multiple times on the same hostname... I am thinking I need to generate a unique key on the source e.g. Hostname\ins1:Database1, but this still doesnt resolve that a single machine can have multiple databases on it. I am interested in if anyone else has attempted this and how you may have approached the resolution. Example Data: Hostname Instance Name Database Hostname1 Hostname1\INS1 Database1 Hostname1 Hostname1\INS1 Database2 Hostname2 Hostname2\INS1 Database3 Hostname3 Hostname3\INS1 Database4 Hostname3 Hostname3\INS2 Database5
... View more
Latest posts by ajwaterston
Subject | Views | Posted |
---|---|---|
255 | Nov 22, 2022 06:43 PM | |
336 | Mar 09, 2022 12:43 AM | |
432 | Feb 07, 2022 09:13 PM | |
352 | Feb 07, 2022 01:41 AM | |
442 | Feb 01, 2022 05:23 PM | |
511 | Jan 30, 2022 08:29 PM | |
527 | Jan 30, 2022 07:25 PM | |
897 | Jan 13, 2022 03:06 PM | |
402 | Nov 29, 2021 05:17 PM |
Activity Feed
- Kudoed Re: For Dummies instructions on how to connect PowerBI to FlexeraOne APIs as a data source for MurrayPeters. Nov 23, 2022 04:27 PM
- Posted For Dummies instructions on how to connect PowerBI to FlexeraOne APIs as a data source on Flexera One Forum. Nov 22, 2022 06:43 PM
- Posted Re: Private catalogue product to component mapping on Data Platform Forum. Mar 09, 2022 12:43 AM
- Posted Private catalogue product to component mapping on Data Platform Forum. Feb 07, 2022 09:13 PM
- Posted Microsoft AppFabric out of support date on Data Platform Forum. Feb 07, 2022 01:41 AM
- Posted Re: ActiveState Perl version information on Data Platform Forum. Feb 01, 2022 05:23 PM
- Posted ActiveState Perl version information on Data Platform Forum. Jan 30, 2022 08:29 PM
- Posted Re: Products in Technopedia without Version or Release Information on Data Platform Knowledge Base. Jan 30, 2022 07:25 PM
- Kudoed Re: How to export data from Data Platform for JohnSorensenDK. Jan 17, 2022 06:48 PM
- Posted Re: How to export data from Data Platform on Data Platform Forum. Jan 13, 2022 03:06 PM
- Posted Data Mashup: Multiple items to a Single Machine on Data Platform Forum. Nov 29, 2021 05:17 PM
- Kudoed Re: Mashup for penelopej. Oct 20, 2021 11:04 PM