Software AG Products 10.7 | Integrating On-Premises and Cloud Applications | Service Development | Working with OData Services | Creating an OData Service | Creating an OData Service Using an External Source Type
 
Creating an OData Service Using an External Source Type
You use the Service Development perspective in Designer to create an OData service using an external source type and specify the entity types, external entity types, complex types, properties, and associations.
Before you create an OData Service using an external source, ensure that the selected OData enabled external source type is configured to Integration Server with a valid connection. For example, if you choose to use webMethods Adapter for JDBC as your external source provider, ensure that you create a connection in Integration Server for Adapter for JDBC.
*To create an OData service using an External Source Type
1. In the Service Development perspective, select File > New > OData Service.
2. In the New OData Service dialog box, select the folder in which you want to create the OData service.
3. In the Element name field, type a name for the OData service using any combination of letters, numbers, and/or the underscore character. For information about restricted characters, see Working with Elements
4. Click Next.
5. In the Select The Source Type screen, select External Source Type.
List of the available external source types appear.
6. Select the external source that you want to use as the external source type for the OData service. Click Next.
7. In the Select a Connection Alias screen, select the connection to use with the source type from the Connection Name list and click Next.
Designer retrieves the entity details from the database and displays it in the Select the Entity and Properties screen.
8. In the Select the Entity and Properties screen, select the entities that you want to include in your OData service. You can also change the Java Type for the entity selected.
Note:
If you go back to the previous screens and return to the Select the Entity and Properties screen, the entity list does not get refreshed. To get the new list of entities, start creating the OData service again.
9. Click Finish.
Designer creates the OData service and displays the details in the OData service editor. You can now add additional OData elements, specify properties, and define the association between the entity types.
*To add OData elements, see Adding OData Elements to the OData Service.
*To specify the properties of OData elements, see Adding Properties to the OData Elements.
*To define associations between OData elements, see Adding Associations to OData Elements.
10. Click File > Save to save the OData service.
Designer creates a folder with the same name as the OData service, with a prefix of an “_” (underscore). Inside this folder, Designer creates folders for each entity type. These folders contain OData service implementations that are named _insert, _retrieve, _update, and _delete can perform the create, read, update, and delete operations for each entity.
The signatures for the OData service implementations generated by Designer contain document variables generated using the entity types and its properties. You must not modify the signature of the generated OData service implementations. Also, Integration Server adds the processing logic to these services.