Managing User-Defined Functions in databases - Cloud

Talend Cloud Data Management Platform Studio User Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Management Console
Talend Studio
Content
Design and Development

The regular expression function is built in several databases, but many other databases do not support it. The databases that natively support regular expressions include: MySQL, PostgreSQL, Oracle 10g, and Ingres while Microsoft SQL server and Netezza do not, for example.

A different case is when the regular expression function is built in the database but the query template of the regular expression indicator is not defined.

From Profiling perspective of Talend Studio, you can:

  • extend the functionality of certain database servers to support the regular expression function; and
  • define the query template for a database that supports the regular expression function.