Hi everyone! I'm looking at extracting our NetSuite data into a cloud data warehouse. My research so far has come up with a couple of options for extraction from NetSuite: • FiveTran (easy, but pricy?) • Analytics Connect ODBC/JDBC (will need to pay per month for this - need to build and maintain a script to be run as a cloud function?) • REST/SOAP API (no extra cost - need to build and maintain a script to be run as a cloud function?) We have custom fields, so I am unsure if this changes anything in terms of what those above can pull out? I'm sure a lot of people here have gone through this decision before, looking for any advice or tips from those that have travelled this road before! Much appreciated :)

FYI I don't think the FiveTran option (or similar tools) will work without buying Analytics Connect too. I could be wrong, but something to verify if you end up deciding to go that route.

ODBC would work by installing in your cloud warehouse environment and then performing sql queries to load data into your cloud warehouse.

Hey - good call RJMNS, I double checked the FiveTran documentation and you do indeed require Analytics Connect Service enabled. ChatGPT told me otherwise originally, another good reminder that it's best to link the latest documentation to any ChatGPT queries if possible so it has the latest information.

fwiw if you're looking at NS-specific questions and want to use AI, I'd probably use the AI in #C06V7S5E77Z since it's more tailored to NS stuff. It hasn't told me anything wrong...yet. But yeah definitely a good idea to always verify.

We are using integrator.io (Celigo) with JDBC connector for snowflake data warehouse pipeline