Add an External Function to an Existing Physical Data Service This page last changed on Feb 26, 2008. ## How To Add an External Function to a Existing Physical Data Service You can add qualified external operations (functions and procedures) from the same data source to existing physical data services based on: Relational Web service Java functions This is a very convenient way of enhancing a data service based on changes in underlying data or other business needs. The steps involved in adding an external function to a qualified data service are: Open the data service in Project Explorer. Select Overview mode. Right click > Add External Function... A wizard appropriate to the data service type will appear. Complete the steps as you would when creating a data service. For example, select from the set of currently unselected operations in the WSDL that underlies a web service-based data service. ##### Adding an External Function to a Data Service External operations cannot be added to physical data services based on: XML data Delimited data ##### Qualified Operation and Physical Data Service Type Matrix
Artifact | Physical Data Service Type | Comment
--- | --- | ---
Operation | Web Service | Only visible operations will be from the WSDL that underlies the physical data service.
Function | Java | Only functions from the Java class defined by the underlying data service will be visible.
Stored Procedure | Relational | Only stored procedures from the same data source defined by the underlying data service will be visible.
SQL Statement | Relational | Query must be to the same database as that underlying the data service.
### Additional Constraints Table-based functions cannot be added to data services. Only library operations can be added to library data services. Read or primary create-update-delete functions can be added to entity data services as long as the entity data services constraints are not violated.

Document generated by Confluence on Jan 13, 2009 15:57