Database table step functionality.

Unknown

Database table step functionality.

Unknown

Curious to know the functions of all of the database table steps in Integration -> Database -> LOCAL CONNECTION -> dbo.name.

Unknown

Hello,

A brief description of each step is as follows:

Count of:
Allows you to view a count of the objects in the table.

Delete from:
Allows you to delete objects from the table.

Exists in:
Allows you to check and see if an object exists at all within the table. The input value for the primary key is mapped to represent the object that is being checked.

Get all from:
Allows you to pull all objects from the table into the flow with a limit count if necessary. There are no filters to apply, this is a mass pull of data.

Get by ID from:
Allows you to pull an object into the flow from a table specified by the object name using the primary key.
Insert to:
Allows you to insert specified objects to the database table.

Selective update:
Allows you to update the data from a table that is specified by the data’s ID. For example, if you have a column called “FirstName” in the table, this step will allow you to map the value of “FirstName” to be updated within the table.

Update:
Allows you to update a mass amount of objects within the table. If you attempt to update only one field using this step, the data that wasnt filled will be set to null.

---

[i]edited by ryan@decisions.com on 5/1/2019[/i]