Creating a Data Manipulator

Data Manipulator objects manipulate database data and structure using stored procedures or simple SQL statements when your database server or engine does not support stored procedures. Data manipulation actions are executed only on a per-request basis.

 

To Create a Data Manipulator:

  1. Open the Workbench. Expand your project folder, then the Data Connectivity node, then the Databases node.

  2. Expand your selected data connection node. For instance, in the example below, we are adding a Data Manipulator to the Northwind database found within the SQL Connections node. Right-click the Data Connection, then select Add Data Manipulator, as shown below.

Add Data Manipulator from Project Explorer

 

-OR-

 

Select the Data Connection, then click on the Add Data Manipulator button, shown below, in the Edit section of the Home ribbon in the Workbench.

 

Add Data Manipulator Button

  1. This opens the Data Manipulator properties window, shown below, in the right side of the Workbench. Enter a name for the Data Manipulator.

Data Manipulator Properties

See Also:

Connecting to Open Databases

Creating a Data Source

Creating a Data Item

Advanced SQL Designer

Databases Introduction