Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there a way to extract the FNMS Compliance DB into a CSV or alternative format

Good day Forums

Is there a way to extract the FNMS Compliance DB into a CSV or alternative format? We are looking at adding the data onto our  Big Data Platform.

Your assistance is much appreciated.

0 Kudos

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

2 Replies
kclausen
Flexera Alumni

@IronManMK10 - Assuming that you have FNMS On-Premises, you would need to create/write the appropriate SQL Scripts against the Compliance Database to extract the data that you want to import into Big Data.

0 Kudos
mfranz
Level 16 Champion
Level 16 Champion

Hi,

Before actually exporting any data, you should gain an understanding of what data you'll need, where to get it, how to insert/update/delete it. You should develop a basic understanding of your Big Data Platform and the FNMS schema/object model.

Depending on what your are planing to  do, the FNMS Data Warehouse database might be more interesting, because it holds historic data.

CSV files are a terrible idea for data transfer, especially around date/time fields. A direct data connection, if possible, would be faster and less of a media disruption.

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos