Managing User-Defined Functions in databases - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

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:

To learn more about using regular expressions with Teradata, see the documentation on Using regular expressions with Teradata (https://help.talend.com).

For information about using regular expressions with Netezza, see What you need to know about some databases.