August 15, 2023

tAddLocationFromIP – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. tAddLocationFromIP – Docs for ESB 6.x

tAddLocationFromIP

Replaces IP addresses with geographical locations.

tAddLocationFromIP geolocates visitors through their IP addresses:
this component identifies visitors’ geographical locations (country, region, city,
latitude, longitude, ZIP code, etc.) using an IP address lookup database file.

tAddLocationFromIP Standard properties

These properties are used to configure tAddLocationFromIP running in the Standard Job framework.

The Standard
tAddLocationFromIP component belongs to the Misc family.

The component in this framework is generally available.

Basic settings

Schema and Edit
schema

A schema is a row description, it defines the fields to be processed and passed on to
the next component. The schema of this component is read-only.

 

Built-in: You create and store
the schema locally for this component only. Related topic: see

Talend Studio User
Guide.

 

Repository: Select the Repository
file where Properties are stored. When selected, the fields that
follow are pre-defined using fetched data.

Database Filepath

The path to the IP address lookup database file.

Input parameters

Input column: Select the input
column from which the input values are to be taken.

 

input value is a hostname: Check
if the input column holds hostnames.

 

input value is an IP address:
Check if the input column holds IP addresses.

Location type

Country code: Check to replace IP
with country code.

 

Country name: Check to replace IP
with country name.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level
as well as at each component level.

Global Variables

Global Variables

NB_LINE: the number of rows processed. This is an After
variable and it returns an integer.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see
Talend Studio

User Guide.

Usage

Usage rule

This component is an intermediary step in the data flow allowing
to replace IP with geolocation information. It can not be a start
component as it requires an input flow. It also requires an output
component.

Limitation

Due to license incompatibility, one or more JARs required to use this component are not
provided. You can install the missing JARs for this particular component by clicking the
Install button on the Component tab view. You can also find out and add all missing JARs easily on the
Modules tab in the
Integration
 perspective of your
studio. You can find more details about how to install external modules in Talend Help Center (https://help.talend.com).

  • geoip.jar

Scenario: Identifying a real-world geographic location of an IP

The following scenario creates a three-component Job that associates an IP with a
geographical location. It obtains a site visitor’s geographical location based on its
IP.

Dropping and linking components

  1. Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tAddLocationFromIP, and tLogRow.
  2. Connect the three components using Row
    Main     links.

    Use_Case_tAddLocationFromIP.png

Configuring the components

  1. In the design workspace, select tFixedFlowInput, and click the Component tab to define the basic settings for tFixedFlowInput.
  2. Click the […] button next to Edit Schema to define the structure of the data
    you want to use as input. In this scenario, the schema is made of one column
    that holds an IP address.

    Use_Case_tAddLocationFromIP2.png

  3. Click OK to close the dialog box, and
    accept propagating the changes when prompted by the system. The defined
    column is displayed in the Values panel of
    the Basic settings view.
  4. In the Number of rows field, enter the
    number of rows to be generated, and click in the Value cell and set the value for the IP address.

    Use_Case_tAddLocationFromIP1.png

  5. In the design workspace, select tAddLocationFromIP and click the Component tab to define the basic settings for tAddLocationFromIP.

    Use_Case_tAddLocationFromIP3.png

  6. Click the Sync columns button to
    synchronize the schema with the input schema set with tFixedFlowInput.
  7. Browse to the GeoIP.dat file to set its
    path in the Database filepath field.

    Note:

    Ensure to download the latest version of the IP address lookup
    database file from the relevant site as indicated in the Basic settings view of tAddLocationFromIp.

  8. In the Input parameters panel, set your
    input parameters as needed. In this scenario, the input column is the
    ip column defined earlier that holds an IP
    address.
  9. In the Location type panel, set location
    type as needed. In this scenario, we want to display the country
    name.
  10. In the design workspace, select tLogRow
    and click the Component tab and define the
    basic settings for tLogRow as needed. In
    this scenario, we want to display values in cells of a table.

Saving and executing the Job

  1. Press Ctrl+S to save your Job.
  2. Press F6 or click Run in the Run tab to
    execute the Job.

    Use_Case_tAddLocationFromIP4.png

One row is generated to display the country name that is associated with the set
IP address.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x