Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » [Teneo] newbie question: Using Teneo with Existing Database
| | |
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #113118 is a reply to message #113091] |
Mon, 25 February 2008 06:53 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Hi Torsten,
Ha, okay, Teneo will create additional columns for the following cases:
- econtainer relations (can be disabled using an option)
- id and version columns (if the types don't have those, can be controlled/disabled by options)
- index columns in list elements (can be disabled using options/annotations)
So overall I think you should be able to get very far in disabling emf/teneo specific columns. And
if you still encounter an issue then I am prepared to look at it and incorporate it in a new build.
See the options page for more details:
http://www.elver.org/hibernate/options.html
Also this page maybe of interest (to control naming of tables/columns/foreign keys):
http://www.elver.org/hibernate/extensions.html
gr. Martin
Torsten Link wrote:
> Hi Martin,
>
> there is a missunderstanding. I would like to know if it is possible
> to use TENEO with a existing database which could not be modified.
> When I first generate the EMF Model and then let TENEO generate the database
> there are several emf or teneo specific columns in the table. But in my
> existing database these columns are not there.
>
> And before I start learning TENEO and Hibernate I would like to ensure
> that it will lead to something usefull.
>
>
> Thanks
>
>
> Torsten
>
>
> Martin Taal wrote:
>
>> Hi Torsten,
>> No there are no reverse engineering tools for Teneo. It is an interesting
>> topic though. However afaics reverse engineering from a db (for Teneo)
>> would also require tools for reverse engineering a db schema to the emf
>> model. As (afaics) the emf objects should be based on the relational
>> schema. So a relational schema to ecore translator would be the first
>> step.
>>
>> Ed (as you are back from holiday!), have you before seen this
>> requirement/idea of generating an ecore model on the basis of the db
>> relational schema?
>>
>> gr. Martin
>>
>> Torsten Link wrote:
>>> Hi all,
>>>
>>> I would like to know if ist is possible to use Teneo with an already
>>> exsiting Database.
>>> The Database is from a comercial application so it could not be altered.
>>> I would like to extract some of the data and modify it within an EMF
>>> Application.
>>>
>>> For Hibernate there are existing tools for reverse engeniering, but
>>> it does not fit to EMF ot TENEO.
>>>
>>>
>>> with kind regards
>>>
>>>
>>> Torsten Link
>>>
>>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #113235 is a reply to message #113118] |
Mon, 25 February 2008 18:03 |
Jason Henriksen Messages: 231 Registered: July 2009 |
Senior Member |
|
|
Hello Torsten,
My client is a large health insurance firm. We are using EMF/Teneo on a
legacy database with ZERO modifications to the underlying database. You
do have to handle a couple of things in a slightly strange manner, but
so far we haven't found anything we cannot overcome. Mostly the
difficulty depends on how strange your legacy DB is. (We had some very
odd ball things in our database, but we've still made it work)
Also, I wrote a small script which turns SQL DDL calls into annotated
XSD. It works very well and only took a couple of days to write. If
you have a large number of tables to map, this can save a lot of work
since the script doesn't make any typos.
Hope that helps. Let me know if you have any specific questions and
I'll tell you if I've run into them yet.
Jason Henriksen
Martin Taal wrote:
> Hi Torsten,
> Ha, okay, Teneo will create additional columns for the following cases:
> - econtainer relations (can be disabled using an option)
> - id and version columns (if the types don't have those, can be
> controlled/disabled by options)
> - index columns in list elements (can be disabled using
> options/annotations)
>
> So overall I think you should be able to get very far in disabling
> emf/teneo specific columns. And if you still encounter an issue then I
> am prepared to look at it and incorporate it in a new build.
>
> See the options page for more details:
> http://www.elver.org/hibernate/options.html
>
> Also this page maybe of interest (to control naming of
> tables/columns/foreign keys):
> http://www.elver.org/hibernate/extensions.html
>
> gr. Martin
>
> Torsten Link wrote:
>> Hi Martin,
>>
>> there is a missunderstanding. I would like to know if it is possible
>> to use TENEO with a existing database which could not be modified.
>> When I first generate the EMF Model and then let TENEO generate the
>> database
>> there are several emf or teneo specific columns in the table. But in my
>> existing database these columns are not there.
>>
>> And before I start learning TENEO and Hibernate I would like to ensure
>> that it will lead to something usefull.
>>
>>
>> Thanks
>>
>>
>> Torsten
>>
>>
>> Martin Taal wrote:
>>
>>> Hi Torsten,
>>> No there are no reverse engineering tools for Teneo. It is an
>>> interesting
>>> topic though. However afaics reverse engineering from a db (for Teneo)
>>> would also require tools for reverse engineering a db schema to the emf
>>> model. As (afaics) the emf objects should be based on the relational
>>> schema. So a relational schema to ecore translator would be the first
>>> step.
>>>
>>> Ed (as you are back from holiday!), have you before seen this
>>> requirement/idea of generating an ecore model on the basis of the db
>>> relational schema?
>>>
>>> gr. Martin
>>>
>>> Torsten Link wrote:
>>>> Hi all,
>>>>
>>>> I would like to know if ist is possible to use Teneo with an already
>>>> exsiting Database.
>>>> The Database is from a comercial application so it could not be
>>>> altered.
>>>> I would like to extract some of the data and modify it within an EMF
>>>> Application.
>>>>
>>>> For Hibernate there are existing tools for reverse engeniering, but
>>>> it does not fit to EMF ot TENEO.
>>>>
>>>>
>>>> with kind regards
>>>>
>>>>
>>>> Torsten Link
>>>>
>>>
>>
>
>
|
|
|
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #113300 is a reply to message #113235] |
Mon, 25 February 2008 19:57 |
Torsten Link Messages: 51 Registered: July 2009 |
Member |
|
|
Thanks for the quick reply,
I will start with TENEO now.
Torsten Link
jason henriksen wrote:
>
> Hello Torsten,
>
> My client is a large health insurance firm. We are using EMF/Teneo on a
> legacy database with ZERO modifications to the underlying database. You
> do have to handle a couple of things in a slightly strange manner, but
> so far we haven't found anything we cannot overcome. Mostly the
> difficulty depends on how strange your legacy DB is. (We had some very
> odd ball things in our database, but we've still made it work)
>
> Also, I wrote a small script which turns SQL DDL calls into annotated
> XSD. It works very well and only took a couple of days to write. If
> you have a large number of tables to map, this can save a lot of work
> since the script doesn't make any typos.
>
> Hope that helps. Let me know if you have any specific questions and
> I'll tell you if I've run into them yet.
>
> Jason Henriksen
>
>
>
> Martin Taal wrote:
>> Hi Torsten,
>> Ha, okay, Teneo will create additional columns for the following cases:
>> - econtainer relations (can be disabled using an option)
>> - id and version columns (if the types don't have those, can be
>> controlled/disabled by options)
>> - index columns in list elements (can be disabled using
>> options/annotations)
>>
>> So overall I think you should be able to get very far in disabling
>> emf/teneo specific columns. And if you still encounter an issue then I
>> am prepared to look at it and incorporate it in a new build.
>>
>> See the options page for more details:
>> http://www.elver.org/hibernate/options.html
>>
>> Also this page maybe of interest (to control naming of
>> tables/columns/foreign keys):
>> http://www.elver.org/hibernate/extensions.html
>>
>> gr. Martin
>>
>> Torsten Link wrote:
>>> Hi Martin,
>>>
>>> there is a missunderstanding. I would like to know if it is possible
>>> to use TENEO with a existing database which could not be modified.
>>> When I first generate the EMF Model and then let TENEO generate the
>>> database
>>> there are several emf or teneo specific columns in the table. But in my
>>> existing database these columns are not there.
>>>
>>> And before I start learning TENEO and Hibernate I would like to ensure
>>> that it will lead to something usefull.
>>>
>>>
>>> Thanks
>>>
>>>
>>> Torsten
>>>
>>>
>>> Martin Taal wrote:
>>>
>>>> Hi Torsten,
>>>> No there are no reverse engineering tools for Teneo. It is an
>>>> interesting
>>>> topic though. However afaics reverse engineering from a db (for Teneo)
>>>> would also require tools for reverse engineering a db schema to the emf
>>>> model. As (afaics) the emf objects should be based on the relational
>>>> schema. So a relational schema to ecore translator would be the first
>>>> step.
>>>>
>>>> Ed (as you are back from holiday!), have you before seen this
>>>> requirement/idea of generating an ecore model on the basis of the db
>>>> relational schema?
>>>>
>>>> gr. Martin
>>>>
>>>> Torsten Link wrote:
>>>>> Hi all,
>>>>>
>>>>> I would like to know if ist is possible to use Teneo with an already
>>>>> exsiting Database.
>>>>> The Database is from a comercial application so it could not be
>>>>> altered.
>>>>> I would like to extract some of the data and modify it within an EMF
>>>>> Application.
>>>>>
>>>>> For Hibernate there are existing tools for reverse engeniering, but
>>>>> it does not fit to EMF ot TENEO.
>>>>>
>>>>>
>>>>> with kind regards
>>>>>
>>>>>
>>>>> Torsten Link
>>>>>
>>>>
>>>
>>
>>
|
|
| | |
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #615551 is a reply to message #113091] |
Mon, 25 February 2008 06:53 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Hi Torsten,
Ha, okay, Teneo will create additional columns for the following cases:
- econtainer relations (can be disabled using an option)
- id and version columns (if the types don't have those, can be controlled/disabled by options)
- index columns in list elements (can be disabled using options/annotations)
So overall I think you should be able to get very far in disabling emf/teneo specific columns. And
if you still encounter an issue then I am prepared to look at it and incorporate it in a new build.
See the options page for more details:
http://www.elver.org/hibernate/options.html
Also this page maybe of interest (to control naming of tables/columns/foreign keys):
http://www.elver.org/hibernate/extensions.html
gr. Martin
Torsten Link wrote:
> Hi Martin,
>
> there is a missunderstanding. I would like to know if it is possible
> to use TENEO with a existing database which could not be modified.
> When I first generate the EMF Model and then let TENEO generate the database
> there are several emf or teneo specific columns in the table. But in my
> existing database these columns are not there.
>
> And before I start learning TENEO and Hibernate I would like to ensure
> that it will lead to something usefull.
>
>
> Thanks
>
>
> Torsten
>
>
> Martin Taal wrote:
>
>> Hi Torsten,
>> No there are no reverse engineering tools for Teneo. It is an interesting
>> topic though. However afaics reverse engineering from a db (for Teneo)
>> would also require tools for reverse engineering a db schema to the emf
>> model. As (afaics) the emf objects should be based on the relational
>> schema. So a relational schema to ecore translator would be the first
>> step.
>>
>> Ed (as you are back from holiday!), have you before seen this
>> requirement/idea of generating an ecore model on the basis of the db
>> relational schema?
>>
>> gr. Martin
>>
>> Torsten Link wrote:
>>> Hi all,
>>>
>>> I would like to know if ist is possible to use Teneo with an already
>>> exsiting Database.
>>> The Database is from a comercial application so it could not be altered.
>>> I would like to extract some of the data and modify it within an EMF
>>> Application.
>>>
>>> For Hibernate there are existing tools for reverse engeniering, but
>>> it does not fit to EMF ot TENEO.
>>>
>>>
>>> with kind regards
>>>
>>>
>>> Torsten Link
>>>
>>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #615560 is a reply to message #113118] |
Mon, 25 February 2008 18:03 |
Jason Henriksen Messages: 231 Registered: July 2009 |
Senior Member |
|
|
Hello Torsten,
My client is a large health insurance firm. We are using EMF/Teneo on a
legacy database with ZERO modifications to the underlying database. You
do have to handle a couple of things in a slightly strange manner, but
so far we haven't found anything we cannot overcome. Mostly the
difficulty depends on how strange your legacy DB is. (We had some very
odd ball things in our database, but we've still made it work)
Also, I wrote a small script which turns SQL DDL calls into annotated
XSD. It works very well and only took a couple of days to write. If
you have a large number of tables to map, this can save a lot of work
since the script doesn't make any typos.
Hope that helps. Let me know if you have any specific questions and
I'll tell you if I've run into them yet.
Jason Henriksen
Martin Taal wrote:
> Hi Torsten,
> Ha, okay, Teneo will create additional columns for the following cases:
> - econtainer relations (can be disabled using an option)
> - id and version columns (if the types don't have those, can be
> controlled/disabled by options)
> - index columns in list elements (can be disabled using
> options/annotations)
>
> So overall I think you should be able to get very far in disabling
> emf/teneo specific columns. And if you still encounter an issue then I
> am prepared to look at it and incorporate it in a new build.
>
> See the options page for more details:
> http://www.elver.org/hibernate/options.html
>
> Also this page maybe of interest (to control naming of
> tables/columns/foreign keys):
> http://www.elver.org/hibernate/extensions.html
>
> gr. Martin
>
> Torsten Link wrote:
>> Hi Martin,
>>
>> there is a missunderstanding. I would like to know if it is possible
>> to use TENEO with a existing database which could not be modified.
>> When I first generate the EMF Model and then let TENEO generate the
>> database
>> there are several emf or teneo specific columns in the table. But in my
>> existing database these columns are not there.
>>
>> And before I start learning TENEO and Hibernate I would like to ensure
>> that it will lead to something usefull.
>>
>>
>> Thanks
>>
>>
>> Torsten
>>
>>
>> Martin Taal wrote:
>>
>>> Hi Torsten,
>>> No there are no reverse engineering tools for Teneo. It is an
>>> interesting
>>> topic though. However afaics reverse engineering from a db (for Teneo)
>>> would also require tools for reverse engineering a db schema to the emf
>>> model. As (afaics) the emf objects should be based on the relational
>>> schema. So a relational schema to ecore translator would be the first
>>> step.
>>>
>>> Ed (as you are back from holiday!), have you before seen this
>>> requirement/idea of generating an ecore model on the basis of the db
>>> relational schema?
>>>
>>> gr. Martin
>>>
>>> Torsten Link wrote:
>>>> Hi all,
>>>>
>>>> I would like to know if ist is possible to use Teneo with an already
>>>> exsiting Database.
>>>> The Database is from a comercial application so it could not be
>>>> altered.
>>>> I would like to extract some of the data and modify it within an EMF
>>>> Application.
>>>>
>>>> For Hibernate there are existing tools for reverse engeniering, but
>>>> it does not fit to EMF ot TENEO.
>>>>
>>>>
>>>> with kind regards
>>>>
>>>>
>>>> Torsten Link
>>>>
>>>
>>
>
>
|
|
|
Re: [Teneo] newbie question: Using Teneo with Existing Database [message #615565 is a reply to message #113235] |
Mon, 25 February 2008 19:57 |
Torsten Link Messages: 51 Registered: July 2009 |
Member |
|
|
Thanks for the quick reply,
I will start with TENEO now.
Torsten Link
jason henriksen wrote:
>
> Hello Torsten,
>
> My client is a large health insurance firm. We are using EMF/Teneo on a
> legacy database with ZERO modifications to the underlying database. You
> do have to handle a couple of things in a slightly strange manner, but
> so far we haven't found anything we cannot overcome. Mostly the
> difficulty depends on how strange your legacy DB is. (We had some very
> odd ball things in our database, but we've still made it work)
>
> Also, I wrote a small script which turns SQL DDL calls into annotated
> XSD. It works very well and only took a couple of days to write. If
> you have a large number of tables to map, this can save a lot of work
> since the script doesn't make any typos.
>
> Hope that helps. Let me know if you have any specific questions and
> I'll tell you if I've run into them yet.
>
> Jason Henriksen
>
>
>
> Martin Taal wrote:
>> Hi Torsten,
>> Ha, okay, Teneo will create additional columns for the following cases:
>> - econtainer relations (can be disabled using an option)
>> - id and version columns (if the types don't have those, can be
>> controlled/disabled by options)
>> - index columns in list elements (can be disabled using
>> options/annotations)
>>
>> So overall I think you should be able to get very far in disabling
>> emf/teneo specific columns. And if you still encounter an issue then I
>> am prepared to look at it and incorporate it in a new build.
>>
>> See the options page for more details:
>> http://www.elver.org/hibernate/options.html
>>
>> Also this page maybe of interest (to control naming of
>> tables/columns/foreign keys):
>> http://www.elver.org/hibernate/extensions.html
>>
>> gr. Martin
>>
>> Torsten Link wrote:
>>> Hi Martin,
>>>
>>> there is a missunderstanding. I would like to know if it is possible
>>> to use TENEO with a existing database which could not be modified.
>>> When I first generate the EMF Model and then let TENEO generate the
>>> database
>>> there are several emf or teneo specific columns in the table. But in my
>>> existing database these columns are not there.
>>>
>>> And before I start learning TENEO and Hibernate I would like to ensure
>>> that it will lead to something usefull.
>>>
>>>
>>> Thanks
>>>
>>>
>>> Torsten
>>>
>>>
>>> Martin Taal wrote:
>>>
>>>> Hi Torsten,
>>>> No there are no reverse engineering tools for Teneo. It is an
>>>> interesting
>>>> topic though. However afaics reverse engineering from a db (for Teneo)
>>>> would also require tools for reverse engineering a db schema to the emf
>>>> model. As (afaics) the emf objects should be based on the relational
>>>> schema. So a relational schema to ecore translator would be the first
>>>> step.
>>>>
>>>> Ed (as you are back from holiday!), have you before seen this
>>>> requirement/idea of generating an ecore model on the basis of the db
>>>> relational schema?
>>>>
>>>> gr. Martin
>>>>
>>>> Torsten Link wrote:
>>>>> Hi all,
>>>>>
>>>>> I would like to know if ist is possible to use Teneo with an already
>>>>> exsiting Database.
>>>>> The Database is from a comercial application so it could not be
>>>>> altered.
>>>>> I would like to extract some of the data and modify it within an EMF
>>>>> Application.
>>>>>
>>>>> For Hibernate there are existing tools for reverse engeniering, but
>>>>> it does not fit to EMF ot TENEO.
>>>>>
>>>>>
>>>>> with kind regards
>>>>>
>>>>>
>>>>> Torsten Link
>>>>>
>>>>
>>>
>>
>>
|
|
|
Goto Forum:
Current Time: Fri Sep 20 05:44:04 GMT 2024
Powered by FUDForum. Page generated in 0.04229 seconds
|