Use Scalar Functions Much like other RDBMS and ETL tools, you can use the scalar functions in xSQL to: In this chapter, we’ll show you a few examples. For a […]

Our first example is a query of our Opportunity table in SFDC. NOTE: Enter your own valid SFDC info (for the Salesforce.com TableName, UserName, and Password) to query your SFDC […]

Use conditional expressions to perform different computations or actions based on whether a boolean condition evaluates to true or false. To use conditional expressions within Connect’s xSQL statements and xCL […]

DELETE removes rows from tables. Use DELETE with WHERE to remove all rows that contain a matching field value. First, let’s see how many rows are in the table:   […]

UPDATE changes field values in a table. You can use it to make a simple, global change to that field, or use it with WHERE to make the change to […]

INSERT with a Value List Use INSERT statements with literal values to add new rows to a table. For example:   1 SQL> insert into staging.order_item(batch_name, order_code, item_code, incentive_date, amount) […]

Joins are useful for working with the intersections of different tables. Connect supports INNER and OUTER joins (RIGHT, LEFT, and FULL). For example, use an INNER JOIN to determine the […]

Connect does not have an explicit command for validating staging.user rows, but if an upload encounters any errors during execution, messages are written to the staging.user_exception table.   To confirm […]

Once our new HRMS data is in the Connect staging tables, we can upload it into Incent.   Upload staging rows into Incent:   1 SQL> incent synchronous upload users; […]

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 […]