How to export data from Data Platform

[Narayanan]

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 ?

[ajeffries]

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. 

[Narayanan]

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.

[paul_meaders]

Is the schema for BDNA_Publish documented?  Or at least the structure for the most commonly used information types?

Thanks, Paul

[dsood]

HI Paul
Yes there is and we provide the Publish ERD upon request.

Thanks
Deepa

[MAFelder]

If an API cannot be used to extract the normalized data, is it possible to extract the normalized information to sharepoint list or excel

[dsood]

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.

[ajwaterston]

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?

[JohnSorensenDK]

@ajwaterston 

Please request the ERD through Flexera Support, i.e. please open a support case and request it.

Thanks,