Apart from logging into the tool and exporting the data as csv, is there a way to use API or any other technology to have a direct connection with Data Platform server and export the normalized data ?
Nov 12, 2020 06:09 AM
There is currently no supported Data Platform API to export normalised data and therefore many customers use a database connection to query and export data from the BDNA_PUBLISH database. The database structure is cautiously managed due to this popular method of integrating data into downstream applications.
Nov 12, 2020 08:08 AM
SW data can into millions. Hence if the reporting tool has limitations in the number of rows it can export, we need have workarounds or alternate solutions to enable us to get the normalized data and i heard API call is the easiest way to extract data.
Nov 12, 2020 08:27 AM
Is the schema for BDNA_Publish documented? Or at least the structure for the most commonly used information types?
Nov 16, 2020 07:46 AM
Nov 16, 2020 10:00 AM
If an API cannot be used to extract the normalized data, is it possible to extract the normalized information to sharepoint list or excel
Nov 16, 2020 11:53 AM
There is an option to generate Results file when you setup the Normalize process in Admin Console . Once you run Normalize the normalized results are provided in this file which can be viewed via excel.
Nov 16, 2020 12:45 PM
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?
Jan 13, 2022 03:06 PM
Please request the ERD through Flexera Support, i.e. please open a support case and request it.
Jan 17, 2022 01:30 AM