Book a Demo

Author Topic: DDL generation does not map data types to ORA type  (Read 2301 times)

beez

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
DDL generation does not map data types to ORA type
« on: February 14, 2012, 02:02:36 am »
Hi

I generate DDL from a logical model where I have used the default datatypes available.
I _expect_ EA to be able to then make a transformation based on a target database (ORACLE in my case) when it generates the DDL.
It does not.
DDL only has the default datatypes...char etc. and does not map them to the Oracle data types which is really depressing.

If anyone knows how to set Oracle as the default DDL data type, i would be most grateful.  ;D

regards
beez

beez

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: DDL generation does not map data types to ORA
« Reply #1 on: February 14, 2012, 02:10:08 am »
I think I found it myself.

There is a mapping between data types for ORACLE and those defined in the logical model.
I just tested it out by defining a "datetime" attribute that then mapped to ORA Date.
This is therefore correct.

What is very weird, is when creating the attributes, the datetime type is not visible in the drop-down.
You need to type it in yourself.

This thread can therefore be closed, unless someone wants to comment on the abvove paragraph.

regards
beez ::)