Integration Server 10.5 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services
 
Creating Database Flow Services
 
Generating a Database Flow Service from an SQL Statement
Generating a Database Flow Service from a Table
When you use the Integration Server Administrator to create flow services that access databases, you progress through a series of screens, selecting options and specifying information that indicates the function you want the service to perform. The server builds a flow service from the selections you specify.
The resulting flow service invokes the same built-in services that you can invoke from Java or C/C++. For more information about these services, see Built-in Database Services.
Using the Integration Server Administrator, you can create a flow service in one of the following ways:
*Generate from tables. You select the table that you want the service to access. Then, you select the database operation you want your service to perform (Select, Insert, Delete, or Update). The server displays the columns in the table that you can use to indicate the input that the service expects. When you use this option, the server automatically generates the required SQL statements. For more information, see Generating a Database Flow Service from a Table.
*Generate from an SQL statement. You specify the SQL statement that you want the service to perform. The SQL statement you specify can be more complex than the SQL statements the server generates when it generates a service from tables. In addition, you can specify database-specific SQL. Use this option if you want to use database-specific SQL that requires the fully qualified table names. For more information, see Generating a Database Flow Service from an SQL Statement.
Regardless of how you generate them, database flow services are all standard flow services. After a service is created, you can edit it using Designer in the same way you edit any other flow service. You can invoke the resulting database flow service from other services.
Note:
All generated database flow services call the pub.db:execSQL service. This service executes an SQL statement. If you want to change the SQL statement the flow service executes, open that service in Designer and change the $dbsql parameter in the INVOKE execSQL step in the flow.
Important:
Before you can use the Integration Server Administrator to build flow services, the server must have a configured database alias for the database that you want to access. The database alias must be configured when you create a service and when the server executes the service. For more information about how to configure a database alias, see Identifying Database Aliases.