The decision would be depending on what kind of data type would be supported on their Data Warehouse.
Data export in XML will provide all the ticket data at once.
APIs on the other hand has some limitation in terms of how much tickets can be fetched at a time and in total. Also, it has a minute-level rate-limit based on the account subscription plan.
If the API way is chosen, List Tickets API is better than Filter Tickets API as it will provide up to 300 pages compared to 10 pages in Filter Tickets API.
@Anoop_Chutkay Not sure if this way would include all the ticket data or just the activities info.
There could be other ways as well. It’s better to check with Freshdesk support (support@freshdesk.com) to discuss if there are any scalable alternative ways to export the ticket and conversation data apart from the options that we have discussed.