- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Is there a way to extract the FNMS Compliance DB into a CSV or alternative format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
