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.
āAug 11, 2021 06:00 AM
@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.
āAug 11, 2021 06:20 AM
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
āAug 11, 2021 06:39 AM