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

Hans Dollen

Freelance Senior / Lead Developer at Han(d)s on Development

+ 2

#1 033

in Community Rank

Integration

Implemented

on 01 Jan 2016

Development Environment 10.0.0.208

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 (4)

24 Feb 2014

Outsystem MVP, Outsystems Expert developer, Senior consultant at CoolProfs

+ 11

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 Senior / Lead Developer at Han(d)s on Development

+ 2

#1 033

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.