Wrong datatypes in reverse engineering with postgreSQL database

[stefgou]

Hello,

[HOPEX V2R1 U03.02]

I'm trying to realise a reverse engineering with postgreSQL database, and i have problem with datatypes recognition.

I declared a database with PostgreSQL9.3 as target DBMS.

I use the Hopex Data Extractor Utility to obtain an XML export.

Here an extract of the XML :

<COLDATATYPE NameId="COLDATATYPE.a095role095profil.arp095id" DataType="SQL_CHAR" TypeTech="SQL_PostgreSQL9.3integer"/>

At the end of the reverse enineering, when i consult the objects created, all the columns of the tables are datatyped "char", wich not correspond to the database datatypes (integer in the example) :

"Relier Colonne 'arp_id' à 'P-Character Pivot::P-Character' par le lien [Colonne.Datatype]"

Have you a solution to correct this ?

Thanks.

[stefgou]

OK, i I managed to recover the correct datatypes by modifying the file XMDB.XDR.

[jhorber · Accepted solution]

Hello

This may be related to the ODBC driver used

Check in the XML file the value for the property DataType. 

Check the pivot class for this DataType in XMDB.XDR 

Check the rule computing the property 'data type' from pivot class, target DBMS...

See also

https://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=50120000000mqWSAAY

https://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=50120000000mqY7AAI