SHOW TABLES Summary The SHOW TABLES command returns a result set containing metadata for all tables found in the Connect environment. Syntax show tables; Parameters None. Details The SHOW TABLES res...

You can use Connect’s staging tables and INCENT commands to upload HR data into Incent. While each of these data types can be maintained by comp admins in the Incent […]

Load Data into Incent xSQL’s INCENT commands allow developers to manipulate data programmatically in the Incent application. INCENT commands can be invoked manually or added to scheduled steps a...

Create Schemas and Tables Data Definition Language (DDL) enables developers to create and manage Connect domain objects and tables. In this chapter, we’ll learn how to CREATE and DROP schemas [&hell...

Before we can load our Users into Incent, we must put them into the staging tables. There are three tables to populate.   NOTE: In our examples, we are using […]