erwin Data Transformation 9.2 - User Guide

Test Web Service Parameters

Test Web Service Parameters

Before saving the Web Service adapter, the user can test it. Pressing the  button will open a new pop-up window and the XML SOAP response resulting from the Web Service call is listed.

The  button closes the data preview window and goes back to Web Service configuration form.

If you have not saved before testing the Web Service Configuration, remember to press the  button, before leaving the parent window and all the entered parameters will be stored into the DT databases.

Add or Modify REST/others Web Service Adapter

Add or Modify REST/others Web Service Adapter

To create a new adapter just press the , and select “REST/Others Web Service” in the following popup:

To modify an existing adapter selected from the list, press the . An editing window pops up.

BMC Discovery

BMC Discovery

To use the adapter for BMC Discovery, fill the field “Web Service Home URL” with the SmartSheet home page URL you want to connect to. Then provide the username and password for a valid BMC Account or an access token to connect. To generate an access token, please refer to BMC Discovery System Administrator

The  button steps into the next window that shows the available operation of that Web Service, which is “QUERY DATA”, allowing users to query all data stored in the repository

After selecting the desired operation, it is required to enter a name and a description for the adapter in the appropriate fields; the user must browse the file system for the adapter folder (used to save intermediate and result file for adapter execution).

The next button  steps into the next window that allows the user to set values for the Web Service parameters.

Pressing the  button will open a new pop-up window. The response resulting from the Web Service call is displayed.

Pressing the  button will store all the entered parameters for the web service adapter in the DT database.

The  button closes the data preview window and goes back to Web Service configuration form.

RSA Archer – VIEW REPORT

RSA Archer – VIEW REPORT

To use the adapter for RSA Archer, to read report contents, fill the field “Web Service Home URL” with the RSA URL you want to connect to.

Then, provide a valid instance URL and username/password to connect.

The  button steps into the next window that shows the available operations of this Web Service; choose “VIEW REPORT”, to query data as per RSA report definition.

After selecting the desired operation, it is required to enter a name and a description for the adapter into the appropriate fields; the user must browse the file system for the adapter folder (used to save intermediate and result file for adapter execution).

The next button  steps into the next window that allows the user to set values for the Web Service parameters.

When a lens icon shows beside the parameter name:

this means that user may set the parameter value from a list of available items.

In the case of the RSA Archer “View Report” operation,  double-click on the lens icon besides “reportIdOrGuid” parameter, a popup appears, with the available reports to query:

Select and apply the selection, and the desired report GUID fills the parameter value:

Should the provided account not be granted to read system tables (such as the one containing the list of user tables) the popup will be blank, but the parameters can always be manually filled.

Pressing the  button and a new pop-up window is opened and the response resulting from the Web Service call is displayed.

Pressing the  button will store all the entered parameters for the web service adapter in the DT database.

The  button closes the data preview window and goes back to the Web Service configuration form.