EZOfficeInventory

EZOfficeInventory is an asset tracking and inventory management platform covering assets, stock items, check in and check out, locations, work orders, purchase orders and members. Replicating it into your warehouse lets operations and finance teams analyze asset lifecycle, maintenance and procurement alongside other business data.

Setup Instructions

Follow the setup steps guide for configuring your EZOfficeInventory connection to enable data to flow into your destination via DLH.

Supported Features

Here are key features supported for this connector.

Sync Feature	Supported	Details
Custom Data and Development	✓	Ability to enhance connector upon request
Historical Re-Load/Load	✓
Incremental/Delta Load	✓	Gets records created or changed since the previous sync
Column Selection	✓
Column Hashing	✓
Re-Sync Table/Entity	✓	Select at the table level to reload data history (on next Sync Bridge run)
Custom Queries		Utilizing SQL Data Query Connector
Custom Data
Captures Deleted Rows
API Sync Bridge Initiation	✓
Priority Scheduling	✓
Private VPC/Link	☂
DLH Data Model Available	-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

Without a Historical Start Date, the first synchronization reaches back three years for history, work orders, purchase orders and projects, and pulls all items, locations, members and other reference data in full. Every later synchronization pulls only the records created or changed since the previous one; many reference tables (for example locations, groups, vendors, members and teams) are reloaded in full each run. EZOfficeInventory allows a limited number of API requests per minute and DLH.io paces its requests to stay within that limit. Some modules, such as bundles, contracts and packages, depend on your plan and settings; tables for modules your account does not have are created empty and noted in the sync history. The connection is read only.

Be sure to also check the change log and notes page from time to time for any changes.

Issue Handling

If any issues occur with the connection simply return to the sources page in DLH.io, edit the source details and click the Save & Test button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.

Replicated Entities

The following 39 entities are replicated by default to your Target Connection. These are the table names you will see in your Target Connection. If you believe any entities/tables are missing please open a ticket with Customer Support:

ASSETS
ASSET_STOCKS
INVENTORY
BUNDLES
ITEM_CUSTOM_FIELDS
ASSET_HISTORY
ASSET_RESERVATIONS
ASSET_COMMENTS
ASSET_STOCK_HISTORY
INVENTORY_HISTORY
ITEM_LOCATION_THRESHOLDS
ITEM_DOCUMENTS
LOCATIONS
LOCATION_ITEM_QUANTITIES
GROUPS
GROUP_DEPRECIATION_RATES
SUB_GROUPS
DEPRECIATION_METHODS
VENDORS
CONTRACTS
RETIRE_REASONS
PACKAGES
PROJECTS
MEMBERS
MEMBER_ADDRESSES
TEAMS
CUSTOM_ROLES
USER_LISTINGS
WORK_ORDERS
WORK_ORDER_CUSTOM_FIELDS
WORK_ORDER_WORK_LOGS
WORK_ORDER_LINKED_INVENTORY
LINKED_WORK_ORDERS
WORK_ORDER_TYPES
CHECKLISTS
PURCHASE_ORDERS
PURCHASE_ORDER_LINE_ITEMS
PURCHASE_ORDER_DOCUMENTS
CARTS

Schema Details (ER Diagram)

This entity relationship diagram (ERD) provides you with information about what entities/tables DLH provides for you out-of-the-box and how they are related to one another.