Want to export everything to do some analysis on the data. Will we have to create a service/action for this and select all the datasources to get a hold of everything? And will this be very impactful for performance/crash the system?
There are several ways to achieve this depending on the use case. The fastest way is to enable GraphQL on the object classes, and just run a query to get all data in JSON format.
You may also create an action to export data , or create a table listing the data (with “download as csv” option) - both giving you csv files directly.