Camptocamp – Training

Talend Open Studio: data processing

Spatial extensions are data integration solutions, specialized in the manipulation of geographic information, based on Talend DI and coupled with the JAVA GeoTools and JTS libraries.

The use of an ETL (Extract Transform Load) provides numerous services for the handling and the treatment of complex attribute and/or geographical data. All operations are performed via a user friendly graphical interface.

A Java API can also extend existing controls to develop business-specific processing.

Goals

  • Understand the mode of the Talend Open Studio ETL
  • Know the features, characteristics and limitations of Spatial Data Integrator
  • Handle geographical data in SDI
  • Implement, debug and  deploy Jobs

Duration

  • 2 days

Targeted audience

  • GIS developers
  • GIS managers

Prerequisites

  • Good knowledge in geomatics

Program

  • Presentation of Spatial Data Integrator (ETL)
  • Installation
  • Introduction to data handling in SDI
  • Presentation of components
    • Overall presentation of SDI components
    • Presentation of geographic components
  • Implementation of jobs
    • Create of data sets
    • Understand patterns and metadata
    • Manage access to files and to databases (shapefiles, Mif/Mid, csv, xls, etc.)
    • Use geographical components to transform these data (calculations of area, zones, stamps, convexhull, centroids, envelopes, etc.)
  • Debugging, deployment and optimization
    • Quickly debug with tLogRow
    • Use the mode “statistics”
    • Execute step by step : mode trace
    • Use of the internal debugger
    • Manage execution contexts
    • Optimize Jobs (routines and snippets)

References

  • Agence de l’eau Adour Garonne (FR)
  • Ville de Châtellerault (FR)
  • Parc naturel régional de Lorraine (FR)
  • Pays Viennois (FR)

Dates and locations

  • Chambéry, Lausanne, Paris
  • Dates can be scheduled upon request (Lausanne, Paris, Toulouse or Chambéry).

Price

  • Upon request
  • Tax exempt if part of a convention

Reservation and contact

formation@camptocamp.com