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.
@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.
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.