2.2 SQL with PostgreSQL REST Communication Channel Advantages l Low-latency interaction with the AMR fleet. l Ad hoc access to DataStore values and job history data. l REST is independent from platform or language type. REST does not rely on specific drivers or libraries. REST Communication Channel Considerations l The RESTful API is hosted on the EM2100 appliance using port 8443. l The client needs to provide a JSON data format as input for all POST calls and may need a third party library to help create and process these strings. l The SSL is implemented with a self-signed certificate which the client needs to trust. l Most data entities can be accessed with the following paths: 1.
/Stream: opens up a connection to receive updates as the entity changes (real time). 2. /ByKey/{namekey} : returns entity information for entity with associated with the given namekey. 3. /UpdatedSince?sinceTime={time millis} : returns all updates of entities since l Certain data items are enumerated and correct syntax and schema of these items are time provided. A value of 0 can be used to get all updates (since epoch time). critical for proper functionality. Refer to the schema and examples in this document for details. NOTE: Audit (enumerated) items can be found in some schema examples. These are reserved items that are used internally for the oper- ation of the Integration Toolkit.
2.2 SQL with PostgreSQL The SQL communication channel is ideal when database-level interaction with the AMR fleet is necessary. PostgreSQL is a relational database management system where update, insert , select, and delete commands are used to monitor and control an AMR fleet. SQL Communication Channel Advantages l Database-level interaction with an AMR fleet. l Simple batch/bulk job creation. l Complex SQL querying against the entire job history. SQL Communication Channel Considerations l When any action is requested through the SQL channel, there may be a delay of up to 5 seconds because the table or view in question must be polled by the system.
l PostgreSQL is accessed using the standard port 5432. l Automation using the SQL communication channel is achieved through programming languages and associated libraries such as PostgreSQL JDBC driver for Java. When using the JDBC driver to connect, include the "sslmode=require" parameter in the con- nection URL like this: "jdbc:postgresql://[IP]/IntegrationDB?sslmode=require”. 12 Fleet Operation Workspace Core Integration Toolkit 20964-000 Rev. C User's Manual