1. Create First Data Services Cheatsheet This page last changed on Mar 17, 2008. .stickable, h1, h2, h3, h4, h5 false true Show Sticky notes Hide Sticky notes Save Cancel Oracle Data Service Integrator Documentation > Data Services Developer's Guide # Create First Data Services Cheatsheet If you'd like to create your first data services in less than 15 minutes, follow these abbreviated steps: Create a new dataspace project called:
       myDataspace
2. Under it create folders named `logical` and `physical` Under physical:
       New > Physical Data Service
7. Choose Relational Select `dspSampesDataSource` as the data source. Select `RTLAPPLOMS` and `RTLCUSTOMER` Next. Mark all operations
       Public
8. Next Set common Namespace to:
       custOrdersItems
11. Next Finish No to the question about opening all the new data services. Click the `logical` folder
        New > Logical Data Service
12. Call the data service:
        CUST_ORDERS_ITEMS
1. Click Finish. Add an operation and name it: `custOrdersItemsByCustID` `Click OK.` {{Click on the name of the new operation to enter the Query Map. }} Drag the Read operations from the following to the work area: CUSTOMER.ds CUSTOMER_ORDER.ds CUSTOMER_ORDER_LINE_ITEM.ds Edit the signature to Add a string parameter named:
       last_name
1. Click OK twice. Click Overwrite mode. Drag, then expand in the following order: CUSTOMER* CUSTOMER_ORDER* CUSTOMER_ORDER_LINE_ITEM* Map the Zone icons to the respective element in the Return type: CUSTOMER_ORDER* CUSTOMER_ORDER_LINE_ITEM* Create the following joins:
   Source and element | Target and element
   --- | ---
   $CUSTOMER/CUSTOMER_ID | $CUSTOMER_ORDER/C_ID
   $CUSTOMER_ORDER/ORDER_ID | $CUSTOMER_ORDER_LINE_ITEM/ORDER_ID
5. Associate the custID parameter with the CUSTOMER/CUSTOMER_ID element. From the Return type, Save and Associate XML type. Change the `CUSTOMER` name to {CUST_ORDERS_ITEMS}}. Modify your new CUST_ORDERS_ITEMS XML Type: Click on the Overview tab, if it is not already selected. Right-click on the topmost element in the XML type: CUST_ORDER_ITEMS. Select Edit Schema. The Eclipse schema editor opens. Click the schema editor's Source tab (below the editor's work area). Locate the first qualified element: CUSTOMER_ORDER. Place your cursor where you want to add the statement (just before the closing angle bracket at the end of the line) Enter a space. Activate the code assistant with the combination: Ctrl + spacebar You will get a code completion dialog. Perform the Ctrl+space operation twice, once for the max_occurs, and again to add the unbounded statement. The line now appears as:
F I X Follow Steps 5-9 for the second qualified element, CUSTOMER_ORDER_LINE_ITEM. Save the CUST_ORDERS_ITEMS.xsd file. File > Save

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