IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > JDBC > Configure the module for deployment > Configure the module for outbound processing
Completing the configuration
In some situations, manual configuration steps are needed to complete the configuration of your business objects.
Perform this task when you need to customize the artifacts generated by the wizard. You might do this in the following situations:
- To set the CopyAttribute parameter for a column so that its value is set to the same value as another column.
- To remove attributes from a business object.
For example, you can simplify your business object design by removing the simple attribute corresponding to any database column that you do not need to reference.
- To add attributes to a business object.
For example, when you run the discovery process against a table in either a DB2 or Microsoft SQL Server database, and that table defines a column as an identity column, the generated business object for that table does not include the Unique Identifier attribute. Because the adapter needs the Unique Identifier of the identity column at run time, you must add it to the attribute application-specific information. In this case, you add <UID>AUTO</UID> to the attribute application-specific information. For the Oracle database, specify the sequence name to UID in order to define a field as an auto-generated field since Oracle does not support identity column.
You need not make similar changes to a table business object if you generated it from an Informix database. When you run the discovery process against a table in an Informix database, and that table defines a column as serial (identity columns are referred to as serial columns in Informix), the resulting business object does include the Unique Identifier attribute for the serial column. Therefore, you need not edit the business object application-specific information. The generated value of the Unique Identifier parameter for a serial column in an Informix database table is either serial or serial8.
- To configure additional parents for a table business object that has multiple parents. The wizard configures only one parent for a table business object.
This topic provides detailed instructions for setting the CopyAttribute parameter to a table business object. Other changes to business object structures, such as the changes mentioned above, can be accomplished using similar techniques.
The CopyAttribute parameter is contained in the properties of the attribute for the column that you want to populate with values and application-specific information from another column.
For example, if you want the contact column of a new row in the table to contain the same value as the e-mail column, set the CopyAttribute parameter of the contact attribute to e-mail. You use the assembly editor in IBM Integration Designer to set the value.
Procedure
- In the Business Integration perspective in IBM Integration Designer, expand the module name, expand Data Type, and then locate the table business object. The business object name is the name of the database schema plus the name of the database table. An optional namespace might be included at the beginning of the name.
- Right-click the business object name and select Open. The assembly editor displays the business object, which has a field for each column.
- In the assembly editor, select the column you want to set to match another column.
- In the Properties view, select Application Info. If the Properties view is not visible, right-click the column name and click Show in Properties.
- Expand JDBC ASI schema, and then expand JDBCAttributeTypeMetadata.
- Right-click JDBCAttributeTypeMetadata and then select New > jdbcasi:CopyAttribute.
- Select the CopyAttribute property.
- In the Extension Details area, set the text value to the name of the column that contains the information to copy. The column can be in the current business object or its parent business object. To copy from a column in the current business object, set the value to the column name, for example, phoneid. To copy from a column in the parent business object, prefix the column name with two periods (..), for example, ..phone. The following figure shows the assembly editor with the CopyAttribute property set to a column in the current table.
Results
The business object is configured to use the CopyAttribute property to set the business object attribute and properties for a database column based on information in another column.
What to do next
You can now test and deploy the module.
Configure the module for outbound processing
Previous topic: Setting deployment properties and generating the service