Configure a Data Access activity
- Add a Data Access activity to the map. See Add an activity.
- On the Extended Properties page, click the Configuration tab.
-
To specify the database connection string to hold the details of
the relational database,
consume the connection string in the
Connection String box.
-
The connection string is case sensitive.
-
You can whitelist a database connection string. If Allow All in the system settings is set to No, you can only use the whitelisted database connection strings. See Configure the server URLs and database connection strings.
-
-
Click
Configure to create a
query. See
Create a DB query.
The generated query appears in the Query box and a list of result parameters based on the query appears under Output Parameters.
-
Map all the output parameters with the relevant variables.
ODBC and OLEDB do not support xml data type.
-
Map the ResultSet and the RowsReturned output parameters with the
dynamic complex and long variables respectively as follows:
- Create a dynamic complex, and a long process variable. See Create process variables.
- Consume the complex variable in the Value box of the ResultSet parameter.
- Consume the long variable in the Value box of the RowsReturned parameter.
- Click Save.