Listing all Amazon SQS queues in an AWS region - 7.0

Amazon SQS

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Amazon services (Integration) > Amazon SQS components
Data Quality and Preparation > Third-party systems > Amazon services (Integration) > Amazon SQS components
Design and Development > Third-party systems > Amazon services (Integration) > Amazon SQS components
EnrichPlatform
Talend Studio
Configure the tSQSQueueList component, the tIterateToFlow component, the tLogRow component, and the tJava component to list the URLs of all Amazon SQS queues in an AWS region and display the total number of the queues in the region on the console of Talend Studio.

Procedure

  1. Double-click the tSQSQueueList component to open its Basic settings view.
  2. Specify the connection details required to access Amazon SQS. In this example, select the Use an existing connection check box and from the Component List drop-down list displayed, select the connection component to reuse its connection details you have already defined.
  3. Double-click the tIterateToFlow component to open its Basic settings view.
  4. Click the button next to Edit schema to open the schema dialog box.
  5. Click the button to add one String type column CurrentQueueURL that will hold the URLs of the queues to be listed. When done, click OK to close the dialog box.
  6. In the Mapping table, set the value for the CurrentQueueURL column. In this example, the value is set to ((String)globalMap.get("tSQSQueueList_1_CURRENT_QUEUE_NAME")), which is the value of the global variable CURRENT_QUEUE_NAME for the tSQSQueueList component.
    Note that you can fill the value by pressing Ctrl + Space to access the global variables list and then selecting tSQSQueueList_1_CURRENT_QUEUE_NAME from the list.
  7. Double-click the tLogRow component to open its Basic settings view, and then select Table (print values in cells of a table) in the Mode area for better readability of the result.
  8. Double-click the tJava component to open its Basic settings view.
  9. In the Code field, enter the following code to display the total number of the queues in the region.
    System.out.println("The number of queues: " + ((Integer)globalMap.get("tSQSQueueList_1_NB_QUEUE")));