Clay's Blog

Calem connector for Power BI enables fetching any table or view from Calem in R2026h (November 2026) so clients can create own dashboards. Work orders (cm_wo) are fetched from Calem to Power BI in the screenshot below.   Here are the steps to add data from Calem in Power BI Desktop. Go to Home | Transform dat...

Calem provides a connector to integrate with OPC/UA for sensors in the coming release of Calem R2025h (December 2025).  OPC/UA (Open Platform Communications – Unified Architecture) is a standardized way for industrial devices to publish data for other systems to use. Calem OPC/UA connector allows Calem to get sensor readings from equipment and...

Inventory unit costs can be synced from ERP to Calem via APIs. For instance, every month inventory unit costs in Calem are updated by an ERP system through Calem APIs. An inventory item may be merged to another item (screenshot below) if it is a duplicate. In this case the unit cost sync will fail for a merged ite...

MQTT (message queuing telemetry transport) is a protocol for communication with devices (IoT – internet of things). MQTT integration is available in the coming release of Calem R2024g (Jan. 2025).  Asset meter readings are taken by Calem via MQTT. The readings from MQTT can be viewed at Integration | Open | MQTT Queue 1. MQTT Brokers...

Upsert REST API will be available in the coming release of Calem R2024a. It is more intuitive than current data update APIs. A user may use the API to add or update a record in Calem, similar to the data upload utility (see this blog). A record data is provided to add to database.Calem will perform a database insertion first.If there are&...

API Logs are introduced in the coming release of Calem R2023d. They record errors and the data involved in APIs. For instance, a user is receiving a PO. The receipt is sent to a third party application (such as an ERP app). An error occurred from the third party app. The user contacted support. The support team can view the error and data invo...

This is the second installment of the best practices in Calem. It focuses on the integration support of Calem including data upload via excel and data dictionary for admin and integrators.  1. Bulk Create/Update in Excel Bulk data create and update can be done through excel for efficiency. See this blog: https://calemeam.com/calemcus...

Data integration can be enabled to exchange transactions between Calem and a third party application. For instance, an ERP integration is done for the following transactions. We will use the ERP as an example to discuss ways to pause integration and perform data maintenance in Calem. Integration Direction Transaction Calem to ERP Inventory Sto...

In the coming release of R21a, the Calem API has been extended to support the implementation of ERP (Enterprise Resource Planning solution) integration. Inventory integration is used as an example in this blog. Here is the data flow of the integration. Direction Object Calem to ERPRequisitions for spare parts created, and approv...

​In the coming release of R20d one can embed data fields in the service request emails. This feature may be used by 3rd party apps to integrate with Calem. It is an alternative to integration with Calem via REST API. The following is an email sample reporting an issue with an asset. // Email Subject: Routing device malfunction Ref#3359// Email Body...

​This is a summary of integration options available in Calem. They are organized into the following parts: API Integration - a third party application uses Calem REST API to integrate with CalemEvent Subscription - a third party application uses REST API to receive Calem data change eventsEmail Integration - Calem reads inbound emails to ...