NetSuite, a leading provider of ERP software, presents significant challenges with its API, characterized by complexity, poor documentation, and inconsistent naming conventions, making it difficult for companies to integrate with it effectively. Fivetran, recognizing these challenges, developed a NetSuite connector that addresses these issues by using the better-documented JDBC API, despite the arduous process involving extensive reverse-engineering and collaboration with customers. The development journey spanned several years and required innovative solutions to create a connector that delivers reliable and timely data, though some aspects remain imperfect. Fivetran's connector has become essential for companies facing difficulties with NetSuite's API, offering a solution to the classical engineering trilemma of balancing cost, speed, and scope, thereby saving companies the effort and frustration of developing their own solutions.