Isn't JPA frameworks generate ANSI DDL? Not sure what you mean by JPA DDL. It may generate DDL using the source specific types. Please correct me if I understood your question wrong. The way I see it for defining the "source" models SQL DDL (create/alter) is sufficient, however to define the abstraction layer we need extensions to the DDL like SQL/MED to define the transformations. Defining what this can be is currently in discussion in a different thread in teiid-dev list. When we are done defining what this DDL looks like, we would need a DDL importer that can read the above format can represent the DDL is GUI and can write out same DDL with any modifications made back on to disk for consumption by Teiid runtime. As per the DDL importer didn't Teiid Designer already support a import DDL in its basic from from a text file? Ramesh.. ----- Original Message ----- From: "Barry Lafond" <blafond(a)redhat.com&gt; To: "teiid-designer-dev" <teiid-designer-dev(a)lists.jboss.org&gt; Sent: Tuesday, August 4, 2009 2:57:26 PM GMT -05:00 US/Canada Eastern Subject: [teiid-designer-dev] DDL Importer For Designer All, As we're working through assessing integration with other JBoss tools to reconstruct our XML story using annotated POJO's (i.e. Hibernate and JPA) it's become obvious that there will be a potential need in the not-to-distant future to create a DDL'ish importer that can translate Java objects into relational Designer model objects. So, if we needed an importer of DDL.... 1) What would it look like? 2) What flavor of DDL would we import? (i.e. is JPA-generated ddl sufficient?) Do we want to import "any" DDL and be able to ignore everything except "Create Schema/Table" and Alter statements? Barry _______________________________________________ teiid-designer-dev mailing list teiid-designer-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-designer-dev

There was a text file importer, may be it is not based on DDL but may be on another DSL. On Mon, 2009-08-10 at 12:50 -0500, John Verhaeg wrote:

On Tue, 2009-08-11 at 04:04 -0500, Ramesh Reddy wrote: The only DDL importer that I was aware of is the custom one we created for one of our federal customers. It may have been E-Space but the details elude me. -- Larry O'Leary <loleary(a)redhat.com&gt; Red Hat, Inc.