The CData Excel Add-In for Epicor Kinetic models Epicor Kinetic objects as relational tables and views. A Epicor Kinetic object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to Epicor Kinetic APIs.

Schemas for most database objects are defined in simple, text-based configuration files.