Integration Server 10.3 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services | Generating a Database Flow Service from a Table | Steps for Generating the Flow Service from a Table
 
Steps for Generating the Flow Service from a Table
Use the following procedure to generate a flow service from database tables.
*To generate a flow service from a table
1. Open the Integration Server Administrator if it is not already open.
2. On the Database menu, select Service Generation.
3. In the Source alias list, select the database you want the service to access.
4. In the Package list, select the package in which you want the service to reside.
5. In the Folder field, type the name of the folder in which you want to save the service.
6. In the Service field, type the name you want to assign to the service.
7. In the Execute ACL list, select the ACL group to which you want to limit access to the service. Only the users who are members of the groups in the selected ACL will be able to invoke the service.
8. If you want to overwrite any existing services with the same name as the new service, next to Overwrite Existing, select the Generated objects overwrite existing objects check box.
9. Click Generate from table. The server displays the Specify Connection Parameters screen.
10. Determine which tables you want to search by performing one of the following:
*To search all database tables, click Connect.
*To restrict your search, fill in one or more fields in the Restrictions parameters as follows, and then click Connect. For more information about how to restrict the search, see Restricting the List of Database Tables.
For this parameter...
Specify
Catalog
Catalog names whose tables you want to use. If you are not working with a distributed database, do not restrict by catalog.
Schema Pattern
Schemas whose tables you want to work with. If you want tables for all schemas in the selected database, do not restrict by schema pattern.
Table Name Pattern
Table name or a pattern-matching string that identifies the names of the table with which you want to work. If the default wildcard character “%” is specified, then every table name will match.
Table Types
Types of tables for which you want information.
After you click Connect, the server displays the Tables in DataSourceName screen.
11. In the Select a table section of the screen, click the table name that you want to use to generate the service.
12. In the Service type section of the screen, select the database operation that you want the service to perform (Select, Insert, Delete, or Update). The server displays the Columns in TableName screen.
13. In the Columns section of the screen, select the columns that you want to use as input parameters. When the service is executed, it expects input values for each of the columns you select. The service uses the input values as follows:
For this operation...
The service...
Select
Selects rows that have columns that match the input values.
Insert
Populates the columns of the inserted rows using the input values. If you want to populate all columns in the row, select all column names.
Delete
Selects rows that have the columns that match the input values and deletes the selected rows.
Update
Selects rows and updates them.
To identify the criteria to use to select rows, you check column names in the Criteria column. The service expects input values for each column name you check. The service selects rows that have columns that match the input values. If you want to select all rows, do not check any Criteria columns.
To identify the columns to update in the selected rows, use the Set column. The service expects input values for each column you check. The service sets the value of the checked columns (for all selected rows) to the specified input values.
14. Click Generate SQL. The server displays the Input Binding Generation screen.
If you selected any columns for input parameters, the server displays a Bind parameters section of the screen. There is one Parameter # field for each column you selected.
15. Use the Bind parameters section of the screen to identify the name and data type for each input parameter. Specify the following information:
For this parameter...
Specify...
name
The name that you want the service to use for the input parameter. By default, the server uses the database column name. If you want to use a different name, type the new name in this field.
type
The data type of the input value. By default, the server uses the data type that is associated with the database column. If you want to use a different data type, select it from the list.
16. Click Generate.