erwin Data Transformation 9.2.3 - User Guide

Veracode – READ APPLICATION LIST

Veracode – READ APPLICATION LIST

To use the adapter for Veracode, to read application list, fill the field “Web Service Home URL” with the Veracode URL you want to connect to. Then, provide a valid username/password to connect, or the API credentials (ID/KEY), that can be generated by a valid account.

Please, make sure that the account has the correct permissions to use Veracode API: https://help.veracode.com/reader/LMv_dtSHyb7iIxAQznC~9w/2nDnsqbBHfc2TPcl_Ps~KQ

The  button steps into the next window that shows the available operations of this Web Service; choose “READ APPLICATION LIST”, to get the list of application names and their Veracode ID.

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, not required for this operation.

Pressing the  button and a 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.

Veracode – IMPORT APPLICATION DATA

Veracode – IMPORT APPLICATION DATA

To use the adapter for Veracode, to import application data, fill the field “Web Service Home URL” with the Veracode URL you want to connect to. Then, provide a valid username/password to connect, or the API credentials (ID/KEY), that can be generated by a valid account.

Please, make sure that the account has the correct permissions to use Veracode API: https://help.veracode.com/reader/LMv_dtSHyb7iIxAQznC~9w/2nDnsqbBHfc2TPcl_Ps~KQ

The  button steps into the next window that shows the available operations of this Web Service; choose “IMPORT APPLICATION DATA”, to configure an adapter that can be used in a workflow to push application metadata to Veracode (see later).

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, not required for this operation.

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.

The Adapter, as mentioned, can be used to push data to Veracode and fill applications metadata. For example, if the application object type in Veracode has two custom fields named “Casewise ID” and “Development Manager”, the alignment can be done configuring a workflow, with a source providing values for the fields, and with the target operation “Web Service POST”, using the configured adapter. To provide mappings between source and target field, use a “Data Formatting: Rename and Order Columns” transformation, with the required “app_id” and “app_name” fields, and all others desired fields. Where “app_id” (numeric) value is null or 0, the application with provided name will be created, or updated, if an existing Veracode application with the same name already exists.

Zendesk – Get Tickets

Zendesk – Get Tickets

To use the adapter for Zendesk to get tickets, select the authorization method (Account / Access Token) and enter the relevant credentials.

Click the  button to proceed to the next step, and select the operation “Get Tickets”. Enter a name and folder for the adapter, and select the view from which to retrieve tickets. A description can also optionally be entered for the adapter.

Click the  button to proceed to the next step, where the adapter can be previewed and/or saved.

To preview a sample of the first 50 results, click the   button.

To save the adapter to the DT database, click the  button.

Zendesk – Create Tickets

Zendesk – Create Tickets

To use the adapter for Zendesk to create new tickets, select the authorization method (Account / Access Token) and enter the relevant credentials.

Click the  button to proceed to the next step, and select the operation “Create Tickets”. Enter a name and folder for the adapter. A description can also optionally be entered for the adapter.

Click the  button to proceed to the next step. To save the adapter to the DT database, click the  button.

The adapter can now be used as a target endpoint when mapping data in a workflow. To select the adapter as a target, select “Web Service POST” as the operation and select your Zendesk adapter. A mapping table will appear, allowing the source fields to be mapped to relevant target fields for creating Zendesk tickets.