Using the OData plugin

Note that the plugin is available only as a Transformation step; it is not available as a Job plugin.

Procedure

1. To start Spoon, navigate to your Kettle directory and run spoon.bat.
2. Create a new Transformation (File > New > Transformation).
3. In the Design tab, select the Alterian category, then select the Import from OData plugin and drag it to the transformation panel.
4. In the Design tab, select the Output category.
5. Select the Text file output step and drag it to the transformation panel.
6. Link the Import from OData input step to the Text file output step.
7. Open the OData plugin to configure its settings.
8. On the General Settings tab, enter the server location and login information required to access the OData source.
9. Click the Test button to ensure the login credentials are correct.
10. Click the Get Data button to retrieve all the OData resources.
11. Select a resource from the Resource drop-down.
12. In the Fields tab, click the Get Fields button.
13. Click OK and save the transformation.
14. Configure the downstream text file output step to correctly process the OData data.

• OData Plugin
  • Using The OData Plugin