Skip to Content
0

Netezza datatype

Feb 15 at 08:43 AM

51

avatar image
Former Member

Hello,

We are in the processing of migrating from Netezza DB to Oracle Exadata DB.

We are trying to reverse engineer Netezza Db tables ( Create PDM) and ultimately generate Oracle PDM and generate DDLs.

Some of the Datatypes like Varchar(n) and CHAR(n) are not converting properly during reverse eng

Varchar(n) is coming up as CHARACTER VARYING(n)

CHAR(n) is coming up as CHARACTER(n).

NVARCHAR(n) is coming up as NATIONAL CHARACTER VARYING(n).

We are using powerdesigner 16.6 and Netezza 7.x

Can anyone please advise?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 18 at 06:33 AM
0

Thanks McGeachie for your response. I will change DataType conversion ( Target to internal, internal to Target) as per suggestion. I will update the progress if it helps in anyway.

Share
10 |10000 characters needed characters left characters exceeded
George McGeachie Feb 15 at 11:02 AM
0

This will result from applying the data type conversions defined in the Database definitions

  1. when reverse-engineering from DB, Netezza data types are converted into PowerDesigner internal data types
  2. when you change the DBMS to Oracle (or, hopefully, generate an Oracle PDM from the Netezza PDM), internal data types are converted into Oracle data types

The data type conversions are defined in the database definition files, which you can edit (please, edit a copy) under DBMS\Script\Data Type. In PowerDesigner Help, search for "Script/Data Type Category".

Please report back - if you think that the data type conversions are nuts, please tell SAP :)

Share
10 |10000 characters needed characters left characters exceeded