Skip to main content
SUBMITTED

Expand "override data type" functionality in ODX

Related products:TimeXtender Data Integration
  • June 26, 2023
  • 0 replies
  • 25 views

Forum|alt.badge.img+2

My client has a data source where all the string fields have data type char.

They would like to change the data type to varchar for all those fields, but keep the original character length limit. I.e. char(10) → varchar(10), char(255) → varchar(255).

To do it in the current version of the ODX they would either have to create one rule per data type which is not feasible, or convert the fields to a large enough varchar that all the char fields would fit which is not optimal.

They would like to have a feature where they can set that char(X) → varchar(X):