How to export data from Data Platform
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 ?
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.
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.
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.
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?