default datatype should be integer instead of decimal in integration studio (in oracle and foreign keys)

Hans Dollen

Freelance Developer Han(d)s on Development

+ 2

#524

in Community Rank

Integration

On our radar

The 'import entity wizard' of the integration studio can be enhanced.

The default datatype for Foreign Key Columns is decimal with 0 decimals instead of integer.

It would be far more efficient if the wizards set the datatype to integer if there are 0 decimals.

Further, it would be nice if the wizard sets the primary key as attribute identifier.

This would save a lot of time.

Created on 24 Feb 2014

Comments (2)

24 Feb 2014

Outsystem MVP, Outsystems Expert developer, Senior consultant CoolProfs

+ 9

in Community Rank

Tricky one.

I though it was mapped to Decimal, because the range of those Oracle-types are larger than the Outsystem-Integer type can hold(?)

Hans Dollen

17 Mar 2014

Hans Dollen

Freelance Developer Han(d)s on Development

+ 2

#524

in Community Rank

Hi Statler&Waldorf,

according to http://www.outsystems.com/help/integrationstudio/8.0/default.htm#Reference/Oracle_Data_Types_to_OutSystems_Data_Types.htm Oracle Number(2,0) up to and including Number(10,0) should be integer.

There are a few other mismatches:
Oracle Date is converted to Outsysystems Date, which is fine to me. But the documentation tells it shoud be converted to DateTime.

views

136

Followers