NetSuite’s software had to adhere to international and industry-wide standards for data connectivity such as ODBC and JDBC. Additionally, the dev team at NetSuite also needed to ensure that the company’s software would keep current with the latest versions and features of those standards.
NetSuite determined that the best approach to address its customers’ data access requirements would be to partner with a third-party ISV specializing in data connectivity and product integration. The staff quickly narrowed the choice down to Progress® DataDirect® and the Progress DataDirect OpenAccess™ Software Development Kit (SDK).
Among the key factors driving the decision was the SDK’s compatibility with the latest industry connectivity standards and an array of implementations—some of them unique in the industry. “DataDirect was the only offering that provided a Java API to generic backend data sources,” notes a NetSuite project manager.
Explicitly designed to create custom APIs based on industry connectivity standards, OpenAccess SDK provides developers with as much as 90% of the code needed for each driver. This includes the extensive driver API specification compliance, the SQL calls and the network and server components required. It provides the ability to make anything—flat file data, proprietary data or a website— appear as a SQL database that application tools based on standard APIs know how to talk to.