Soliciting opinions: I want to extract a lot of data from NS as part of a divestment so the acquiring entity has all of sales / operational data etc. The acquirer will transform and load the data into their system, I don't need to care about that. Would you use ODBC to extract all of the target data or would you do it over SuiteTalk?

I would use ODBC because it's fast and probably easier than using SuiteTalk, unless you build or buy some additional tooling around SuiteTalk. Having said that, if it's a one time thing, it may not be worth the cost of adding ODBC. But if you already have it, the speed alone makes ODBC the best choice by far

We have ODBC. The next issue is that the business analysts are giving me the record names of what they want to extract, they are basing the names on what they see in the UI. ODBC (JDBC) tables names do not match the record names

could you consider CSV exports?

Nobody here knows the DB structure and I'm not sure how easy it is to find the data we want without knowing how the DB schema translates to the domain model / records.

commercial ETL tools should be able to handle CSV files but if you're using something commercial there may be other considerations (e.g. maybe their ODBC capability is more stable/capable than SuiteTalk, or visa versa)