How can I get data from D2000 Archive into another application?

Support Forum
#1

For various analyses, we would need to get data from the D2000 archives into a third-party program. What options do we have?

#2

D2000 Workbook - interface for Excel for interactive work. It also allows access to historical data:
https://doc.ipesoft.com/display/D2DOCEN/D2000+WorkBook
reading historical data
https://doc.ipesoft.com/label/D2DOCEN/d2000_wb_archiv

JAPI - access from Java
https://doc.ipesoft.com/display/D2DOCSK/JAPI
reading historical data
https://doc.ipesoft.com/display/D2DOCSK/6.+Data+API

ObjAPI - library for access from C-compatible programs
https://doc.ipesoft.com/display/D2DOCEN/D2000+OBJApi
including historical data
https://doc.ipesoft.com/display/D2DOCEN/GetArchivData

REST API - access via SmartWeb, also historical data
https://doc.ipesoft.com/display/D2DOCEN/D2000+REST+API

OpenAPI - Not yet documented :frowning:
Unlike SmartWeb, this is an RPC interface, so reading data must be implemented in ESL (it’s a few lines of code)

and of course, it can also be done in an ESL script, where one can:

  • read data from an archive and put it into CSV/XML files
  • read data from an archive and write it into an interface table in some SQL database, with an agreed format