Using the OData plugin
Note that the plugin is available only as a Transformation step; it is not available as a Job plugin.
Procedure
- To start Spoon, navigate to your Kettle directory and run spoon.bat.
- Create a new Transformation (File >
New >
Transformation).
- In the
Design tab, select the
Alterian category, then select the
Import from OData plugin and drag it to the transformation panel.
- In the
Design tab, select the
Output category.
- Select the
Text file output step and drag it to the transformation panel.
- Link the
Import from OData input step to the
Text file output step.
- Open the OData plugin to configure its settings.
- On the
General Settings tab, enter the server location and login information required to access the OData source.
- Click the
Test button to ensure the login credentials are correct.
- Click the
Get Data button to retrieve all the OData resources.
- Select a resource from the
Resource drop-down.
- In the
Fields tab, click the
Get Fields button.
- Click
OK and save the transformation.
- Configure the downstream text file output step to correctly process the OData data.
|
|